public ClsOrder GetOrderById(long lgId) { ClsOrder objClsOrder = new ClsOrder(); try { using (this.objDataContext = new OrderDataContext(Functions.StrConnection)) { GetOrderByIdResult item = this.objDataContext.GetOrderById(lgId).ToList().FirstOrDefault(); if (item != null) { objClsOrder.lgId = item.Id; objClsOrder.strName = item.Name; objClsOrder.lgOrderCategoryId = item.OrderCategoryId ?? 0; objClsOrder.hdnstrUserIds = item.UserIds; } } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Order, mySession.Current.UserId); } return(objClsOrder); }
public List <SearchOrderResult> SearchOrder(int inRow, int inPage, string strSearch, string strSort) { try { using (this.objDataContext = new OrderDataContext(Functions.StrConnection)) { return(this.objDataContext.SearchOrder(inRow, inPage, strSort, strSearch).ToList()); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Order, mySession.Current.UserId); return(null); } }
public DeleteOrderResult DeleteOrder(string strOrderId, long lgDeletedBy) { try { using (this.objDataContext = new OrderDataContext(Functions.StrConnection)) { DeleteOrderResult result = this.objDataContext.DeleteOrder(strOrderId, lgDeletedBy, PageMaster.OrderCategory).FirstOrDefault(); if (result == null) { result = new DeleteOrderResult(); } return(result); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.Order, mySession.Current.UserId); return(null); } }
public long SaveOrder(ClsOrder objSave) { try { using (TransactionScope scope = new TransactionScope()) { using (this.objDataContext = new OrderDataContext(Functions.StrConnection)) { var result = this.objDataContext.InsertOrUpdateOrder(objSave.lgId, objSave.strName, mySession.Current.UserId, objSave.lgOrderCategoryId, objSave.hdnstrUserIds, PageMaster.Order.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.Order, mySession.Current.UserId); return(0); } }