public CustomerQualityInfo Get_Customer_Quality_By_Id(int customer_Quality_Id)
{
CustomerQualityInfo customer_Quality = new CustomerQualityInfo();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Customer_Quality_Id", customer_Quality_Id));
DataSet ds = _sqlRepo.ExecuteDataSet(sqlParams, StoredProcedures.Get_Customer_Quality_By_Id_Sp.ToString(), CommandType.StoredProcedure);
DataTable dt = ds.Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
foreach (DataRow dr in drList)
{
customer_Quality = Get_Customer_Quality_Values_By_Id(dr);
}
}
return(customer_Quality);
}
private CustomerQualityInfo Get_Customer_Quality_Values(DataRow dr)
{
CustomerQualityInfo customer_Quality = new CustomerQualityInfo();
customer_Quality.Customer_Quality_Id = Convert.ToInt32(dr["Customer_Quality_Id"]);
customer_Quality.Customer_Id = Convert.ToInt32(dr["Customer_Id"]);
customer_Quality.Quality_Id = Convert.ToInt32(dr["Quality_Id"]);
customer_Quality.Customer_Roll_Length = Convert.ToString(dr["Customer_Roll_Length"]);
customer_Quality.Storage = Convert.ToString(dr["Storage"]);
customer_Quality.Transport = Convert.ToString(dr["Transport"]);
customer_Quality.Lot_Testing = Convert.ToString(dr["Lot_Testing"]);
customer_Quality.End_Product_Criteria = Convert.ToString(dr["End_Product_Criteria"]);
customer_Quality.Testing_Requirements = Convert.ToString(dr["Testing_Requirements"]);
customer_Quality.Inspection_Requirements = Convert.ToString(dr["Inspection_Requirements"]);
customer_Quality.Process_Control = Convert.ToString(dr["Process_Control"]);
customer_Quality.Sample_Id = Convert.ToInt32(dr["Sample_Id"]);
customer_Quality.Special_Care_Details = Convert.ToString(dr["Special_Care_Details"]);
customer_Quality.Special_Requirements_Material_Handling = Convert.ToString(dr["Special_Requirements_Material_Handling"]);
customer_Quality.Special_Requirements_Packaging = Convert.ToString(dr["Special_Requirements_Packaging"]);
customer_Quality.Special_Requirements_Defect_Defination = Convert.ToString(dr["Special_Requirements_Defect_Defination"]);
customer_Quality.Special_Requirements_Verdicting = Convert.ToString(dr["Special_Requirements_Verdicting"]);
customer_Quality.Is_Active = Convert.ToBoolean(dr["Is_Active"]);
customer_Quality.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
customer_Quality.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
customer_Quality.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
customer_Quality.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);
customer_Quality.Customer.Customer_Name = Convert.ToString(dr["Customer_Name"]);
customer_Quality.Quality.Quality_No = Convert.ToInt32(dr["Quality_No"]);
//customer_Quality.Sample.Sample_No = Convert.ToInt32(dr["Sample_No"]);
return(customer_Quality);
}
public int Insert_Customer_Quality(CustomerQualityInfo customer_Quality)
{
int customer_Quality_Id = 0;
customer_Quality_Id = Convert.ToInt32(_sqlRepo.ExecuteScalerObj(Set_Values_In_Customer_Quality(customer_Quality), StoredProcedures.Insert_Customer_Quality_Sp.ToString(), CommandType.StoredProcedure));
return(customer_Quality_Id);
}
public CustomerQualityViewModel()
{
Friendly_Message = new List <FriendlyMessageInfo>();
Pager = new PaginationInfo();
Customer_Quality = new CustomerQualityInfo();
Customer_Qualities = new List <CustomerQualityInfo>();
Filter = new CustomerQualityFilter();
Attachment = new AttachmentsInfo();
Attachments = new List <AttachmentsInfo>();
}
private List <SqlParameter> Set_Values_In_Customer_Quality(CustomerQualityInfo customer_Quality)
{
List <SqlParameter> sqlparam = new List <SqlParameter>();
if (customer_Quality.Customer_Quality_Id != 0)
{
sqlparam.Add(new SqlParameter("@Customer_Quality_Id", customer_Quality.Customer_Quality_Id));
}
sqlparam.Add(new SqlParameter("@Customer_Id", customer_Quality.Customer_Id));
sqlparam.Add(new SqlParameter("@Quality_Id", customer_Quality.Quality_Id));
sqlparam.Add(new SqlParameter("@Sample_Id", customer_Quality.Sample_Id));
sqlparam.Add(new SqlParameter("@Is_Active", customer_Quality.Is_Active));
if (customer_Quality.Customer_Quality_Id == 0)
{
sqlparam.Add(new SqlParameter("@CreatedOn", customer_Quality.CreatedOn));
sqlparam.Add(new SqlParameter("@CreatedBy", customer_Quality.CreatedBy));
}
sqlparam.Add(new SqlParameter("@UpdatedOn", customer_Quality.UpdatedOn));
sqlparam.Add(new SqlParameter("@UpdatedBy", customer_Quality.UpdatedBy));
return(sqlparam);
}
private List <SqlParameter> Set_Updated_Values_In_Customer_Quality(CustomerQualityInfo customer_Quality)
{
List <SqlParameter> sqlparam = new List <SqlParameter>();
if (customer_Quality.Customer_Quality_Id != 0)
{
sqlparam.Add(new SqlParameter("@Customer_Quality_Id", customer_Quality.Customer_Quality_Id));
}
sqlparam.Add(new SqlParameter("@Customer_Id", customer_Quality.Customer_Id));
sqlparam.Add(new SqlParameter("@Quality_Id", customer_Quality.Quality_Id));
sqlparam.Add(new SqlParameter("@Customer_Roll_Length", customer_Quality.Customer_Roll_Length));
sqlparam.Add(new SqlParameter("@Storage", customer_Quality.Storage));
sqlparam.Add(new SqlParameter("@Transport", customer_Quality.Transport));
sqlparam.Add(new SqlParameter("@Lot_Testing", customer_Quality.Lot_Testing));
sqlparam.Add(new SqlParameter("@End_Product_Criteria", customer_Quality.End_Product_Criteria));
sqlparam.Add(new SqlParameter("@Testing_Requirements", customer_Quality.Testing_Requirements));
sqlparam.Add(new SqlParameter("@Inspection_Requirements", customer_Quality.Inspection_Requirements));
sqlparam.Add(new SqlParameter("@Process_Control", customer_Quality.Process_Control));
//sqlparam.Add(new SqlParameter("@Sample_Id", customer_Quality.Customer_Sample_No));
sqlparam.Add(new SqlParameter("@Sample_Id", customer_Quality.Sample_Id));
sqlparam.Add(new SqlParameter("@Special_Care_Details", customer_Quality.Special_Care_Details));
sqlparam.Add(new SqlParameter("@Special_Requirements_Material_Handling", customer_Quality.Special_Requirements_Material_Handling));
sqlparam.Add(new SqlParameter("@Special_Requirements_Packaging", customer_Quality.Special_Requirements_Packaging));
sqlparam.Add(new SqlParameter("@Special_Requirements_Defect_Defination", customer_Quality.Special_Requirements_Defect_Defination));
sqlparam.Add(new SqlParameter("@Special_Requirements_Verdicting", customer_Quality.Special_Requirements_Verdicting));
sqlparam.Add(new SqlParameter("@Is_Active", customer_Quality.Is_Active));
if (customer_Quality.Customer_Quality_Id == 0)
{
sqlparam.Add(new SqlParameter("@CreatedOn", customer_Quality.CreatedOn));
sqlparam.Add(new SqlParameter("@CreatedBy", customer_Quality.CreatedBy));
}
sqlparam.Add(new SqlParameter("@UpdatedOn", customer_Quality.UpdatedOn));
sqlparam.Add(new SqlParameter("@UpdatedBy", customer_Quality.UpdatedBy));
return(sqlparam);
}
public void Update_Customer_Quality(CustomerQualityInfo customer_Quality)
{
_sqlRepo.ExecuteNonQuery(Set_Updated_Values_In_Customer_Quality(customer_Quality), StoredProcedures.Update_Customer_Quality_Sp.ToString(), CommandType.StoredProcedure);
}
public void Update_Customer_Quality(CustomerQualityInfo customer_Quality)
{
_customerqualityRepo.Update_Customer_Quality(customer_Quality);
}
public int Insert_Customer_Quality(CustomerQualityInfo customer_Quality)
{
return(_customerqualityRepo.Insert_Customer_Quality(customer_Quality));
}
