// =========================================== INSERT =============================================
public void InsertTicket()
{
Console.Clear();
System.Console.Write("Description : ");
string description = System.Console.ReadLine();
System.Console.Write("Date Create : ");
DateTime dtmcrt = Convert.ToDateTime(System.Console.ReadLine());
System.Console.Write("Due Date : ");
DateTime duedt = Convert.ToDateTime(System.Console.ReadLine());
System.Console.Write("L1 : ");
string l1 = System.Console.ReadLine();
System.Console.Write("Technician : ");
string technc = System.Console.ReadLine();
System.Console.Write("Type ID : ");
int tid = Convert.ToInt32(System.Console.ReadLine());
System.Console.Write("User ID : ");
int uid = Convert.ToInt32(System.Console.ReadLine());
System.Console.Write("Category ID : ");
int cid = Convert.ToInt32(System.Console.ReadLine());
System.Console.Write("SubCategory ID : ");
int scid = Convert.ToInt32(System.Console.ReadLine());
TicketCls call = new TicketCls();
{
call.Description = description;
call.Dtm_Crt = dtmcrt;
call.L1 = l1;
call.DueDate = duedt;
call.Technician = technc;
call.TypeID = tid;
call.UserID = uid;
call.CategoryID = cid;
call.SubCategoryID = scid;
};
try
{
hld_context.Ticket_s.Add(call);
var result = hld_context.SaveChanges();
}
catch (Exception ex)
{
System.Console.Write(ex.InnerException);
}
}
public int UpdateTicket(int input)
{
Console.Clear();
System.Console.Write("Description : ");
string description = System.Console.ReadLine();
System.Console.Write("Date Create : ");
DateTime dtmcrt = Convert.ToDateTime(System.Console.ReadLine());
System.Console.Write("Due Date : ");
DateTime duedt = Convert.ToDateTime(System.Console.ReadLine());
Console.WriteLine("=============================================");
System.Console.Write("Last Update : ");
DateTime lstupdt = Convert.ToDateTime(System.Console.ReadLine());
System.Console.Write("OnProgress Date : ");
DateTime onpgrs = Convert.ToDateTime(System.Console.ReadLine());
System.Console.Write("OnWaiting Date : ");
DateTime onwtng = Convert.ToDateTime(System.Console.ReadLine());
System.Console.Write("OnHold Date : ");
DateTime onhld = Convert.ToDateTime(System.Console.ReadLine());
System.Console.Write("Resolved Time : ");
DateTime rsvd = Convert.ToDateTime(System.Console.ReadLine());
System.Console.Write("Closed Time : ");
DateTime cldtm = Convert.ToDateTime(System.Console.ReadLine());
System.Console.Write("Status : ");
string stat = System.Console.ReadLine();
Console.WriteLine("=============================================");
System.Console.Write("L1 : ");
string l1 = System.Console.ReadLine();
System.Console.Write("Technician : ");
string technc = System.Console.ReadLine();
System.Console.Write("Type ID : ");
int tid = Convert.ToInt32(System.Console.ReadLine());
System.Console.Write("User ID : ");
int uid = Convert.ToInt32(System.Console.ReadLine());
System.Console.Write("Category ID : ");
int cid = Convert.ToInt32(System.Console.ReadLine());
System.Console.Write("SubCategory ID : ");
int scid = Convert.ToInt32(System.Console.ReadLine());
Console.WriteLine("\n");
Console.WriteLine("=============================================");
System.Console.Write("MASUKKAN ULANG ID : ");
int id_ticket = Convert.ToInt32(System.Console.ReadLine());
var getmhs = hld_context.Ticket_s.Find(id_ticket);
if (getmhs == null)
{
System.Console.Write("TIDAK ADA ID ROLE : " + id_ticket);
}
else
{
TicketCls ticket = GetById(input);
ticket.Description = description;
ticket.Dtm_Crt = dtmcrt;
ticket.L1 = l1;
ticket.DueDate = duedt;
ticket.Last_update = lstupdt;
ticket.OnProgressDate = onpgrs;
ticket.OnWaitingDate = onwtng;
ticket.OnHoldDate = onhld;
ticket.ResolvedTime = rsvd;
ticket.ClosedTime = cldtm;
ticket.Technician = technc;
ticket.Status = stat;
ticket.UserID = uid;
ticket.CategoryID = cid;
ticket.SubCategoryID = scid;
hld_context.Entry(ticket).State = System.Data.Entity.EntityState.Modified;
hld_context.SaveChanges();
}
return(input);
}
