public ActionResult UpdateUser(FormCollection collection) { try { string UID = collection.Get("UserID"); string password = collection.Get("password"); string name = collection.Get("name"); string sur_name = collection.Get("sur_name"); string Typ = collection.Get("Typ"); string dept = collection.Get("Dept"); string isAdmin = collection.Get("IsDeptAdmin"); string RON = collection.Get("RO_Name"); string Activate = collection.Get("Activate"); using (LoanDataDataContext udatabase = new LoanDataDataContext()) { Sys_User usr = udatabase.Sys_Users.FirstOrDefault(u => u.id == long.Parse(UID)); usr.password = RmsEncryption.Encrypt(password); usr.sur_name = sur_name; usr.name = name; usr.RO_Name = RON; if (!string.IsNullOrEmpty(Typ)) { usr.Typ = short.Parse(Typ); } if (!string.IsNullOrEmpty(dept)) { usr.Dept = int.Parse(dept); } if (!string.IsNullOrEmpty(isAdmin)) { usr.IsDeptAdmin = isAdmin.ToLower() == "true" ? true : false; } if (!string.IsNullOrEmpty(Activate)) { usr.Activate = Activate.ToLower() == "true" ? true : false; } udatabase.SubmitChanges(); } var jsonObj = new { test = "User Has Been Updated" }; return(Json(new { message = jsonObj }, JsonRequestBehavior.AllowGet)); } catch (Exception exc) { var jsonObj = new { Error = exc.Message }; return(Json(new { message = jsonObj }, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateDept(FormCollection collection) { try { string id = collection.Get("ID"); string name = collection.Get("Name"); string note = collection.Get("Note"); using (LoanDataDataContext udatabase = new LoanDataDataContext()) { Sys_Dept act = udatabase.Sys_Depts.FirstOrDefault(u => u.ID == int.Parse(id)); act.Name = name; act.Note = note; udatabase.SubmitChanges(); } var jsonObj = new { test = "Department Has Been Updated" }; return(Json(jsonObj)); } catch (Exception exc) { var jsonObj = new { Error = exc.Message }; return(Json(jsonObj)); } }
public ActionResult CreateDept(FormCollection collection) { try { string name = collection.Get("Name"); string note = collection.Get("Note"); using (LoanDataDataContext udatabase = new LoanDataDataContext()) { Sys_Dept act = new Sys_Dept(); act.Name = name; act.Note = note; udatabase.Sys_Depts.InsertOnSubmit(act); udatabase.SubmitChanges(); } var jsonObj = new { test = "Department Has Been Created" }; return(Json(jsonObj)); } catch (Exception exc) { var jsonObj = new { Error = exc.Message }; return(Json(jsonObj)); } }
public ActionResult InsertFollowUp(FormCollection collection) { try { using (LoanDataDataContext database = new LoanDataDataContext()) { Daily_Follow_Up followUp = new Daily_Follow_Up(); long cID = 0; long.TryParse(collection.Get("TrackID"), out cID); followUp.Tracks_ID = cID; followUp.User_Follow = 1; followUp.Follow_Date = DateTime.Now; followUp.Follow_Action = int.Parse(collection.Get("Follow_Action")); followUp.Follow_Note = collection.Get("Follow_Note"); followUp.Remainder_Date = DateTime.Parse(collection.Get("Remainder_Date"));// DateTime.ParseExact(collection.Get("Remainder_Date"), "dd/MM/yyyy", null);// DateTime.Parse(); followUp.Remainder_Note = collection.Get("Remainder_Note"); // track.Tracking_USER = long.Parse(collection.Get("Tracking_USER")); database.Daily_Follow_Ups.InsertOnSubmit(followUp); database.SubmitChanges(); } var jsonObj = new { Message = "Follow Up inserted suc" }; return(Json(jsonObj)); } catch (Exception ex) { var jsonObj = new { Error = ex.Message }; return(Json(jsonObj)); } }
public ActionResult CreateAction(FormCollection collection) { try { string name = collection.Get("Name"); string code = collection.Get("ACTION_CODE"); int type = int.Parse(collection.Get("ActionType")); using (LoanDataDataContext udatabase = new LoanDataDataContext()) { LoanManagement.Models.Action act = new LoanManagement.Models.Action(); act.Name = name; act.ACTION_CODE = code; act.ActionType = type; udatabase.Actions.InsertOnSubmit(act); udatabase.SubmitChanges(); } var jsonObj = new { test = "Action Has Been Created" }; return(Json(jsonObj)); } catch (Exception exc) { var jsonObj = new { Error = exc.Message }; return(Json(jsonObj)); } }
public ActionResult GetLegalProcedure(long LegID) { using (LoanDataDataContext database = new LoanDataDataContext()) { // var loan = from d in database.Client_Loan_Infos select d; //This work sucess var lp = (from d in database.Legal_Procedures where d.LegalRepID == LegID select d); string result = string.Empty; string temp = @"<tr legproitem='true'> <td> <span type='text' >{desc}</span> </td> <td> <span type='text' >{pro}</span> </td></tr>"; foreach (var item in lp) { string it = temp; it = it.Replace("{desc}", item.Legal_Desc); it = it.Replace("{pro}", item.Proced); result += it; } var res = new { htdata = result }; return(Json(res, JsonRequestBehavior.AllowGet));; } }
public ActionResult GetDataToAddFollow(long TrackID) { List <Daily_Follow_Up> loan_res = new List <Daily_Follow_Up>(); using (LoanDataDataContext database = new LoanDataDataContext()) { // var loan = from d in database.Client_Loan_Infos select d; //This work sucess var loan = (from d in database.Tracks join cl in database.Client_Loan_Infos on d.ClientLoanID equals cl.ID join li in database.Loan_Infos on cl.LoanID equals li.ID // join c in database.CLIENT_PERINFOs on cl.ClientID equals c.ID join g in database.Guarantees_Infos on cl.GuaranteesID equals g.ID where d.ID == TrackID select new { ID = d.ID, Client_Info = ClientManagementController.GetLastClientDataObj(cl.ID), Client_Loan_Info = cl, Loan_Info = li, guarant = g, tracks = d, dat_down = li.Date_Downgrading.Value.ToShortDateString() }).FirstOrDefault(); return(Json(loan, JsonRequestBehavior.AllowGet)); } }
public ActionResult CloseLoan(FormCollection collection) { try { using (LoanDataDataContext database = new LoanDataDataContext()) { long cID = 0; long.TryParse(collection.Get("TrackID"), out cID); Track cl = database.Tracks.FirstOrDefault(c => c.ID == cID); if (cl != null) { cl.Status = 5; database.SubmitChanges(); } // track.Tracking_USER = long.Parse(collection.Get("Tracking_USER")); var noaction = new { Message = "OK" }; return(Json(noaction)); } } catch (Exception ex) { var jsonObj = new { Error = ex.Message }; return(Json(jsonObj)); } }
public ActionResult GetLoanHistory(string accID) { using (LoanDataDataContext database = new LoanDataDataContext()) { // var loan = from d in database.Client_Loan_Infos select d; //This work sucess var lp = (from d in database.Tracking_Histories where d.Account_ID == accID select d); string result = string.Empty; string temp = @"<tr histitem='true'> <td> <span type='text' >{desc}</span> </td> <td> <span type='text' >{pro}</span> </td></tr>"; foreach (var item in lp) { string it = temp; it = it.Replace("{desc}", item.Tacking_Date.Value.ToShortDateString()); it = it.Replace("{pro}", item.Tracking_Notes); result += it; } var res = new { htdata = result }; return(Json(res, JsonRequestBehavior.AllowGet));; } }
// GET: /ClientManagement/ public ActionResult GetLastClientData(long loanID) { ArrayList lst = new ArrayList(); using (LoanDataDataContext database = new LoanDataDataContext()) { var cl = from d in database.Client_Loan_Infos join c in database.CLIENT_PERINFOs on d.ClientID equals c.ID where d.ID == loanID select c; lst.AddRange(cl.ToList()); var updclient = (from up in database.CLIENT_INFOUPDs where cl.ToList().FirstOrDefault().ID == up.CLIENTID select up).OrderByDescending(u => u.ID).ToList(); var result = new { FULLNAME = cl.FirstOrDefault().FULLNAME, ADDR = string.IsNullOrEmpty(updclient.FirstOrDefault().ADDR) ? cl.FirstOrDefault().ADDR : updclient.FirstOrDefault().ADDR, MOBILE = string.IsNullOrEmpty(updclient.FirstOrDefault().MOBILE) ? cl.FirstOrDefault().MOBILE : updclient.FirstOrDefault().MOBILE, TEL = string.IsNullOrEmpty(updclient.FirstOrDefault().TEL) ? cl.FirstOrDefault().TEL : updclient.FirstOrDefault().TEL, ADDITIONINFO = string.IsNullOrEmpty(updclient.FirstOrDefault().ADDITIONINFO) ? cl.FirstOrDefault().ADDITIONINFO : updclient.FirstOrDefault().ADDITIONINFO, ACCOUNTID = cl.FirstOrDefault().AccountID }; return(Json(result, JsonRequestBehavior.AllowGet)); } var jsonObj = new { Message = "Error Exception Occur" }; return(Json(jsonObj, JsonRequestBehavior.AllowGet)); }
//here to get all users public ActionResult GetUserToGrid(string sidx, string sord, int page, int rows, string filters) { // List<Sys_User> depts = new List<Sys_User>(); using (LoanDataDataContext database = new LoanDataDataContext()) { var usr = (from d in database.Sys_Users // join dep in database.Sys_Depts on d.Dept equals dep.ID where d.id != 1 select new { id = d.id, user_name = d.user_name, name = d.name, dept_name = database.Sys_Depts.FirstOrDefault(dep => dep.ID == d.Dept) != null ? database.Sys_Depts.FirstOrDefault(dep => dep.ID == d.Dept).Name : "", IsDeptAdmin = d.IsDeptAdmin, RO_Name = d.RO_Name, RO_Code = d.RO_Code, Activate = d.Activate }).ToList(); // depts.AddRange(usr.ToList()); if (!string.IsNullOrEmpty(filters)) { var search = filters.Split('&'); if (!string.IsNullOrEmpty(search[0])) { var temp = from l in usr where l.user_name == search[0] select l; //loan = loan.Select(l=>l.Client_Acc==AccID).ToList(); usr = temp.ToList(); } if (!string.IsNullOrEmpty(search[1])) { var temp = from l in usr where l.RO_Code == search[1] select l; //loan = loan.Select(l=>l.Client_Acc==AccID).ToList(); usr = temp.ToList(); } } int pageIndex = Convert.ToInt32(page) - 1; int pageSize = rows; int totalRecords = usr.Count(); var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); usr = usr.Skip(pageIndex * pageSize).Take(pageSize).ToList(); var jsonData = new { total = totalPages, page, records = totalRecords, rows = usr }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } }
public ActionResult getRoTrack(string searchTerm) { using (LoanDataDataContext udatabase = new LoanDataDataContext()) { var res = from r in udatabase.Sys_Users where r.name.Contains(searchTerm) && (r.Typ == 2 || r.Typ == 3)select new { id = r.id, text = r.name + "_" + (r.RO_Code != null ? r.RO_Code : "") }; return(Json(res.ToList(), JsonRequestBehavior.AllowGet)); } }
public ActionResult getDeptsForUser(string searchTerm) { using (LoanDataDataContext udatabase = new LoanDataDataContext()) { var res = from r in udatabase.Sys_Depts where r.Name.Contains(searchTerm) select new { id = r.ID, text = r.Name }; return(Json(res.ToList(), JsonRequestBehavior.AllowGet)); } }
public ActionResult getFollowAction(string searchTerm) { using (LoanDataDataContext udatabase = new LoanDataDataContext()) { var res = from r in udatabase.Actions where r.Name.Contains(searchTerm) && r.ActionType == 2 select new { id = r.ID, text = r.Name }; return(Json(res.ToList(), JsonRequestBehavior.AllowGet)); } }
public ActionResult getLegal(string searchTerm) { using (LoanDataDataContext udatabase = new LoanDataDataContext()) { var res = from r in udatabase.Sys_Users where r.Typ == 4 select new { id = r.id, text = r.name }; return(Json(res.ToList(), JsonRequestBehavior.AllowGet)); } }
public ActionResult GetGuruantees(string ACCID) { using (LoanDataDataContext database = new LoanDataDataContext()) { // var loan = from d in database.Client_Loan_Infos select d; //This work sucess var lp = (from d in database.Guarantees_Infos where d.AccountID == ACCID select d); string result = string.Empty; string temp = @"<tr guranrowitem='true'> <td> <span type='text' >{Gurantee_Type}</span> </td> <td> <span type='text' >{Applicant_Name}</span> </td> <td> <span type='text'>{Applicant_Account}</span> </td> <td> <span type='text' >{Estimated_Amount}</span> </td> <td> <span type='text' >{Estimate_date}</span> </td> <td> <span type='text' >{Initial_Amount}</span> </td> <td> <span type='text' >{Gurantee_Description}</span> </td> </tr>"; foreach (var item in lp) { string it = temp; it = it.Replace("{Gurantee_Type}", item.Gurantee_Type); it = it.Replace("{Applicant_Name}", item.Applicant_Name); it = it.Replace("{Applicant_Account}", item.Applicant_Account); it = it.Replace("{Estimated_Amount}", item.Estimated_Amount); it = it.Replace("{Estimate_date}", item.Estimate_date.Value.ToShortDateString()); it = it.Replace("{Initial_Amount}", item.Initial_Amount); it = it.Replace("{Gurantee_Description}", item.Gurantee_Description); result += it; } var res = new { htdata = result }; return(Json(res, JsonRequestBehavior.AllowGet));; } }
public ActionResult InsertNewClientInfo(FormCollection collection) { try { //update from abd using (LoanDataDataContext database = new LoanDataDataContext()) { string accountID = collection.Get("ACCOUNTID"); var clients = from cl in database.CLIENT_PERINFOs where cl.AccountID == accountID select cl; foreach (var item in clients) { CLIENT_INFOUPD upd = new CLIENT_INFOUPD(); long cID = 0; long.TryParse(collection.Get("TrackID"), out cID); upd.TRACID = cID; upd.ADDR1 = collection.Get("ADDR1"); upd.ADDR2 = collection.Get("ADDR2"); upd.ADDR3 = collection.Get("ADDR3"); upd.Another_Address = collection.Get("Another_Address"); upd.Another_Mobile = collection.Get("Another_Mobile"); upd.Another_TEL = collection.Get("Another_TEL"); DateTime rDate = new DateTime(); upd.CLIENTID = item.ID;//long.Parse(collection.Get("CLIENTID")); upd.DATE_UPD = DateTime.Now; // track.Tracking_USER = long.Parse(collection.Get("Tracking_USER")); upd.ADDITIONINFO = collection.Get("ADDITIONINFO"); upd.MOBILE = collection.Get("MOBILE"); upd.TEL = collection.Get("TEL"); upd.USR_REC = long.Parse(TGSession.ClientInfo.UID); database.CLIENT_INFOUPDs.InsertOnSubmit(upd); database.SubmitChanges(); item.Another_Address = upd.Another_Address; item.Another_Mobile = upd.Another_Mobile; item.Another_TEL = upd.Another_TEL; database.SubmitChanges(); } } var jsonObj = new { Message = "Client Info Updated" }; return(Json(jsonObj, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { var jsonObj = new { Message = ex.Message }; return(Json(jsonObj, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetDataToAssignGrid(string sidx, string sord, int page, int rows, string filters) { int id = 0; if (int.TryParse(filters, out id)) { List <Client_Loan_Info> loan_res = new List <Client_Loan_Info>(); using (LoanDataDataContext database = new LoanDataDataContext()) { var selectedRo = database.Sys_Users.FirstOrDefault(x => x.id == id); var allLoans = (from d in database.Client_Loan_Infos select new { ID = d.ID, Client_Acc = database.Loan_Infos.FirstOrDefault(de => de.ID == d.LoanID).AccountID, Client_Name = database.CLIENT_PERINFOs.FirstOrDefault(cin => cin.ID == d.ClientID).FULLNAME, Status = database.Tracks.FirstOrDefault(t => t.ClientLoanID == d.ID) != null ? database.Status.FirstOrDefault(s => s.ID == database.Tracks.FirstOrDefault(t => t.ClientLoanID == d.ID).Status).Name : "Not Assigned", Track_ID = database.Tracks.FirstOrDefault(t => t.ClientLoanID == d.ID) != null ? database.Tracks.FirstOrDefault(t => t.ClientLoanID == d.ID).ID : 0, Branch = (database.Loan_Infos.FirstOrDefault(c => c.ID == d.LoanID).Branch != null) ? database.Loan_Infos.FirstOrDefault(c => c.ID == d.LoanID).Branch : "Not specified", Tracking_Date = (database.Tracks.Where(c => c.ClientLoanID == d.ID).ToList().Count > 0) ? database.Tracks.Where(c => c.ClientLoanID == d.ID).OrderByDescending(r => r.Tracking_Date.Value).FirstOrDefault().Tracking_Date : null, StatusID = database.Tracks.FirstOrDefault(t => t.ClientLoanID == d.ID) != null ? database.Status.FirstOrDefault(s => s.ID == database.Tracks.FirstOrDefault(t => t.ClientLoanID == d.ID).Status).ID : 1, RO = database.Tracks.FirstOrDefault(t => t.ClientLoanID == d.ID) != null ? database.Sys_Users.FirstOrDefault(s => s.id == database.Tracks.FirstOrDefault(t => t.ClientLoanID == d.ID).CurrTraker).RO_Code : "No Trackers", }); var loan = allLoans.ToList().Where(x => x.RO == selectedRo.RO_Code).ToList(); int pageIndex = Convert.ToInt32(page) - 1; int pageSize = rows; int totalRecords = loan.Count(); var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); loan = loan.Skip(pageIndex * pageSize).Take(pageSize).ToList(); var jsonData = new { total = totalPages, page, records = totalRecords, rows = loan }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } } else { return(Json(null, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetActionByID(int aID) { using (LoanDataDataContext database = new LoanDataDataContext()) { var track = (from d in database.Actions where d.ID == aID select d).FirstOrDefault(); return(Json(track)); } }
public ActionResult GetLoanDataToGrid(string sidx, string sord, int page, int rows, string filters) { using (LoanDataDataContext database = new LoanDataDataContext()) { // var loan = from d in database.Client_Loan_Infos select d; //This work sucess long uid = 0; if (!string.IsNullOrEmpty(filters)) { uid = long.Parse(filters); } var follow = (from d in database.Tracks join cl in database.Client_Loan_Infos on d.ClientLoanID equals cl.ID join l in database.Loan_Infos on cl.LoanID equals l.ID join c in database.CLIENT_PERINFOs on cl.ClientID equals c.ID //join track in database.Sys_Users on d.CurrTraker equals track.id where d.CurrTraker == uid select new { ID = d.ID, Account_ID = cl.AccountID, Client_Name = c.FULLNAME, Track_Note = l.Note, Tracking_Date = d.Tracking_Date.Value.ToShortDateString(), NO_Follow = database.Daily_Follow_Ups.Where(df => df.Tracks_ID == d.ID).ToList().Count, NO_Call = database.Daily_Follow_Ups.Where((df => df.Tracks_ID == d.ID && df.Follow_Action == database.Actions.FirstOrDefault(ac => ac.ACTION_CODE == "CALL").ID)).ToList().Count, NO_Visit = database.Daily_Follow_Ups.Where((df => df.Tracks_ID == d.ID && df.Follow_Action == database.Actions.FirstOrDefault(ac => ac.ACTION_CODE == "VISIT").ID)).ToList().Count, Status = database.Status.FirstOrDefault(s => s.ID == d.Status).Name }).ToList(); int pageIndex = Convert.ToInt32(page) - 1; int pageSize = rows; int totalRecords = follow.Count(); var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); follow = follow.Skip(pageIndex * pageSize).Take(pageSize).ToList(); var jsonData = new { total = totalPages, page, records = totalRecords, rows = follow }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetDeptByID(long uID) { using (LoanDataDataContext database = new LoanDataDataContext()) { var track = (from d in database.Sys_Depts where d.ID == uID select d).FirstOrDefault(); return(Json(track)); } }
public ActionResult GetCasesDataToGrid(string sidx, string sord, int page, int rows, string filters) { using (LoanDataDataContext database = new LoanDataDataContext()) { // var loan = from d in database.Client_Loan_Infos select d; // long uid = long.Parse(TGSession.ClientInfo.UID); //This work sucess var loan = (from d in database.Legal_Reports select d).ToList(); if (!string.IsNullOrEmpty(filters)) { var search = filters.Split('&'); if (!string.IsNullOrEmpty(search[0])) { var temp = from l in loan where l.AccountID == search[0] select l; //loan = loan.Select(l=>l.Client_Acc==AccID).ToList(); loan = temp.ToList(); } if (!string.IsNullOrEmpty(search[1])) { var temp = from l in loan where l.Lawer.Contains(search[1]) select l; //loan = loan.Select(l=>l.Client_Acc==AccID).ToList(); loan = temp.ToList(); } } int pageIndex = Convert.ToInt32(page) - 1; int pageSize = rows; int totalRecords = loan.Count(); var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); loan = loan.Skip(pageIndex * pageSize).Take(pageSize).ToList(); var jsonData = new { total = totalPages, page, records = totalRecords, rows = loan }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } }
// GetAllDataToGrid // public ActionResult GetAllClientData(string sidx, string sord, int page, int rows, string filters) { try { long loanID = 0; if (!string.IsNullOrEmpty(filters)) { loanID = long.Parse(filters); } ArrayList lst = new ArrayList(); using (LoanDataDataContext database = new LoanDataDataContext()) { var cl = from d in database.Tracks join ci in database.Client_Loan_Infos on d.ClientLoanID equals ci.ID join c in database.CLIENT_PERINFOs on ci.ClientID equals c.ID where d.ID == loanID select c; lst.AddRange(cl.ToList()); var updclient = (from up in database.CLIENT_INFOUPDs where cl.ToList().FirstOrDefault().ID == up.CLIENTID select up).OrderByDescending(u => u.ID).ToList(); // lst.AddRange(updclient.Skip(1).ToList()); lst.AddRange(updclient.ToList()); } int pageIndex = Convert.ToInt32(page) - 1; int pageSize = rows; int totalRecords = lst.Count; var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); //lst = lst.ToArray().Skip(pageIndex * pageSize).Take(pageSize).; var jsonData = new { total = totalPages, page, records = totalRecords, rows = lst }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { var jsonObj = new { Message = ex.Message }; return(Json(jsonObj, JsonRequestBehavior.AllowGet)); } }
public ActionResult RedirectToFollowUp(string clientId) { //abd alrahman// using (var db = new LoanDataDataContext()) { var clientLoanInfos = db.Client_Loan_Infos.Where(x => x.AccountID == clientId).ToList(); foreach (var cli in clientLoanInfos) { cli.Read_Note = true; } db.SubmitChanges(); } return(Json(new { clientId = clientId }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetDataToGridAddFollow(string sidx, string sord, int page, int rows, string filters) { using (LoanDataDataContext database = new LoanDataDataContext()) { // var loan = from d in database.Client_Loan_Infos select d; //This work sucess long tid = 0; if (!string.IsNullOrEmpty(filters)) { tid = long.Parse(filters); } var follow = (from f in database.Daily_Follow_Ups join us in database.Sys_Users on f.User_Follow equals us.id where f.Tracks_ID == tid select new { ID = f.ID, Follow_Date = f.Follow_Date, Follow_Action = database.Actions.FirstOrDefault(a => a.ID == f.Follow_Action).Name, Follow_Note = f.Follow_Note, Remainder_Date = f.Remainder_Date, Remainder_Note = f.Remainder_Note, RO_Name = us.RO_Name }).ToList(); int pageIndex = Convert.ToInt32(page) - 1; int pageSize = rows; int totalRecords = follow.Count(); var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); follow = follow.Skip(pageIndex * pageSize).Take(pageSize).ToList(); var jsonData = new { total = totalPages, page, records = totalRecords, rows = follow }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetActionsToGrid(string sidx, string sord, int page, int rows, string filters) { // List<Sys_User> depts = new List<Sys_User>(); using (LoanDataDataContext database = new LoanDataDataContext()) { var usr = (from d in database.Actions select d).ToList(); // depts.AddRange(usr.ToList()); if (!string.IsNullOrEmpty(filters)) { var search = filters.Split('&'); if (!string.IsNullOrEmpty(search[0])) { var temp = from l in usr where l.Name == search[0] select l; //loan = loan.Select(l=>l.Client_Acc==AccID).ToList(); usr = temp.ToList(); } if (!string.IsNullOrEmpty(search[1])) { var temp = from l in usr where l.ActionType.ToString() == search[1] select l; //loan = loan.Select(l=>l.Client_Acc==AccID).ToList(); usr = temp.ToList(); } } int pageIndex = Convert.ToInt32(page) - 1; int pageSize = rows; int totalRecords = usr.Count(); var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); usr = usr.Skip(pageIndex * pageSize).Take(pageSize).ToList(); var jsonData = new { total = totalPages, page, records = totalRecords, rows = usr }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); } }
public ActionResult ReceivePapers(FormCollection collection) { try { using (LoanDataDataContext database = new LoanDataDataContext()) { long uid = long.Parse(TGSession.ClientInfo.UID); long cID = 0; long.TryParse(collection.Get("LegalNoteID"), out cID); var papers = collection.Get("papers"); // var legalID = collection.Get("papers"); TemplateData[] res = JsonConvert.DeserializeObject <TemplateData[]>(papers); var papersRec = from p in database.Legal_Papers where p.LegalNoteID == cID select p; foreach (var item in papersRec) { var pap = from r in res where long.Parse(r.id) == item.ID select r; if (pap.ToList().Count > 0) { Legal_Paper updPaper = database.Legal_Papers.FirstOrDefault(p => p.ID == item.ID); updPaper.IsRecived = true; database.SubmitChanges(); } } var legalNote = database.LegalNotes.FirstOrDefault(l => l.ID == cID); legalNote.LegalID = uid; var track = (from t in database.Tracks where t.ID == legalNote.TrakID select t).FirstOrDefault(); if (track != null) { track.LegalReceivDate = DateTime.Now; track.SendLegalState = 3; track.Status = 3; database.SubmitChanges(); } } var jsonObj = new { Message = "Legal Info Sended" }; return(Json(jsonObj)); } catch (Exception ex) { var jsonObj = new { Message = ex.Message }; return(Json(jsonObj)); } }
public ActionResult GetLegalNote(string LegID) { using (LoanDataDataContext database = new LoanDataDataContext()) { // var loan = from d in database.Client_Loan_Infos select d; //This work sucess var loan = (from d in database.Legal_Reports where d.AccountID == LegID select d).FirstOrDefault(); return(Json(loan, JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteUser(FormCollection collection) { try { string UID = collection.Get("id"); using (LoanDataDataContext udatabase = new LoanDataDataContext()) { Sys_User usr = udatabase.Sys_Users.FirstOrDefault(u => u.id == long.Parse(UID)); udatabase.Sys_Users.DeleteOnSubmit(usr); udatabase.SubmitChanges(); } return(Json("Success", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json("Error", JsonRequestBehavior.AllowGet)); } }
public ActionResult SendDataToLegal(FormCollection collection) { try { using (LoanDataDataContext database = new LoanDataDataContext()) { LegalNote upd = new LegalNote(); long cID = 0; long.TryParse(collection.Get("TrakID"), out cID); upd.TrakID = cID; upd.EmpNotes = collection.Get("EmpNotes"); var papers = collection.Get("papers"); TemplateData[] res = JsonConvert.DeserializeObject <TemplateData[]>(papers); // upd.LegalID = long.Parse(collection.Get("legalID")); upd.TrakerID = long.Parse(TGSession.ClientInfo.UID); upd.Legal_Action = collection.Get("Legal_Action"); upd.SendingDate = DateTime.Now; Track tr = database.Tracks.FirstOrDefault(t => t.ID == cID); tr.SendLegalState = 2; database.LegalNotes.InsertOnSubmit(upd); database.SubmitChanges(); foreach (var item in res) { Legal_Paper paper = new Legal_Paper(); paper.LegalNoteID = upd.ID; paper.paperName = item.text; database.Legal_Papers.InsertOnSubmit(paper); database.SubmitChanges(); } } var jsonObj = new { Message = "Legal Info Sended" }; return(Json(jsonObj)); } catch (Exception ex) { var jsonObj = new { Message = ex.Message }; return(Json(jsonObj)); } }