public DataTable GetSparepartCategories(SparepartCategory_ML ml)
{
try
{
var DataDic = new Dictionary<string, object>
{
{"@Name", ml.spareCategoryName}
};
return new DBAccessController().RetriveRecordsWithPara(StoredProcedures.sp_GetCategoryDetails, DataDic);
}
catch (System.Exception)
{
throw;
}
}
public bool DeleteSparepartCategory(SparepartCategory_ML ml)
{
try
{
var DataDic = new Dictionary<string, object>
{
{"@Id", ml.spareCategoryId}
};
return new DBAccessController().DeleteRecord(StoredProcedures.sp_RemoveCategory, DataDic);
}
catch (System.Exception)
{
throw;
}
}
public bool AddSparepartCategory(SparepartCategory_ML ml)
{
try
{
var DataDic = new Dictionary<string, object>
{
{"@spareCategoryName", ml.spareCategoryName}
};
return new DBAccessController().InsertRecord(StoredProcedures.sp_AddCategory, DataDic);
}
catch (System.Exception)
{
return false;
throw;
}
}
private void GetCategoryList()
{
try
{
var ml = new SparepartCategory_ML() { spareCategoryName = "" };
ddlCatogaries.DataTextField = "spareCategoryName";
ddlCatogaries.DataValueField = "spareCategoryId";
ddlCatogaries.DataSource = new SparepartCategory_BL().GetSparepartCategories(ml);
ddlCatogaries.DataBind();
}
catch (Exception)
{
throw;
}
}
