public ActionResult CreateTicket(TicketModel newItem)
{
if (!chkSesionUser())
{
return(RedirectToAction("Login", "Login", new { returnUrl = "~/Ticket/Index" }));
}
string tketNo = ticketNo();
using (DB_LEDataContext Context = new DB_LEDataContext())
{
TASK_MAIN Insert_Main = new TASK_MAIN();
CultureInfo us = CultureInfo.GetCultureInfo("en-US");
//System.Globalization.CultureInfo cultureinfo = new System.Globalization.CultureInfo("nl-NL");
DateTime dt = DateTime.Parse(newItem.Add.TicketSdate.ToString(), us);
Insert_Main.TICKETNO = tketNo;
Insert_Main.TITLE = newItem.Add.TicketName;
Insert_Main.DETAIL = newItem.Add.Detail;
Insert_Main.CREATEDATE = DateTime.Now;
Insert_Main.CREATECODE = userOnline;
Insert_Main.S_DATE = DateTime.Parse(newItem.Add.TicketSdate.ToString(), us);
Insert_Main.E_DATE = DateTime.Parse(newItem.Add.TicketFdate.ToString(), us);
Insert_Main.STCODE = userOnline;
Insert_Main.STATUS = "3";
Insert_Main.FLAG = "1";
//Insert_Main.APPROVE_ID = 1;
Context.TASK_MAINs.InsertOnSubmit(Insert_Main);
Context.SubmitChanges();
//var sql = (from xx in Context.TASK_MAINs
// where xx.TICKETNO == tketNo
// select xx).FirstOrDefault();
//var doc = from xx in Context.MAS_DOCs
// select xx;
//int i = 0;
//foreach (var item in doc)
//{
// TASK_SUB Insert_Sub = new TASK_SUB();
// if (newItem.GetCheck[i].Checked == true)
// {
// Insert_Sub.LE_ID = sql.ID;
// Insert_Sub.DOC_ID = newItem.GetCheck[i].ID;
// Insert_Sub.DETAIL_SUB = newItem.GetCheck[i].NAME;
// Context.TASK_SUBs.InsertOnSubmit(Insert_Sub);
// Context.SubmitChanges();
// }
// i++;
//}
}
return(RedirectToAction("Index", "Ticket"));
}
public IEnumerable <Detail> CreateTicket(TicketModels newItem)
{
List <Detail> results = new List <Detail>();
try
{
string tketNo = ticketNo();
using (TicketLEDataContext Context = new TicketLEDataContext())
{
TASK_MAIN Insert_Main = new TASK_MAIN();
Insert_Main.TICKETNO = tketNo;
Insert_Main.DETEIL = newItem.Add.Detail;
Insert_Main.WORKDATE = DateTime.Now;
Insert_Main.STCODE = newItem.STCODE;
Insert_Main.STATUS = "1";
Insert_Main.FLAG = "1";
Insert_Main.APPROVE_ID = 1;
Context.TASK_MAINs.InsertOnSubmit(Insert_Main);
Context.SubmitChanges();
var sql = (from xx in Context.TASK_MAINs
where xx.TICKETNO == tketNo
select xx).FirstOrDefault();
var doc = from xx in Context.MAS_DOCs
select xx;
int i = 0;
foreach (var item in doc)
{
TASK_SUB Insert_Sub = new TASK_SUB();
if (newItem.GetCheck[i].Checked == true)
{
Insert_Sub.LE_ID = sql.ID;
Insert_Sub.DOC_ID = newItem.GetCheck[i].ID;
Insert_Sub.DETEIL_SUB = newItem.GetCheck[i].NAME;
Context.TASK_SUBs.InsertOnSubmit(Insert_Sub);
Context.SubmitChanges();
}
i++;
}
}
}
catch (Exception ex)
{
Detail res = new Detail();
res.status = "F";
res.message = ex.Message;
results.Add(res);
}
return(results.ToArray());
}
