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