Esempio n. 1
0
 public static List <SelectListModel> GetChequeNoByAccNo(int AccId, bool isAllCheque)
 {
     try
     {
         if (AccId > 0)
         {
             myshop = new MyshopDb();
             var result = (
                 from bc in myshop.Gbl_Master_BankCheque.Where(pay => pay.IsDeleted == false && pay.BankAccId.Equals(AccId) && pay.ShopId == WebSession.ShopId)
                 from cb in myshop.Gbl_Master_BankChequeDetails.Where(y => y.IsDeleted == false && (isAllCheque == true || y.IsUsed == false) && bc.ChequeId.Equals(y.ChequeBookId))
                 orderby cb.ChequeNo
                 select new SelectListModel
             {
                 Text = cb.ChequeNo.ToString(),
                 Value = cb.ChequePageId
             }
                 ).ToList();
             var venList = myshop.Gbl_Master_BankCheque.Where(pay => pay.IsDeleted == false && pay.BankAccId.Equals(AccId) && pay.ShopId == WebSession.ShopId).ToList();
             if (result.Count > 0)
             {
                 return(result);
             }
             else
             {
                 return(GlobalMethod.GetSingleSelectList());
             }
         }
         else
         {
             throw new Exception();
         }
     }
     catch (Exception ex)
     {
         return(GlobalMethod.GetSingleSelectList());
     }
     finally
     {
         if (myshop != null)
         {
             myshop = null;
         }
     }
 }
Esempio n. 2
0
 public static List <SelectListModel> GetProUnit(int SubCatId)
 {
     try
     {
         myshop = new MyshopDb();
         List <SelectListModel> list = new List <SelectListModel>();
         var unitList = (from pro in myshop.Gbl_Master_Product.Where(pro => pro.ShopId.Equals(WebSession.ShopId) && pro.IsDeleted == false && pro.SubCatId == SubCatId)
                         from unt in myshop.Gbl_Master_Unit.Where(un => un.UnitId.Equals(pro.UnitId))
                         orderby unt.UnitName
                         select new SelectListModel
         {
             Text = unt.UnitName,
             Value = unt.UnitId
         }
                         ).ToList();
         if (unitList.Count > 0)
         {
             return(list);
         }
         else
         {
             return(GlobalMethod.GetSingleSelectList());
         }
     }
     catch (Exception ex)
     {
         return(GlobalMethod.GetSingleSelectList());
     }
     finally
     {
         if (myshop != null)
         {
             myshop = null;
         }
     }
 }