private List <SqlParameter> Set_Values_In_Customer_Quality_Visual_Parameter(CustomerQualityVisualParameterInfo customer_Quality_Visual_Parameter)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Customer_Quality_Id", customer_Quality_Visual_Parameter.Customer_Quality_Id));
sqlParams.Add(new SqlParameter("@Defect_Id", customer_Quality_Visual_Parameter.Defect_Id));
sqlParams.Add(new SqlParameter("@CreatedBy", customer_Quality_Visual_Parameter.CreatedBy));
sqlParams.Add(new SqlParameter("@CreatedOn", customer_Quality_Visual_Parameter.CreatedOn));
sqlParams.Add(new SqlParameter("@UpdatedBy", customer_Quality_Visual_Parameter.UpdatedBy));
sqlParams.Add(new SqlParameter("@UpdatedOn", customer_Quality_Visual_Parameter.UpdatedOn));
return(sqlParams);
}
private CustomerQualityVisualParameterInfo Get_Customer_Quality_Visual_Parameters_Values(DataRow dr)
{
CustomerQualityVisualParameterInfo customer_Quality_Visual_Parameter = new CustomerQualityVisualParameterInfo();
customer_Quality_Visual_Parameter.Customer_Quality_Visual_Parameter_Id = Convert.ToInt32(dr["Customer_Quality_Visual_Parameter_Id"]);
customer_Quality_Visual_Parameter.Customer_Quality_Id = Convert.ToInt32(dr["Customer_Quality_Id"]);
customer_Quality_Visual_Parameter.Defect_Id = Convert.ToInt32(dr["Defect_Id"]);
customer_Quality_Visual_Parameter.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
customer_Quality_Visual_Parameter.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
customer_Quality_Visual_Parameter.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);
customer_Quality_Visual_Parameter.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
customer_Quality_Visual_Parameter.Defect_Name = Convert.ToString(dr["Defect_Name"]);
return(customer_Quality_Visual_Parameter);
}
public void Insert_Customer_Quality_Visual_Parameter(CustomerQualityVisualParameterInfo customer_Quality_Visual_Parameter)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Customer_Quality_Visual_Parameter(customer_Quality_Visual_Parameter), StoredProcedures.Insert_Customer_Quality_Visual_Parameter_Sp.ToString(), CommandType.StoredProcedure);
}
public void Insert_Customer_Quality_Visual_Parameter(CustomerQualityVisualParameterInfo customer_Quality_Visual_Parameter)
{
_customerqualityRepo.Insert_Customer_Quality_Visual_Parameter(customer_Quality_Visual_Parameter);
}
