private List <SqlParameter> Set_Values_In_Temp_Visual_Parameters(TempVisualParametersInfo temp_Visual_Parameters)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Enquiry_Id", temp_Visual_Parameters.Enquiry_Id));
sqlParams.Add(new SqlParameter("@Defect_Id", temp_Visual_Parameters.Defect_Id));
sqlParams.Add(new SqlParameter("@CreatedBy", temp_Visual_Parameters.CreatedBy));
sqlParams.Add(new SqlParameter("@CreatedOn", temp_Visual_Parameters.CreatedOn));
sqlParams.Add(new SqlParameter("@UpdatedBy", temp_Visual_Parameters.UpdatedBy));
sqlParams.Add(new SqlParameter("@UpdatedOn", temp_Visual_Parameters.UpdatedOn));
return(sqlParams);
}
private TempVisualParametersInfo Get_Temp_Visual_Parameters_Values(DataRow dr)
{
TempVisualParametersInfo temp_Visual_Parameters = new TempVisualParametersInfo();
temp_Visual_Parameters.Temp_Visual_Parameters_Id = Convert.ToInt32(dr["Temp_Visual_Parameters_Id"]);
temp_Visual_Parameters.Enquiry_Id = Convert.ToInt32(dr["Enquiry_Id"]);
temp_Visual_Parameters.Defect_Id = Convert.ToInt32(dr["Defect_Id"]);
temp_Visual_Parameters.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
temp_Visual_Parameters.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
temp_Visual_Parameters.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);
temp_Visual_Parameters.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
temp_Visual_Parameters.Defect_Name = Convert.ToString(dr["Defect_Name"]);
return(temp_Visual_Parameters);
}
public void Insert_Temp_Visual_Parameters(TempVisualParametersInfo temp_Visual_Parameters)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Temp_Visual_Parameters(temp_Visual_Parameters), StoredProcedures.Insert_Temp_Visual_Parameters_Sp.ToString(), CommandType.StoredProcedure);
}
public void Insert_Temp_Visual_Parameters(TempVisualParametersInfo temp_Visual_Parameters)
{
_enquiryRepo.Insert_Temp_Visual_Parameters(temp_Visual_Parameters);
}
