public static string UpdateTask(dynamic obj)
{
try
{
using (var db = new MSEsystemEntities1())
{
int id = Convert.ToInt32(obj["Id"]);
var b = id == 0 ? new Task(): db.Task.Where(i => i.Id == id).FirstOrDefault();
var isNew = false;
if (id == 0)
{
isNew = true;
}
b.TicketID = Convert.ToInt32(obj["TicketID"]);
b.TaskDescription = Convert.ToString(obj["TaskDescription"]);
b.Done = Convert.ToBoolean(obj["Done"]);
if (isNew)
{
db.Task.Add(b);
}
db.SaveChanges();
return(b.Id.ToString());
}
}
catch (Exception e)
{
throw e;
}
}
public static string UpdateUser(dynamic obj)
{
try
{
using (var db = new MSEsystemEntities1())
{
int id = Convert.ToInt32(obj["Id"]);
var b = id == 0 ? new User() : db.User.Where(i => i.Id == id).FirstOrDefault();
var isNew = false;
if (id == 0)
{
isNew = true;
}
b.Role = Convert.ToInt32(obj["Role"]);
b.DisplayName = Convert.ToString(obj["DisplayName"]);
b.EmailAddress = Convert.ToString(obj["EmailAddress"]);
b.TelephoneNumber = Convert.ToString(obj["TelephoneNumber"]);
b.Department = Convert.ToInt32(obj["Department"]);
b.UserPassword = Convert.ToString(obj["UserPassword"]);
b.Sn = Convert.ToString(obj["Sn"]);
if (isNew)
{
db.User.Add(b);
}
if (b.Department == 4)
{
var domain = Convert.ToInt32(obj["DomainID"]);
var doms = db.UserDomain.Where(i => i.UserID == id).ToArray();
foreach (var dom1 in doms)
{
db.UserDomain.Remove(dom1);
}
var dom = new UserDomain();
dom.UserID = b.Id;
dom.DomainID = domain;
dom.IsManager = b.Role < 4;
db.UserDomain.Add(dom);
}
db.SaveChanges();
return(b.Id.ToString());
}
}
catch (Exception e)
{
throw e;
}
}
public static string CheckTask(int tid)
{
try
{
using (var db = new MSEsystemEntities1())
{
var z = db.Task.Where(i => i.Id == tid).FirstOrDefault();
z.Done = !z.Done;
db.SaveChanges();
return(z.Id.ToString());
}
}
catch (Exception e)
{
throw e;
}
}
public static string DeleteUser(int id)
{
try
{
using (var db = new MSEsystemEntities1())
{
var b = db.User.Where(i => i.Id == id).FirstOrDefault();
b.IsArchive = true;
db.SaveChanges();
return("ok");
}
}
catch (Exception e)
{
throw e;
}
}
public static bool SetUserAsLogged(int uid)
{
try
{
using (var db = new MSEsystemEntities1())
{
var b = db.User.Where(i => i.Id == uid).FirstOrDefault();
b.LoginStatus = true;
db.SaveChanges();
return(true);
}
}
catch (Exception e)
{
throw e;
}
}
public static string AddNewTicket(dynamic obj)
{
try
{
using (var db = new MSEsystemEntities1())
{
var b = new Ticket();
b.Id = Convert.ToInt32(obj["Id"]);
b.LocationID = Convert.ToInt32(obj["LocationID"]);
b.Priority = Convert.ToBoolean(obj["Priority"]);
b.Description = Convert.ToString(obj["Description"]);
b.CategoryID = Convert.ToInt32(obj["CategoryID"]);
b.UserID_Created = Convert.ToInt32(obj["UserID_Created"]);
b.TimeOpen = DateTime.Now;
DateTime dateValue;
string s = Convert.ToString(obj["Date"]);
var formats = new[] { "dd-MM-yyyy", "dd/MM/yyyy", "yyyy-MM-dd HH:mm:ss", "dd-MM-yyyy HH:mm:ss", "dd-MM-yyyy HH:mm" };
if (DateTime.TryParseExact(s, formats, CultureInfo.InvariantCulture, DateTimeStyles.None, out dateValue))
{
b.TimeClose = dateValue;
}
else
{
b.TimeClose = DateTime.Now;
}
b.IsFuture = Convert.ToBoolean(obj["IsFuture"]);
b.Status = 1;
db.Ticket.Add(b);
db.SaveChanges();
return(b.Id.ToString());
}
}
catch (Exception e)
{
throw e;
}
}
public static string UpdateTicket(dynamic obj)
{
try
{
using (var db = new MSEsystemEntities1())
{
int id = Convert.ToInt32(obj["Id"]);
var b = db.Ticket.Where(i => i.Id == id).FirstOrDefault();
var oldStatus = b.Status;
b.Id = id;
b.LocationID = Convert.ToInt32(obj["LocationID"]);
b.Priority = Convert.ToBoolean(obj["Priority"]);
b.Description = Convert.ToString(obj["Description"]);
DateTime dateValue;
string s = Convert.ToString(obj["Date"]);
var formats = new[] { "dd-MM-yyyy", "dd/MM/yyyy", "yyyy-MM-dd HH:mm:ss", "dd-MM-yyyy HH:mm:ss", "dd-MM-yyyy HH:mm" };
if (DateTime.TryParseExact(s, formats, CultureInfo.InvariantCulture, DateTimeStyles.None, out dateValue))
{
b.TimeClose = dateValue;
}
else
{
b.TimeClose = DateTime.Now;
}
b.Status = Convert.ToInt32(obj["Status"]);
if (b.Status == 1)
{
var z = db.UserTicket.Where(i => i.TicketID == id).ToArray();
foreach (UserTicket ut in z)
{
db.UserTicket.Remove(ut);
}
}
if (b.Status == 2 && oldStatus == 1)
{
var z = db.UserTicket.Where(i => i.TicketID == id).ToArray();
foreach (UserTicket ut in z)
{
db.UserTicket.Remove(ut);
}
var user = Convert.ToInt32(obj["CurrUser"]);
var nut = new UserTicket();
nut.UserID = user;
nut.TicketID = b.Id;
nut.MainUser = true;
db.UserTicket.Add(nut);
}
//foreach (var t in obj["tasks"])
//{
// int tid = Convert.ToInt32(t["TaskID"]);
// var k = db.Task.Where(i => i.Id == tid).FirstOrDefault();
// k.Done = Convert.ToBoolean(t["Done"]);
//}
db.SaveChanges();
if (Convert.ToInt32(obj["AnotherAsignee"]) > 0)
{
var isNew = false;
var z = db.UserTicket.Where(i => i.TicketID == id && i.MainUser == false).FirstOrDefault();
if (z == null)
{
isNew = true;
z = new UserTicket();
}
z.TicketID = id;
z.UserID = Convert.ToInt32(obj["AnotherAsignee"]);
z.MainUser = false;
if (isNew)
{
db.UserTicket.Add(z);
}
db.SaveChanges();
}
db.SaveChanges();
return("ok");
}
}
catch (Exception e)
{
throw e;
}
}
