public bool LoginBase(USER_LOGIN model, int Position) { bool OK = false; Data_OPDataContext Context = new Data_OPDataContext(); Data_UserDataContext Context_user = new Data_UserDataContext(); if (Position == 1) { var queryX = Context.MAS_WHs.Where(x => x.WHCODE == model.WHCODE && x.WHCODE == model.PASSWORD).Count(); if (queryX > 0) { OK = true; } } else { var queryX = Context_user.MAS_USERs.Where(x => x.STCODE == model.STCODE && x.PASSWORD == model.PASSWORD).Count(); if (queryX > 0) { OK = true; } } return(OK); }
public ActionResult updatedid(USER_LOGIN model) { Dp_List ul = new Dp_List(); Data_UserDataContext db = new Data_UserDataContext(); ul.STCODE = model.STCODE; ul.JT_LIST = new SelectList(db.MAS_DEPs, "DP_ID", "DEPARTMENT"); return(View(ul)); }
public string GetStname(string _stcode) { string value = string.Empty; using (Data_UserDataContext db = new Data_UserDataContext()) { var stname = db.MAS_USERs.Where(s => s.STCODE == _stcode).FirstOrDefault(); value = stname.FNAME + " " + stname.LNAME; } return(value); }
public ActionResult Manage_Partial(int page = 1, string sh = "") { Detail cc = new Detail(); cc.STCODE = userOnline; cc.sh = sh; //cc.Ticket_ID = Id; //var restClient = new RestClient("http://5cosmeda.homeunix.com:89/Ticket_OP/api/TicketOP/Ticketlist"); var restClient = new RestClient("http://5cosmeda.homeunix.com:89/Ticket_LE/api/TicketLE/Manage_Partial"); var request = new RestRequest(Method.POST); request.RequestFormat = DataFormat.Json; request.AddJsonBody(cc); var response = restClient.Execute(request); var json = response.Content; JsonDeserializer deserial = new JsonDeserializer(); List <ListUserLogin> items = JsonConvert.DeserializeObject <List <ListUserLogin> >(json); var Ans = items.FirstOrDefault(); // ------------------------------------------------------------------------------------ Data_UserDataContext DropD = new Data_UserDataContext(); var dep = (from xx in DropD.MAS_USER_As orderby xx.US_ID select xx).GroupBy(x => x.ANAME).Select(grp => grp.First()); ViewBag.Dep = new SelectList(dep, "US_ID", "ANAME"); List <USER_LOGIN> list = new List <USER_LOGIN>(); if (Ans.Userloginid != null) { foreach (var dx in Ans.Userloginid) { USER_LOGIN ux = new USER_LOGIN(); ux.ID = dx.ID; ux.STCODE = dx.STCODE; ux.FULLNAME = dx.FULLNAME; ux.DEP = dx.DEP; ux.A_NAME = dx.A_NAME; list.Add(ux); //PhoneModels.RowPhone.Add(ipn); } } ViewBag.sh = sh; return(PartialView(list.ToPagedList(page, 20))); }
public ActionResult updatedid(Dp_List model) { using (Data_UserDataContext db = new Data_UserDataContext()) { var q = (from pp in db.MAS_USERs where pp.STCODE == model.STCODE select pp).FirstOrDefault(); q.D_ID = (int)model.JT_ID; db.SubmitChanges(); } return(RedirectToAction("Index", "TicketOP", new { Pos = "0" })); }
private bool checkedepartment(USER_LOGIN model) { Data_UserDataContext Context = new Data_UserDataContext(); var queryX = Context.MAS_USERs.Where(x => x.STCODE == model.STCODE && x.PASSWORD == model.PASSWORD).FirstOrDefault(); if (queryX.D_ID == 0) { return(true); } else { return(false); } }
public bool LoginBase(USER_LOGIN model) { bool OK = false; Data_UserDataContext Context = new Data_UserDataContext(); var queryX = Context.MAS_USERs.Where(x => x.STCODE == model.STCODE && x.PASSWORD == model.PASSWORD).Count(); if (queryX > 0) { OK = true; } return(OK); }
//private string ticketNo() //{ // string runNo = "LE"; //IT17000009 // string strRun = ""; // string yy = DateTime.Now.Year.ToString(); // string mm = DateTime.Now.Month.ToString(); // int intRun = 1; // yy = yy.Substring(yy.Length - 2, 2); // if (mm.Length == 1) { mm = "0" + mm; } // runNo = runNo + yy + mm; // using (DB_LEDataContext Context = new DB_LEDataContext()) // { // try // { // var queryX = Context.TASK_MAINs.OrderByDescending(s => s.TICKETNO) // .Where(s => s.TICKETNO.Contains(runNo)) // .FirstOrDefault(); // strRun = queryX.TICKETNO; // } // catch // { // strRun = "LE18010000"; // } // } // strRun = strRun.Substring(strRun.Length - 4, 4); // intRun = Int32.Parse(strRun); // intRun = intRun + 1; // strRun = intRun.ToString(); // switch (strRun.Length) // { // case 1: // strRun = "000" + strRun; // break; // case 2: // strRun = "00" + strRun; // break; // case 3: // strRun = "0" + strRun; // break; // } // runNo = runNo + strRun; // return runNo; //} /*------------------------------------------------------------- Login ------------------------------------------------*/ public bool chkSesionUser() { bool chk = true; userOnline = GetCookie(); if (userOnline == string.Empty) { try { userOnline = Session["User"].ToString(); if (userOnline.Length < 1) { chk = false; } } catch { chk = false; } } using (Data_UserDataContext Context = new Data_UserDataContext()) { try { var sql = (from xx in Context.MAS_USERs where xx.STCODE == userOnline select xx).FirstOrDefault(); if (sql != null) { Session["SharedName"] = "สวัสดี " + sql.FNAME; Session["Name"] = sql.FNAME; } else { Session["SharedName"] = "เข้าสู่ระบบ"; } } catch { Session["SharedName"] = "เข้าสู่ระบบ"; } } return(chk); }
public ActionResult updatedid(Dp_List model) { //if (!chkSesionUser()) { return RedirectToAction("Login", "Login", new { returnUrl = "~/TicketApprove/Index" }); } using (Data_UserDataContext db = new Data_UserDataContext()) { var q = (from pp in db.MAS_USERs where pp.STCODE == model.STCODE select pp).FirstOrDefault(); q.D_ID = (int)model.JT_ID; db.SubmitChanges(); } return(RedirectToAction("Index", "Ticket")); }
public string GetDP(string _stcode) { string value = string.Empty; using (Data_UserDataContext db = new Data_UserDataContext()) { var stname = from a in db.MAS_USERs join b in db.MAS_DEPs on a.D_ID equals b.DP_ID where a.STCODE == _stcode select new { DPNAME = b.DEPARTMENT }; var rs = stname.FirstOrDefault(); value = rs.DPNAME; } return(value); }
// GET: TicketBB public ActionResult Index(int page = 1, string Pos = "", string seach = "", string type = "") { if (!chkSesionUser(Pos)) { return(RedirectToAction("Login", "Login", new { returnUrl = "~/TicketOP/Index" })); } Detail cc = new Detail(); cc.Pos = Pos; cc.seach = seach; cc.type = type; cc.STCODE = userOnline; var restClient = new RestClient("http://http://5cosmeda.homeunix.com:89/Ticket_OP/api/TicketOP/Ticketlist"); var request = new RestRequest(Method.POST); request.RequestFormat = DataFormat.Json; request.AddJsonBody(cc); var response = restClient.Execute(request); var json = response.Content; JsonDeserializer deserial = new JsonDeserializer(); List <Ticket> item = JsonConvert.DeserializeObject <List <Ticket> >(json); //var ret = item.FirstOrDefault(); //IQueryable<VW_TICKET> View_Ticket; //seach = seach.Trim(); //type = type.Trim(); Data_OPDataContext Context = new Data_OPDataContext(); Data_UserDataContext C_user = new Data_UserDataContext(); List <Ticket> lstTicket = new List <Ticket>(); ViewBag.Type = new SelectList(Context.VW_TICKETs.GroupBy(x => x.TNAME).Select(grp => grp.First()), "TNAME", "TNAME"); if (_POS == "1") { var queryX = Context.MAS_WHs.Where(x => x.WHCODE == userOnline).FirstOrDefault(); ViewBag.BRAND = queryX.BRAND; } else { var sql = C_user.VW_USER_ALLs.Where(x => x.STCODE == userOnline).FirstOrDefault(); ViewBag.BRAND = sql.DPCODE; } //List<Ticket> lstTicket = new List<Ticket>(); ////string a = userOnline; //if(_POS == "1") //{ // var queryX = Context.MAS_WHs.Where(x => x.WHCODE == userOnline).FirstOrDefault(); // ViewBag.BRAND = queryX.BRAND; // View_Ticket = Context.VW_TICKETs // .Where(tik => tik.WHCODE == userOnline) // .Where(tik => tik.AREA.Contains(seach) || tik.WHNAME.Contains(seach) || tik.TICKETNO.Contains(seach)) // .Where(tik => tik.FLAG == "0") // .OrderBy(tik => tik.SS_ID); //} //else //{ // var sql = C_user.VW_USER_ALLs.Where(x => x.STCODE == userOnline).FirstOrDefault(); // ViewBag.BRAND = sql.DPCODE; // View_Ticket = Context.VW_TICKETs // .Where(tik => tik.BRAND == sql.DPCODE) // .Where(tik => tik.AREA.Contains(seach) || tik.WHNAME.Contains(seach) || tik.TICKETNO.Contains(seach)) // .Where(tik => tik.FLAG == "0") // .OrderBy(tik => tik.SS_ID); //} //if (type != "") //{ // View_Ticket = View_Ticket.Where(tik => tik.TNAME == type); //} foreach (var ux in item) { Ticket _ticket = new Ticket(); _ticket.TK_ID = ux.TK_ID; _ticket.TICKETNO = ux.TICKETNO; _ticket.WHCODE = ux.WHCODE; _ticket.WHNAME = ux.WHNAME; _ticket.AREA = ux.AREA; _ticket.DETAIL = ux.DETAIL; _ticket.SS_ID = ux.SS_ID; _ticket.ST_NAME = ux.ST_NAME; _ticket.REC_NICKNAME = ux.REC_NICKNAME; _ticket.CREATEDATE = DateTime.Parse(ux.CREATEDATE.ToString()).ToShortDateString(); _ticket.CREATETIME = ux.CREATETIME.ToString(); lstTicket.Add(_ticket); } ViewBag.Pos = _POS; ViewBag.WordSearch = seach; ViewBag.typeSearch = type; return(View(lstTicket.ToPagedList(page, 10))); }
// GET: Ticket public ActionResult Index(int page = 1, string seach = "", string type = "") { if (!chkSesionUser()) { return(RedirectToAction("Login", "Login", new { returnUrl = "~/Ticket/Index" })); } Detail cc = new Detail(); //cc.Pos = Pos; cc.seach = seach; cc.type = type; cc.STCODE = userOnline; //var restClient = new RestClient("http://5cosmeda.homeunix.com:89/Ticket_OP/api/TicketOP/Ticketlist"); var restClient = new RestClient("http://5cosmeda.homeunix.com:89/Ticket_LE/api/TicketLE/Ticketlist"); var request = new RestRequest(Method.POST); request.RequestFormat = DataFormat.Json; request.AddJsonBody(cc); var response = restClient.Execute(request); var json = response.Content; JsonDeserializer deserial = new JsonDeserializer(); List <Ticket> items = JsonConvert.DeserializeObject <List <Ticket> >(json); // ------------------------------------------------------------------------------------ //IQueryable<VW_TICKET> View_Ticket; //seach = seach.Trim(); //type = type.Trim(); Data_UserDataContext Con = new Data_UserDataContext(); DB_LEDataContext db = new DB_LEDataContext(); List <Ticket> lstTicket = new List <Ticket>(); ViewBag.Type = new SelectList(db.MAS_SSes, "SS_ID", "SS_NAME"); var User = (from xx in Con.MAS_USERs where xx.STCODE == userOnline select xx).FirstOrDefault(); if (User.D_ID != 10) { if (items != null) { foreach (var item in items) { Ticket ux = new Ticket(); ux.ID = item.ID; ux.TICKETNO = item.TICKETNO; ux.DETAIL = item.DETAIL; ux.CREATEDATE = DateTime.Parse(item.CREATEDATE.ToString()).ToShortDateString(); ux.CREATETIME = DateTime.Parse(item.CREATETIME.ToString()).ToLongTimeString(); ux.CRE_NICKNAME = item.CRE_NICKNAME; ux.DEP = item.DEP; ux.SSID = item.SSID; ux.SSNAME = item.SSNAME; lstTicket.Add(ux); } } } else { if (items != null) { foreach (var item in items) { Ticket ux = new Ticket(); ux.ID = item.ID; ux.TICKETNO = item.TICKETNO; ux.DETAIL = item.DETAIL; ux.CREATEDATE = DateTime.Parse(item.CREATEDATE.ToString()).ToShortDateString(); ux.CREATETIME = DateTime.Parse(item.CREATETIME.ToString()).ToLongTimeString(); ux.CRE_NICKNAME = item.CRE_NICKNAME; ux.DEP = item.DEP; ux.SSID = item.SSID; ux.SSNAME = item.SSNAME; lstTicket.Add(ux); } } } ViewBag.DP = User.D_ID; ViewBag.A_ID = User.A_ID; ViewBag.WordSearch = seach; ViewBag.typeSearch = type; return(View(lstTicket.ToPagedList(page, 10))); }