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)); }