private List <SqlParameter> Set_Values_In_Complaint_Lot_Mapping(ComplaintLotMappingInfo complaint_Lot_Mapping)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Complaint_Id", complaint_Lot_Mapping.Complaint_Id));
sqlParams.Add(new SqlParameter("@Lot_No", complaint_Lot_Mapping.Lot_No));
sqlParams.Add(new SqlParameter("@CreatedOn", complaint_Lot_Mapping.CreatedOn));
sqlParams.Add(new SqlParameter("@CreatedBy", complaint_Lot_Mapping.CreatedBy));
sqlParams.Add(new SqlParameter("@UpdatedOn", complaint_Lot_Mapping.UpdatedOn));
sqlParams.Add(new SqlParameter("@UpdatedBy", complaint_Lot_Mapping.UpdatedBy));
return(sqlParams);
}
private ComplaintLotMappingInfo Get_Complaint_Lot_Mapping_Values(DataRow dr)
{
ComplaintLotMappingInfo complaint_Lot_Mapping = new ComplaintLotMappingInfo();
complaint_Lot_Mapping.Complaint_Lot_Id = Convert.ToInt32(dr["Complaint_Lot_Id"]);
complaint_Lot_Mapping.Complaint_Id = Convert.ToInt32(dr["Complaint_Id"]);
complaint_Lot_Mapping.Lot_No = Convert.ToInt32(dr["Lot_No"]);
complaint_Lot_Mapping.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
complaint_Lot_Mapping.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
complaint_Lot_Mapping.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
complaint_Lot_Mapping.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);
return(complaint_Lot_Mapping);
}
public void Insert_Complaint_Lot_Mapping(ComplaintLotMappingInfo complaint_Lot_Mapping)
{
_cRepo.Insert_Complaint_Lot_Mapping(complaint_Lot_Mapping);
}
public void Insert_Complaint_Lot_Mapping(ComplaintLotMappingInfo complaint_Lot_Mapping)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Complaint_Lot_Mapping(complaint_Lot_Mapping), StoredProcedures.Insert_Complaint_Lot_Mapping_Sp.ToString(), CommandType.StoredProcedure);
}