private List <SqlParameter> Set_Values_In_Temp_Functional_Parameters(TempFunctionalParametersInfo temp_Functional_Parameters)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Enquiry_Id", temp_Functional_Parameters.Enquiry_Id));
sqlParams.Add(new SqlParameter("@Test_Id", temp_Functional_Parameters.Test_Id));
sqlParams.Add(new SqlParameter("@CreatedBy", temp_Functional_Parameters.CreatedBy));
sqlParams.Add(new SqlParameter("@CreatedOn", temp_Functional_Parameters.CreatedOn));
sqlParams.Add(new SqlParameter("@UpdatedBy", temp_Functional_Parameters.UpdatedBy));
sqlParams.Add(new SqlParameter("@UpdatedOn", temp_Functional_Parameters.UpdatedOn));
return(sqlParams);
}
private TempFunctionalParametersInfo Get_Temp_Functional_Parameters_Values(DataRow dr)
{
TempFunctionalParametersInfo temp_Functional_Parameters = new TempFunctionalParametersInfo();
temp_Functional_Parameters.Temp_Functional_Parameters_Id = Convert.ToInt32(dr["Temp_Functional_Parameters_Id"]);
temp_Functional_Parameters.Enquiry_Id = Convert.ToInt32(dr["Enquiry_Id"]);
temp_Functional_Parameters.Test_Id = Convert.ToInt32(dr["Test_Id"]);
temp_Functional_Parameters.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
temp_Functional_Parameters.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
temp_Functional_Parameters.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);
temp_Functional_Parameters.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
temp_Functional_Parameters.Test_Name = Convert.ToString(dr["Test_Name"]);
return(temp_Functional_Parameters);
}
public void Insert_Temp_Functional_Parameters(TempFunctionalParametersInfo temp_Functional_Parameters)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Temp_Functional_Parameters(temp_Functional_Parameters), StoredProcedures.Insert_Temp_Functional_Parameters_Sp.ToString(), CommandType.StoredProcedure);
}
public void Insert_Temp_Functional_Parameters(TempFunctionalParametersInfo temp_Functional_Parameters)
{
_enquiryRepo.Insert_Temp_Functional_Parameters(temp_Functional_Parameters);
}
