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