private SupportingDetailsInfo Get_Supporting_Details_Values(DataRow dr)
{
SupportingDetailsInfo supportingdetails = new SupportingDetailsInfo();
supportingdetails.Supporting_Details_Id = Convert.ToInt32(dr["Supporting_Details_Id"]);
supportingdetails.Enquiry_Id = Convert.ToInt32(dr["Enquiry_Id"]);
supportingdetails.Rate = Convert.ToInt32(dr["Rate"]);
supportingdetails.Customer_Roll_Length = Convert.ToInt32(dr["Customer_Roll_Length"]);
supportingdetails.Packing = Convert.ToInt32(dr["Packing"]);
supportingdetails.Dispatch = Convert.ToInt32(dr["Dispatch"]);
supportingdetails.Additional_Customer_Prop = Convert.ToString(dr["Additional_Customer_Prop"]);
supportingdetails.Source_Of_Enquiry = Convert.ToString(dr["Source_Of_Enquiry"]);
supportingdetails.Is_Active = Convert.ToBoolean(dr["Is_Active"]);
supportingdetails.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
supportingdetails.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
supportingdetails.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);
supportingdetails.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
if (DBNull.Value != dr["Piece_Length_Max"])
{
supportingdetails.Piece_Length_Max = Convert.ToDecimal(dr["Piece_Length_Max"]);
}
if (DBNull.Value != dr["Piece_Length_Min"])
{
supportingdetails.Piece_Length_Min = Convert.ToDecimal(dr["Piece_Length_Min"]);
}
if (DBNull.Value != dr["Two_Part"])
{
supportingdetails.Two_Part = Convert.ToDecimal(dr["Two_Part"]);
}
return(supportingdetails);
}
private List <SqlParameter> Set_Values_In_Supporting_Details(SupportingDetailsInfo supporting_Details)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
if (supporting_Details.Supporting_Details_Id != 0)
{
sqlParams.Add(new SqlParameter("@Supporting_Details_Id", supporting_Details.Supporting_Details_Id));
}
sqlParams.Add(new SqlParameter("@Enquiry_Id", supporting_Details.Enquiry_Id));
sqlParams.Add(new SqlParameter("@Rate", supporting_Details.Rate));
sqlParams.Add(new SqlParameter("@Customer_Roll_Length", supporting_Details.Customer_Roll_Length));
sqlParams.Add(new SqlParameter("@Packing", supporting_Details.Packing));
sqlParams.Add(new SqlParameter("@Dispatch", supporting_Details.Dispatch));
sqlParams.Add(new SqlParameter("@Additional_Customer_Prop", supporting_Details.Additional_Customer_Prop));
sqlParams.Add(new SqlParameter("@Source_Of_Enquiry", supporting_Details.Source_Of_Enquiry));
sqlParams.Add(new SqlParameter("@Is_Active", supporting_Details.Is_Active));
if (supporting_Details.Supporting_Details_Id == 0)
{
sqlParams.Add(new SqlParameter("@CreatedBy", supporting_Details.CreatedBy));
sqlParams.Add(new SqlParameter("@CreatedOn", supporting_Details.CreatedOn));
}
sqlParams.Add(new SqlParameter("@UpdatedBy", supporting_Details.UpdatedBy));
sqlParams.Add(new SqlParameter("@UpdatedOn", supporting_Details.UpdatedOn));
sqlParams.Add(new SqlParameter("@Piece_Length_Max", supporting_Details.Piece_Length_Max));
sqlParams.Add(new SqlParameter("@Piece_Length_Min", supporting_Details.Piece_Length_Min));
sqlParams.Add(new SqlParameter("@Two_Part", supporting_Details.Two_Part));
return(sqlParams);
}
public SupportingDetailsInfo Get_Supporting_Details_By_Enquiry_Id(int enquiry_Id)
{
SupportingDetailsInfo supporting_Details = new SupportingDetailsInfo();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Enquiry_Id", enquiry_Id));
DataTable dt = _sqlRepo.ExecuteDataTable(sqlParams, StoredProcedures.Get_Supporting_Details_By_Enquiry_Id_Sp.ToString(), CommandType.StoredProcedure);
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
supporting_Details = Get_Supporting_Details_Values(dr);
}
return(supporting_Details);
}
public void Update_Supporting_Details(SupportingDetailsInfo supporting_Details)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Supporting_Details(supporting_Details), StoredProcedures.Update_Supporting_Details_Sp.ToString(), CommandType.StoredProcedure);
}
public void Update_Supporting_Details(SupportingDetailsInfo supporting_Details)
{
_enquiryRepo.Update_Supporting_Details(supporting_Details);
}
public void Insert_Supporting_Details(SupportingDetailsInfo supporting_Details)
{
_enquiryRepo.Insert_Supporting_Details(supporting_Details);
}
