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