private StaggeredOrderInfo Get_Staggered_Order_Values(DataRow dr) { StaggeredOrderInfo staggered_Order = new StaggeredOrderInfo(); staggered_Order.Staggered_Order_Id = Convert.ToInt32(dr["Staggered_Order_Id"]); staggered_Order.Enquiry_Id = Convert.ToInt32(dr["Enquiry_Id"]); staggered_Order.Order_No = Convert.ToString(dr["Order_No"]); staggered_Order.Order_Status = Convert.ToInt32(dr["Order_Status"]); staggered_Order.Quantity = Convert.ToInt32(dr["Quantity"]); staggered_Order.Delivery_Date = Convert.ToDateTime(dr["Delivery_Date"]); staggered_Order.Is_Active = Convert.ToBoolean(dr["Is_Active"]); staggered_Order.CreatedBy = Convert.ToInt32(dr["CreatedBy"]); staggered_Order.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]); staggered_Order.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]); staggered_Order.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]); return(staggered_Order); }
public StaggeredOrderInfo Get_Staggered_Order_By_Id(int staggered_Order_Id) { StaggeredOrderInfo staggered_Order = new StaggeredOrderInfo(); List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@Staggered_Order_Id", staggered_Order_Id)); DataTable dt = _sqlRepo.ExecuteDataTable(sqlParams, StoredProcedures.Get_Staggered_Order_By_Id_Sp.ToString(), CommandType.StoredProcedure); List <DataRow> drList = new List <DataRow>(); drList = dt.AsEnumerable().ToList(); foreach (DataRow dr in drList) { staggered_Order = Get_Staggered_Order_Values(dr); } return(staggered_Order); }
private List <SqlParameter> Set_Values_In_Staggered_Order(StaggeredOrderInfo staggered_Order) { List <SqlParameter> sqlParams = new List <SqlParameter>(); if (staggered_Order.Staggered_Order_Id != 0) { sqlParams.Add(new SqlParameter("@Staggered_Order_Id", staggered_Order.Staggered_Order_Id)); } sqlParams.Add(new SqlParameter("@Enquiry_Id", staggered_Order.Enquiry_Id)); sqlParams.Add(new SqlParameter("@Order_No", staggered_Order.Order_No)); sqlParams.Add(new SqlParameter("@Order_Status", staggered_Order.Order_Status)); sqlParams.Add(new SqlParameter("@Quantity", staggered_Order.Quantity)); sqlParams.Add(new SqlParameter("@Delivery_Date", staggered_Order.Delivery_Date)); sqlParams.Add(new SqlParameter("@Is_Active", staggered_Order.Is_Active)); if (staggered_Order.Staggered_Order_Id == 0) { sqlParams.Add(new SqlParameter("@CreatedBy", staggered_Order.CreatedBy)); sqlParams.Add(new SqlParameter("@CreatedOn", staggered_Order.CreatedOn)); } sqlParams.Add(new SqlParameter("@UpdatedBy", staggered_Order.UpdatedBy)); sqlParams.Add(new SqlParameter("@UpdatedOn", staggered_Order.UpdatedOn)); return(sqlParams); }
public void Update_Staggered_Order(StaggeredOrderInfo staggeredorder) { _sqlRepo.ExecuteNonQuery(Set_Values_In_Staggered_Order(staggeredorder), StoredProcedures.Update_Staggered_Order_Sp.ToString(), CommandType.StoredProcedure); }
public void Update_Staggered_Order(StaggeredOrderInfo staggeredorder) { _enquiryRepo.Update_Staggered_Order(staggeredorder); }
public void Insert_Staggered_Order(StaggeredOrderInfo staggeredorder) { _enquiryRepo.Insert_Staggered_Order(staggeredorder); }