below code
string constr = @"Data Source=CHLAPDVENCHAL\SQLEXPRESS;Initial Catalog=AdPlanner;Integrated security=true";
using (SqlConnection conn = new SqlConnection(constr))
{
// using (SqlConnection conn = new SqlConnection())
//{
// conn.ConnectionString = "Server=CHLAPDVENCHAL\\SQLEXPRESS;Database=AdPlanner;
Integrated Security=True";
// using the code here...
// conn.Open();
// SqlConnection con = new SqlConnection("Data Source= CHLAPDVENCHAL\\SQLEXPRESS;Initial Catalog=AdPlanner;Integrated Security=True;");
SqlCommand cmd = new SqlCommand("InsertInputfieldconfig", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@AccountID", inputfieldconfigModel.AccountId);
cmd.Parameters.AddWithValue("@RegionfieldConfig", inputfieldconfigModel.Region);
cmd.Parameters.AddWithValue("@MarketfieldConfig", inputfieldconfigModel.MarketModel);
cmd.Parameters.AddWithValue("@StorefieldConfig", inputfieldconfigModel.StoreModel);
cmd.Parameters.AddWithValue("@ItemfieldConfig", inputfieldconfigModel.ItemModel);
cmd.Parameters.AddWithValue("@ItemPricefieldConfig", inputfieldconfigModel.ItemPriceModel);
cmd.Parameters.AddWithValue("@PGroupfieldConfig", inputfieldconfigModel.PGroupModel);
cmd.Parameters.AddWithValue("@OfferfieldConfig", inputfieldconfigModel.OfferModel);
cmd.Parameters.AddWithValue("@CreatedBy", inputfieldconfigModel.CreatedBy);
cmd.Parameters.AddWithValue("@QueryType", inputfieldconfigModel.QueryType);
cmd.Parameters.AddWithValue("@CreatedOn", inputfieldconfigModel.CreatedOn);
int k = cmd.ExecuteNonQuery();
if (k != 0)
{
return new Response
{
Message = "Record Inserted Succesfully into the Database", IsError = true };
}
else
{
return new Response
{
Message = "Error", IsError = true };
}
Model
public class inputfields
{
public int AccountId { get; set; }
public int IfcID { get; set; }
public string? CreatedBy { get; set; }
public string? QueryType { get; set; }
public DateTime? CreatedOn { get; set; }
public Region Region { get; set; }
public StoreModel StoreModel { get; set; }
public MarketModel MarketModel { get; set; }
public ItemPriceModel ItemPriceModel { get; set; }
public ItemModel ItemModel { get; set; }
public PGroupModel PGroupModel { get; set; }
public OfferModel OfferModel { get; set; }
}
public class Region
{
public List CommonFields { get; set; }
public List CustomFields { get; set; }
}
public class CommonFieldsModel
{
public string FieldName { get; set; }
public bool Visibility { get; set; }
public string DisplayName { get; set;
}
public bool RequiredInIngestion { get; set; }
}
public class CustomFieldsModel
{
public string FieldName { get; set; }
public string ControlType { get; set; }
public string ControlTypeLable { get; set; }
public string DisplayName { get; set; }
public string DataType { get; set; }
public string DataTypeLable { get; set; }
public string FieldLength { get; set; }
public string Tooltip { get; set; }
public string IsMandatory { get; set; }
public string IsReadonly { get; set; }
public string isDeleted { get; set; }
public string ErrorMessage { get; set; }
public string IsMultiSelect { get; set; }
public string Value { get; set; }
public string Options { get; set; }
}