public List <SubCategoryInfo> SelectAllSubCategoryInfo()
{
try
{
List <SubCategoryInfo> lstSubCategoryInfo = new List <SubCategoryInfo>();
using (RMSDataContext db = new RMSDataContext())
{
var hp = (from sc in db.SubCategories select sc).ToList();
foreach (var one in hp)
{
SubCategoryInfo scObj = new SubCategoryInfo();
scObj.SubCategoryID = one.SubCategoryID;
scObj.Type = one.Type;
scObj.Description = one.Description;
scObj.CategoryID = one.CategoryID;
//scObj.InsertedDate = one.InsertedDate;
lstSubCategoryInfo.Add(scObj);
}
return(lstSubCategoryInfo);
}
}
catch (Exception ex)
{
return(new List <SubCategoryInfo>());
}
}
public void DeleteSubCategoryBySubCategoryID(SubCategoryInfo SCInfo)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
var obj = (from a in db.SubCategories where a.SubCategoryID == SCInfo.SubCategoryID select a).First();
db.SubCategories.DeleteOnSubmit(obj);
db.SubmitChanges();
}
}
catch (Exception ex)
{
SubCategory tbl = new SubCategory();
}
}
public void UpdateSubCategoryBySubCategoryID(SubCategoryInfo SCInfo)
{
try
{
using (RMSDataContext db = new RMSDataContext())
{
var obj = (from a in db.SubCategories where a.SubCategoryID == SCInfo.SubCategoryID select a).First();
obj.SubCategoryID = SCInfo.SubCategoryID;
obj.Type = SCInfo.Type;
obj.Description = SCInfo.Description;
obj.CategoryID = SCInfo.CategoryID;
db.SubmitChanges();
}
}
catch (Exception ex)
{
SubCategory tbl = new SubCategory();
}
}
public void DeleteSubCategory(SubCategoryInfo SCInfo)
{
scDao.DeleteSubCategoryBySubCategoryID(SCInfo);
}
public void UpdateSubCategory(SubCategoryInfo SCInfo)
{
scDao.UpdateSubCategoryBySubCategoryID(SCInfo);
}
public void InsertSubCategory(SubCategoryInfo SCInfo)
{
}
