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()); } }
public static List <USP_GetBalanceAmountInChecksResult> GetBalanceAmount(string chkno) { using (OperationsDataContext odc = new OperationsDataContext()) { return(odc.USP_GetBalanceAmountInChecks(chkno).ToList()); } }
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()); } }
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(); } }
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); } } }