public static List <tbl_lkp_data> Get_Lkp_tablesdata(int tbllkpid)
 {
     using (OperationsDataContext db = new OperationsDataContext())
     {
         return(db.tbl_lkp_datas.Where(c => c.Lkp_tbl_ID == tbllkpid).OrderBy(c => c.Values).ToList());
     }
 }
 public static List <Usp_Operations_getDataResult> GetData()
 {
     using (OperationsDataContext db = new OperationsDataContext())
     {
         return(db.Usp_Operations_getData().ToList());
     }
 }
 public static List <Usp_Operations_get_addlogResult> GetLogSearchData(string date, string fromdate, string frwd, string mailclerk, string walkin, string licno, string checkno)
 {
     using (OperationsDataContext db = new OperationsDataContext())
     {
         return(db.Usp_Operations_get_addlog(date, fromdate, frwd, mailclerk, walkin, licno, checkno).ToList());
     }
 }
 public static List <tbl_lkp_subobj> Get_Lkp_subobj()
 {
     using (OperationsDataContext db = new OperationsDataContext())
     {
         return(db.tbl_lkp_subobjs.OrderBy(c => c.Description).ToList());
     }
 }
 public static tbl_Add_Log Edit_ManageLogs(int logid)
 {
     using (OperationsDataContext db = new OperationsDataContext())
     {
         return(db.tbl_Add_Logs.Where(c => c.Add_log_ID == logid).SingleOrDefault());
     }
 }
 public static List <Tbl_Login> Get_Lkp_Loginobj()
 {
     using (OperationsDataContext db = new OperationsDataContext())
     {
         return(db.Tbl_Logins.OrderBy(c => c.FirstName).ToList());
     }
 }
 public static List <tbl_Add_Log> Get_Lkp_tables()
 {
     using (OperationsDataContext db = new OperationsDataContext())
     {
         return(db.tbl_Add_Logs.ToList());
     }
 }
Beispiel #8
0
 public static List <USP_GetBalanceAmountInChecksResult> GetBalanceAmount(string chkno)
 {
     using (OperationsDataContext odc = new OperationsDataContext())
     {
         return(odc.USP_GetBalanceAmountInChecks(chkno).ToList());
     }
 }
Beispiel #9
0
 public static List <OperationsLink.tbl_Add_Log> Get_CheckandAmount(string chkno)
 {
     using (OperationsLink.OperationsDataContext odc = new OperationsDataContext())
     {
         return(odc.tbl_Add_Logs.Where(c => c.CheckNumber == chkno).ToList());
     }
 }
Beispiel #10
0
 public static List <USP_getloghistoryResult> Getloghistory(string logid)
 {
     using (OperationsLink.OperationsDataContext odc = new OperationsDataContext())
     {
         return(odc.USP_getloghistory(logid).ToList());
     }
 }
 public static void OperationsDelete(tbl_Add_Log AddLog)
 {
     using (OperationsDataContext dbUpdate = new OperationsDataContext())
     {
         dbUpdate.USP_OperationsAddlog(103, Convert.ToInt32(AddLog.Add_log_ID), null, null, null, null, null, null, null, null, null, null, null, null);
         dbUpdate.SubmitChanges();
     }
 }
 public static void OperationsUpdateValues(tbl_Add_Log AddLog, string uname)
 {
     using (OperationsDataContext dbUpdate = new OperationsDataContext())
     {
         dbUpdate.USP_OperationsAddlog(102, Convert.ToInt32(AddLog.Add_log_ID), AddLog.Date_Received.ToString(), AddLog.From_Received, AddLog.SSN, AddLog.Forward_To, AddLog.MailClerk, AddLog.SpecialEntries, AddLog.PaymentType, AddLog.Amount.ToString(), AddLog.CheckNumber, AddLog.Walkin, AddLog.Feetype, uname);
         dbUpdate.SubmitChanges();
     }
 }
Beispiel #13
0
 public static Boolean validatecheck(string chkno)
 {
     using (OperationsLink.OperationsDataContext opd = new OperationsDataContext())
     {
         List <OperationsLink.tbl_Add_Log> log = opd.tbl_Add_Logs.Where(c => c.CheckNumber == chkno).ToList();
         if (log.Count > 0)
         {
             return(false);
         }
         else
         {
             return(true);
         }
     }
 }