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);
}
//Get : Create Ticket
public ActionResult CreateTicket(string Pos = "1")
{
if (!chkSesionUser(Pos))
{
return(RedirectToAction("Login", "Login", new { returnUrl = "~/TicketOP/Index" }));
}
Data_OPDataContext Context = new Data_OPDataContext();
//string a = userOnline;
var queryX = Context.MAS_WHs.Where(x => x.WHCODE == userOnline).FirstOrDefault();
//CreTicket newItem = new CreTicket();
CreTicket newItem = new CreTicket();
newItem.WHNAME = queryX.WHNAME;
newItem.STCODE = userOnline;
//newItem.US_ID = usr.Id;
ViewBag.BRAND = queryX.BRAND;
//newItem.JT_LIST = new SelectList(Context.MAS_JOB_TYPEs.Where(x => x.PROGRAM == "TICKET_IT"), "JT_ID", "JTNAME");
var sql_AREA = (from xx in Context.MAS_AREAs
where xx.BRAND == queryX.BRAND
select xx).GroupBy(x => x.AREA).Select(grp => grp.First());
newItem.AREA = new SelectList(sql_AREA, "AREA", "AREA");
ViewBag.Pos = Pos;
return(View(newItem));
}
private string ticketNo(string Bread)
{
string runNo = Bread;
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 (Data_OPDataContext Context = new Data_OPDataContext())
{
try
{
var queryX = Context.TRN_TICKETs.OrderByDescending(s => s.TICKETNO)
.Where(s => s.TICKETNO.Contains(runNo))
.FirstOrDefault();
strRun = queryX.TICKETNO;
}
catch
{
strRun = Bread + "18010000";
}
}
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);
}
/*------------------------------------------------------------- Funtion ------------------------------------------------*/
private string flsPath(int tkId, int atFilePosition, Int16 odr = 0)
{
string path = "";
using (Data_OPDataContext searchContext = new Data_OPDataContext())
{
var queryX = searchContext.TRN_TICKET_Fs
.Where(s => s.TK_ID == tkId && s.ORDERNO == odr)
.FirstOrDefault();
switch (atFilePosition)
{
case 1:
try
{
path = queryX.PATH1;
}
catch
{
path = "";
}
break;
case 2:
try
{
path = queryX.PATH2;
}
catch
{
path = "";
}
break;
case 3:
try
{
path = queryX.PATH3;
}
catch
{
path = "";
}
break;
default:
break;
}
}
return(path);
}
public bool chkSesionUser(string POS)
{
bool chk = true;
userOnline = GetCookie(POS);
if (userOnline == string.Empty)
{
try
{
userOnline = Session["User"].ToString();
if (userOnline.Length < 1)
{
chk = false;
}
}
catch
{
chk = false;
}
}
using (Data_OPDataContext Context = new Data_OPDataContext())
{
try
{
var sql = (from xx in Context.MAS_WHs
where xx.WHCODE == userOnline
select xx).FirstOrDefault();
if (sql != null)
{
Session["SharedName"] = "สวัสดี " + sql.FULLNAME;
Session["Name"] = sql.WHNAME;
}
else
{
Session["SharedName"] = "เข้าสู่ระบบ";
}
}
catch
{
Session["SharedName"] = "เข้าสู่ระบบ";
}
}
return(chk);
}
public ActionResult TicketClose(int TicketId, string Pos)
{
using (Data_OPDataContext Context = new Data_OPDataContext())
{
var sql = (from xx in Context.TRN_TICKETs
where xx.TK_ID == TicketId
select xx).FirstOrDefault();
//sql.STCODE = userOnline;
sql.SS_ID = 3;
Context.SubmitChanges();
}
return(RedirectToAction("TicketDetail", "TicketOP", new { TicketId = TicketId, Pos = Pos }));
}
public ActionResult TicketReceive(int TicketId)
{
if (!chkSesionUser("0"))
{
return(RedirectToAction("Login", "Login_Office", new { returnUrl = "~/TicketOP/Index" }));
}
using (Data_OPDataContext Context = new Data_OPDataContext())
{
var sql = (from xx in Context.TRN_TICKETs
where xx.TK_ID == TicketId
select xx).FirstOrDefault();
sql.STCODE = userOnline;
sql.SS_ID = 2;
Context.SubmitChanges();
}
return(RedirectToAction("TicketDetail", "TicketOP", new { TicketId = TicketId, Pos = "0" }));
}
private int idOderno(int tkId)
{
int id = 0;
using (Data_OPDataContext searchContext = new Data_OPDataContext())
{
var queryX = searchContext.TRN_TICKET_Is.OrderByDescending(s => s.TK_ID)
.ThenByDescending(s => s.ORDERNO)
.Where(s => s.TK_ID == tkId)
.FirstOrDefault();
try
{
id = queryX.ORDERNO;
id = id + 1;
}
catch
{
id = 1;
}
}
return(id);
}
// 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)));
}
