public int InsertPOBOrder(OrderFulfillment.OrderList obj, string subDomainName)
{
int row = 0;
List <OrderFulfillment.Oredertvp> Acc = JsonConvert.DeserializeObject <List <OrderFulfillment.Oredertvp> >(obj.Product).ToList();
OrderFulfillment.DateCapturingModel objdate = JsonConvert.DeserializeObject <OrderFulfillment.DateCapturingModel>(obj.date);
if (!(objdate.Off_Set.Contains('+') && !(objdate.Off_Set.Contains('-'))))
{
objdate.Off_Set = '+' + objdate.Off_Set.Trim();
}
// List<OrderFulfillment.DateCapturingModel> objdate = JsonConvert.DeserializeObject<List<OrderFulfillment.DateCapturingModel>>(obj.date).ToList();
try
{
using (IDbConnection connection = IDbOpenConnectionCompanyWise(subDomainName))
{
var p = new DynamicParameters();
p.Add("@CompanyID", obj.Company_Id);
//p.Add("@ClaimCode", claimCode);
p.Add("@User_Code", obj.UserCode);
p.Add("@Region_Code", obj.Region_Code);
p.Add("@Customer_Code", obj.Customer_Code);
p.Add("@Customer_Name", obj.Customer_Name);
p.Add("@Category", obj.Category);
p.Add("@Speciality_Name", obj.Speciality_Name);
p.Add("@MDL_Number", obj.MDL_Number);
p.Add("@Customer_Entity_Type", obj.Customer_Entity_Type);
p.Add("@Stockiest_Code", obj.Stockiest_Code);
p.Add("@DueDate", obj.DueDate);
p.Add("@Created_Date", objdate.Date);
p.Add("@Created_TimeZone", objdate.TimeZone);
p.Add("@Created_OffSet", objdate.Off_Set);
p.Add("@UTC_Date", objdate.UTC_Date);
p.Add("@remark", obj.remark);
p.Add("@OldOrder_Id", obj.Order_Id);
p.Add("@TVP_InsertPOBDetails", ToDataTable(Acc).AsTableValuedParameter());
// p.Add("@Result", 0, DbType.Int32, ParameterDirection.Output);
//connection.Execute("SP_OD_InsertPOBOrder", p, commandType: CommandType.StoredProcedure);
//row = p.Get<int>("@Result");
//connection.Close();
p.Add("@Result", 0, DbType.Int32, ParameterDirection.Output);
connection.Query <int>("SP_OD_InsertPOBOrder", p, commandType: CommandType.StoredProcedure);
row = p.Get <int>("@Result");
}
return(row);
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertPOBOrder(OrderFulfillment.OrderList obj)
{
int result = 0;
return(result = _blOrder.InsertPOBOrder(obj, obj.subDomainName));
}
public int InsertPOBOrder(OrderFulfillment.OrderList obj, string subDomainName)
{
return(DAL_Order.InsertPOBOrder(obj, subDomainName));
}
