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));
}
}
