public DefectTypeInfo Get_Defects_Type_By_Id(int Defect_Type_Id)
{
DefectTypeInfo retVal = new DefectTypeInfo();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Defect_Type_Id", Defect_Type_Id));
DataTable dt = _sqlRepo.ExecuteDataTable(sqlParams, StoredProcedures.Get_Defect_Type_By_Id_sp.ToString(), CommandType.StoredProcedure);
if (dt != null && dt.Rows.Count > 0)
{
int count = 0;
List <DataRow> drList = new List <DataRow>();
drList = dt.AsEnumerable().ToList();
count = drList.Count();
foreach (DataRow dr in drList)
{
retVal = (Get_Defect_Type_Values(dr));
}
}
return(retVal);
}
public DefectTypeInfo Get_Defect_Type_By_Id(int Defect_Type_Id)
{
DefectTypeInfo defectInfo = new DefectTypeInfo();
DefectTypeRepo dRepo = new DefectTypeRepo();
defectInfo = dRepo.Get_Defects_Type_By_Id(Defect_Type_Id);
return(defectInfo);
}
public DefectTypeViewModel()
{
DefectType = new DefectTypeInfo();
DefectTypeGrid = new List <DefectTypeInfo>();
EditMode = new Defect_Type_Edit_Mode();
Filter = new Defect_Type_Filter();
Pager = new PaginationInfo();
Friendly_Message = new List <FriendlyMessageInfo>();
}
private List <SqlParameter> Set_Values_In_Defect_Type(DefectTypeInfo defectInfo)
{
List <SqlParameter> sqlParamList = new List <SqlParameter>();
sqlParamList.Add(new SqlParameter("@Defect_Type_Name", defectInfo.Defect_Type_Name));
sqlParamList.Add(new SqlParameter("@Status", defectInfo.Status));
sqlParamList.Add(new SqlParameter("@UpdatedBy", defectInfo.UpdatedBy));
if (defectInfo.Defect_Type_Id == 0)
{
sqlParamList.Add(new SqlParameter("@CreatedBy", defectInfo.CreatedBy));
}
if (defectInfo.Defect_Type_Id != 0)
{
sqlParamList.Add(new SqlParameter("@Defect_Type_Id", defectInfo.Defect_Type_Id));
}
return(sqlParamList);
}
private DefectTypeInfo Get_Defect_Type_Values(DataRow dr)
{
DefectTypeInfo defectTypes = new DefectTypeInfo();
defectTypes.Defect_Type_Id = Convert.ToInt32(dr["Defect_Type_Id"]);
defectTypes.Defect_Type_Name = Convert.ToString(dr["Defect_Type_Name"]);
defectTypes.Status = Convert.ToBoolean(dr["Status"]);
defectTypes.CreatedBy = Convert.ToInt32(dr["CreatedBy"]);
defectTypes.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]);
defectTypes.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]);
defectTypes.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]);
return(defectTypes);
}
public void Update(DefectTypeInfo defect)
{
DefectTypeRepo dRepo = new DefectTypeRepo();
dRepo.Update(defect);
}
public void Insert(DefectTypeInfo defect)
{
DefectTypeRepo dRepo = new DefectTypeRepo();
dRepo.Insert(defect);
}
public void Update(DefectTypeInfo defectTypes)
{
_sqlRepo.ExecuteNonQuery(Set_Values_In_Defect_Type(defectTypes), StoredProcedures.Update_Defect_Type_sp.ToString(), CommandType.StoredProcedure);
}
