//public static string DeleteTask(dynamic obj)
//{
// try
// {
// using (var db = new MSEsystemEntities1())
// {
// int id = Convert.ToInt32(obj["idTask"]);
// var w = db.Task.Where(i => i.Id == id).FirstOrDefault();
// w.isArchive = true;
// db.SaveChanges();
// return "Ok";
// }
// }
// catch (Exception e)
// {
// return "error: " + e.Message;
// }
//}
//public static string[] freeSearch(dynamic obj)
//{
// try
// {
// using (var db = new MSEsystemEntities1())
// {
// String t = Convert.ToString(obj);
// string[] res = new string[1000];
// int x = 0;
// var w = db.TicketsToDo.Where(i => i.CategoryName == t || i.Description==t).Select(j=>j.TicketID).ToArray();
// foreach (dynamic r in w)
// {
// res.SetValue(r,x);
// x++;
// }
// return res;
// }
// }
// catch (Exception e)
// {
// string[] res2 = new string[2];
// res2.SetValue("error: " + e.Message, 0);
// return res2;
// }
//}
public static string SendForgottenPass(string email)
{
try
{
using (var db = new MSEsystemEntities1())
{
var u = db.User.Where(x => x.EmailAddress == email).FirstOrDefault();
if (u == null)
{
return("error");
}
else
{
string temp = @"{
'Username': '******',
'mailBody': 'הסיסמא שלך היא: " + u.UserPassword + @"',
'mailTitle': 'שיחזור סיסמא'
}
";
dynamic obj = JObject.Parse(temp);
Utils.SendEmail(obj);
return("ok");
}
}
}
catch (Exception e)
{
throw e;
}
}
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;
}
}
protected void Login_Click(object sender, EventArgs e)
{
using (var db = new MSEsystemEntities1())
{
User user = db.User.Where(i => i.Sn == inputUser.Text && i.UserPassword == inputPassword.Text).FirstOrDefault();
if (user == null || user.LoginStatus == true)
{
pnlMessage.Visible = true;
}
else
{
Session["user"] = user.DisplayName;
Session["uid"] = user.Id;
Session["level"] = user.Role; // 1 - admin , 2 - manager , 3 - employee
Response.Redirect("Default.aspx?log=in");
}
}
}
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;
}
}
