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