public List <SelectListItem> GetAllOrderCategoryForDropDown()
{
List <SelectListItem> lstOrderCategory = new List <SelectListItem>();
try
{
using (this.objDataContext = new OrderCategoryDataContext(Functions.StrConnection))
{
lstOrderCategory.Add(new SelectListItem {
Text = "--Select--", Value = string.Empty
});
List <GetOrderCategoryAllResult> lstOrderCategoryResult = this.objDataContext.GetOrderCategoryAll().ToList();
if (lstOrderCategoryResult != null && lstOrderCategoryResult.Count > 0)
{
foreach (var item in lstOrderCategoryResult)
{
lstOrderCategory.Add(new SelectListItem {
Text = item.Name, Value = item.Id.ToString()
});
}
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.OrderCategory, mySession.Current.UserId);
}
return(lstOrderCategory);
}
public List <SearchOrderCategoryResult> SearchOrderCategory(int inRow, int inPage, string strSearch, string strSort)
{
try
{
using (this.objDataContext = new OrderCategoryDataContext(Functions.StrConnection))
{
return(this.objDataContext.SearchOrderCategory(inRow, inPage, strSort, strSearch).ToList());
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.OrderCategory, mySession.Current.UserId);
return(null);
}
}
public bool IsOrderCategoryExists(long lgOrderCategoryId, string strName)
{
try
{
using (this.objDataContext = new OrderCategoryDataContext(Functions.StrConnection))
{
if (this.objDataContext.OrderCategories.Where(x => x.Id != lgOrderCategoryId && x.Name == strName && x.IsDeleted == false).Count() > 0)
{
return(true);
}
}
return(false);
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.OrderCategory, mySession.Current.UserId);
return(false);
}
}
public DeleteOrderCategoryResult DeleteOrderCategory(string strOrderCategoryId, long lgDeletedBy)
{
try
{
using (this.objDataContext = new OrderCategoryDataContext(Functions.StrConnection))
{
DeleteOrderCategoryResult result = this.objDataContext.DeleteOrderCategory(strOrderCategoryId, lgDeletedBy, PageMaster.OrderCategory).FirstOrDefault();
if (result == null)
{
result = new DeleteOrderCategoryResult();
}
return(result);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.OrderCategory, mySession.Current.UserId);
return(null);
}
}
public ClsOrderCategory GetOrderCategoryById(long lgId)
{
ClsOrderCategory objClsOrderCategory = new ClsOrderCategory();
try
{
using (this.objDataContext = new OrderCategoryDataContext(Functions.StrConnection))
{
GetOrderCategoryByIdResult item = this.objDataContext.GetOrderCategoryById(lgId).ToList().FirstOrDefault();
if (item != null)
{
objClsOrderCategory.lgId = item.Id;
objClsOrderCategory.strName = item.Name;
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.OrderCategory, mySession.Current.UserId);
}
return(objClsOrderCategory);
}
public long SaveOrderCategory(ClsOrderCategory objSave)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
using (this.objDataContext = new OrderCategoryDataContext(Functions.StrConnection))
{
var result = this.objDataContext.InsertOrUpdateOrderCategory(objSave.lgId, objSave.strName, mySession.Current.UserId, objSave.blIsActive, PageMaster.OrderCategory.ToString().intSafe()).FirstOrDefault();
if (result != null)
{
objSave.lgId = result.InsertedId;
}
scope.Complete();
}
return(objSave.lgId);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.OrderCategory, mySession.Current.UserId);
return(0);
}
}
