public IEnumerable <Ticket> Ticketlist(Detail data)
{
List <Ticket> results = new List <Ticket>();
try
{
IQueryable <DATA.TicketLE.VW_TICKET> View_Ticket;
var seach = data.seach;
var type = data.type;
UserDataContext Con = new UserDataContext();
TicketLEDataContext db = new TicketLEDataContext();
List <Ticket> lstTicket = new List <Ticket>();
var User = (from xx in Con.MAS_USERs
where xx.STCODE == data.STCODE
select xx).FirstOrDefault();
using (TicketLEDataContext Context = new TicketLEDataContext())
{
View_Ticket = Context.VW_TICKETs.Where(s => s.TICKETNO.Contains(seach) || s.DPCODE.Contains(seach) || s.NICKNAME.Contains(seach)).Where(s => s.FLAG == "1").OrderBy(s => s.STATUS);
if (type != "")
{
View_Ticket = View_Ticket.Where(tik => tik.STATUS == type);
}
if (User.D_ID != 10)
{
View_Ticket = View_Ticket.Where(s => s.STCODE == data.STCODE);
foreach (var item in View_Ticket)
{
Ticket ux = new Ticket();
ux.ID = item.ID;
ux.TICKETNO = item.TICKETNO;
ux.DETAIL = item.DETEIL;
ux.CREATEDATE = DateTime.Parse(item.WORKDATE.ToString()).ToShortDateString();
ux.CREATETIME = DateTime.Parse(item.WORKDATE.ToString()).ToLongTimeString();
ux.CRE_NICKNAME = item.NICKNAME;
ux.DEP = item.DPCODE;
ux.SSID = Int32.Parse(item.STATUS);
ux.SSNAME = item.SS_NAME;
lstTicket.Add(ux);
}
}
else
{
if (User.A_ID == 3)
{
View_Ticket = View_Ticket.Where(s => s.STCODE == data.STCODE);
}
else
{
View_Ticket = View_Ticket.Where(s => s.APPROVE_ID >= 2);
}
foreach (var item in View_Ticket)
{
Ticket ux = new Ticket();
ux.ID = item.ID;
ux.TICKETNO = item.TICKETNO;
ux.DETAIL = item.DETEIL;
ux.CREATEDATE = DateTime.Parse(item.WORKDATE.ToString()).ToShortDateString();
ux.CREATETIME = DateTime.Parse(item.WORKDATE.ToString()).ToLongTimeString();
ux.CRE_NICKNAME = item.NICKNAME;
ux.DEP = item.DPCODE;
ux.SSID = Int32.Parse(item.STATUS);
ux.SSNAME = item.SS_NAME;
lstTicket.Add(ux);
}
}
results = lstTicket;
}
}
catch (Exception ex)
{
//AnsOP res = new AnsOP();
//res.status = "F";
//res.message = ex.Message;
//results.Add(res);
}
return(results.ToArray());
}
// GET: Ticket
public ActionResult Index(int page = 1, string seach = "", string type = "")
{
if (!chkSesionUser())
{
return(RedirectToAction("Login", "Login", new { returnUrl = "~/Ticket/Index" }));
}
IQueryable <VW_TICKET> View_Ticket;
//OnUser usr = new OnUser();
//usr = getUser(userOnline);
seach = seach.Trim();
//NName = NName.Trim();
type = type.Trim();
//TicketModel TicketList = new TicketModel();
data_userDataContext Con = new data_userDataContext();
DB_LEDataContext db = new DB_LEDataContext();
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();
ViewBag.DP = User.D_ID;
ViewBag.A_ID = User.A_ID;
List <Ticket> lstTicket = new List <Ticket>();
using (DB_LEDataContext Context = new DB_LEDataContext())
{
View_Ticket = Context.VW_TICKETs.Where(s => s.TICKETNO.Contains(seach) || s.DPCODE.Contains(seach) || s.Recieve.Contains(seach)).Where(s => s.FLAG == "1").OrderByDescending(s => s.STATUS).ThenByDescending(s => s.ID);
if (type != "")
{
View_Ticket = View_Ticket.Where(tik => tik.STATUS == type);
}
if (User.D_ID != 10)
{
View_Ticket = View_Ticket.Where(s => s.STCODE == userOnline);
foreach (var item in View_Ticket)
{
Ticket ux = new Ticket();
ux.ID = item.ID;
ux.TICKETNO = item.TICKETNO;
ux.DETAIL = item.DETAIL;
ux.CREATEDATE = DateTime.Parse(item.S_DATE.ToString()).ToShortDateString();
ux.CREATETIME = DateTime.Parse(item.E_DATE.ToString()).ToShortDateString();
ux.CRE_NICKNAME = item.CREATENAME;
ux.DEP = item.DPCODE;
ux.SSID = int.Parse(item.STATUS);
ux.SSNAME = item.SS_NAME;
ux.TicketName = item.TITLE;
ux.TICKETRECIEVE = item.Recieve;
if (item.F_DATE.ToString() != "")
{
ux.TICKETFDATE = DateTime.Parse(item.F_DATE.ToString()).ToShortDateString();
}
lstTicket.Add(ux);
}
}
else
{
if (User.A_ID == 3)
{
View_Ticket = View_Ticket.Where(s => s.STCODE == userOnline);
}
else
{
//View_Ticket = View_Ticket.Where(s => s.APPROVE_ID >= 2);
}
foreach (var item in View_Ticket)
{
Ticket ux = new Ticket();
ux.ID = item.ID;
ux.TICKETNO = item.TICKETNO;
ux.DETAIL = item.DETAIL;
ux.CREATEDATE = DateTime.Parse(item.S_DATE.ToString()).ToShortDateString();
ux.CREATETIME = DateTime.Parse(item.E_DATE.ToString()).ToShortDateString();
ux.CRE_NICKNAME = item.CREATENAME;
ux.DEP = item.DPCODE;
ux.SSID = int.Parse(item.STATUS);
ux.SSNAME = item.SS_NAME;
ux.TicketName = item.TITLE;
lstTicket.Add(ux);
}
}
//TicketList.TicketDetail = lstTicket;
}
//return View(lstTicket);
//return View(lstTicket.ToPagedList(page, 10));
ViewBag.WordSearch = seach;
ViewBag.typeSearch = type;
return(View(lstTicket.ToPagedList(page, 10)));
}
public IEnumerable <Ticket> Ticketlist(Detail data)
{
List <Ticket> results = new List <Ticket>();
try
{
IQueryable <VW_TICKET> View_Ticket;
var seach = data.seach.Trim();
var type = data.type.Trim();
TicketOPDataContext Context = new TicketOPDataContext();
UserDataContext C_user = new UserDataContext();
List <Ticket> lstTicket = new List <Ticket>();
//string a = userOnline;
if (data.Pos == "1")
{
var queryX = Context.MAS_WHs.Where(x => x.WHCODE == data.STCODE).FirstOrDefault();
//ViewBag.BRAND = queryX.BRAND;
View_Ticket = Context.VW_TICKETs
.Where(tik => tik.WHCODE == data.STCODE)
.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 == data.STCODE).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 View_Ticket)
{
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.TNAME;
_ticket.REC_NICKNAME = ux.NICKNAME;
_ticket.CREATEDATE = DateTime.Parse(ux.CREATEDATE.ToString()).ToShortDateString();
_ticket.CREATETIME = ux.CREATETIME.ToString();
lstTicket.Add(_ticket);
}
results = lstTicket;
}
catch (Exception ex)
{
//AnsOP res = new AnsOP();
//res.status = "F";
//res.message = ex.Message;
//results.Add(res);
}
return(results.ToArray());
}
