private CustomerQualityFunctionalParameterInfo Get_Customer_Quality_Functional_Parameters_Values(DataRow dr)
{
CustomerQualityFunctionalParameterInfo customer_Quality_Functional_Parameter = new CustomerQualityFunctionalParameterInfo();
customer_Quality_Functional_Parameter.Customer_Quality_Functional_Parameter_Id = Convert.ToInt32(dr["Customer_Quality_Functional_Parameter_Id"]);
customer_Quality_Functional_Parameter.Customer_Quality_Id = Convert.ToInt32(dr["Customer_Quality_Id"]);
customer_Quality_Functional_Parameter.Test_Id = Convert.ToInt32(dr["Test_Id"]);
customer_Quality_Functional_Parameter.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
customer_Quality_Functional_Parameter.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
customer_Quality_Functional_Parameter.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);
customer_Quality_Functional_Parameter.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
customer_Quality_Functional_Parameter.Test_Name = Convert.ToString(dr["Test_Name"]);
return(customer_Quality_Functional_Parameter);
}
//
public void Insert_Customer_Quality_Functional_Parameter(CustomerQualityFunctionalParameterInfo customer_Quality_Functional_Parameter)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Customer_Quality_Functional_Parameter(customer_Quality_Functional_Parameter), StoredProcedures.Insert_Customer_Quality_Functional_Parameter_Sp.ToString(), CommandType.StoredProcedure);
}
private List <SqlParameter> Set_Values_In_Customer_Quality_Functional_Parameter(CustomerQualityFunctionalParameterInfo customer_Quality_Functional_Parameter)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Customer_Quality_Id", customer_Quality_Functional_Parameter.Customer_Quality_Id));
sqlParams.Add(new SqlParameter("@Test_Id", customer_Quality_Functional_Parameter.Test_Id));
sqlParams.Add(new SqlParameter("@CreatedBy", customer_Quality_Functional_Parameter.CreatedBy));
sqlParams.Add(new SqlParameter("@CreatedOn", customer_Quality_Functional_Parameter.CreatedOn));
sqlParams.Add(new SqlParameter("@UpdatedBy", customer_Quality_Functional_Parameter.UpdatedBy));
sqlParams.Add(new SqlParameter("@UpdatedOn", customer_Quality_Functional_Parameter.UpdatedOn));
return(sqlParams);
}
public void Insert_Customer_Quality_Functional_Parameter(CustomerQualityFunctionalParameterInfo customer_Quality_Functional_Parameter)
{
_customerqualityRepo.Insert_Customer_Quality_Functional_Parameter(customer_Quality_Functional_Parameter);
}
