public bool updatePersonal(Personal param, long Id)
{
try
{
using (cfgContext db = new cfgContext())
{
var personal = db.Personal.Find(Id);
if (personal != null)
{
personal.Name = param.Name;
personal.Surname = param.Surname;
personal.PRole = param.PRole;
personal.BirthDay = param.BirthDay;
personal.Mail = param.Mail;
personal.Password = param.Password;
personal.Contact = param.Contact;
personal.City = param.City;
personal.State = param.State;
personal.Address = param.Address;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
throw;
}
}
public bool deleteClientManager(long cmId)
{
try
{
using (cfgContext db = new cfgContext())
{
var clientManager = db.ClientManager.Find(cmId);
var user = db.User.FirstOrDefault(r => r.UserId == clientManager.managerUserId);
if (clientManager != null)
{
dellEmail(clientManager.Email);
db.User.Remove(user);
db.ClientManager.Remove(clientManager);
db.SaveChanges(); return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
return(false);
}
}
public bool updateClientManager(ClientManager param, long Id)
{
try
{
using (cfgContext db = new cfgContext())
{
var clientManager = db.ClientManager.Find(Id);
if (clientManager != null)
{
clientManager.Name = param.Name;
clientManager.Surname = param.Surname;
clientManager.Email = param.Email;
clientManager.Password = param.Password;
clientManager.Contact = param.Contact;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
throw;
}
}
public bool updateUser(User param, long Id)
{
try
{
using (cfgContext db = new cfgContext())
{
var user = db.User.Find(Id);
if (user != null)
{
user.UserName = param.UserName;
user.EncryptedPassword = param.EncryptedPassword;
user.Image = param.Image;
user.EmailVeryfied = param.EmailVeryfied;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
throw;
}
}
public bool updateFirm(Firm param, long Id)
{
try
{
using (cfgContext db = new cfgContext())
{
var firm = db.Firm.Find(Id);
if (firm != null)
{
firm.Name = param.Name;
firm.Mail = param.Mail;
firm.Contact = param.Contact;
firm.Fax = param.Fax;
firm.City = param.City;
firm.State = param.State;
firm.Address = param.Address;
firm.Url = param.Url;
firm.Logo = param.Logo;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
throw;
}
}
public List <Firm> FirmList()
{
using (cfgContext db = new cfgContext())
{
return(db.Firm.ToList());
}
}
public bool deleteFirm(long firmId)
{
try
{
using (cfgContext db = new cfgContext())
{
var firm = db.Firm.Find(firmId);
if (firm != null)
{
var um = new UserManagement.UserFunctions();
um.dellEmail(firm.Mail);
db.Firm.Remove(firm);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
return(false);
}
}
public bool deletePersonal(long pId)
{
try
{
using (cfgContext db = new cfgContext())
{
var personal = db.Personal.Find(pId);
var user = db.User.FirstOrDefault(r => r.UserId == personal.personalUserId);
if (personal != null)
{
dellEmail(personal.Mail);
db.User.Remove(user);
db.Personal.Remove(personal);
db.SaveChanges(); return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
return(false);
}
}
public Notification findNotif(long Id)
{
using (cfgContext db = new cfgContext())
{
return(db.Notification.Find(Id));
}
}
public List <Ticket> ListTickets()
{
using (cfgContext db = new cfgContext())
{
return(db.Ticket.ToList());
}
}
public bool addDepartment(Department param, long Id)
{
try
{
using (cfgContext db = new cfgContext())
{
var partner = db.CustomerFirmManager.Include("Client").Include("Client.ManagerFirm").Include("Client.ManagerFirm").FirstOrDefault(r => r.CustomerFirmManagerId == Id);
if (partner.Client.ManagerFirm.Departments == null)
{
partner.Client.ManagerFirm.Departments = new List <Department>();
}
if (partner.Client.ManagerFirm.Departments.FirstOrDefault(r => r.Name.ToLower().TrimEnd().Contains(param.Name.ToLower().TrimEnd())) == null)
{
partner.Client.ManagerFirm.Departments.Add(param);
}
else
{
return(false);
}
db.SaveChanges();
return(true);
}
}
catch (Exception e)
{
return(false);
}
}
public List <CustomerFirmManager> ListCustomerFirm()
{
using (cfgContext db = new cfgContext())
{
return(db.CustomerFirmManager.ToList());
}
}
public bool addWorkFlow(WorkFlow param, long dId)
{
try
{
using (cfgContext db = new cfgContext())
{
var department = db.Department.FirstOrDefault(r => r.DepartmentId == dId);
if (department.WorkFlows == null)
{
department.WorkFlows = new List <WorkFlow>();
}
if (department.WorkFlows.FirstOrDefault(r => r.Name.ToLower().TrimEnd().Contains(param.Name.ToLower().TrimEnd())) == null)
{
department.WorkFlows.Add(param);
}
else
{
return(false);
}
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public async Task <Root> GetRoot(string UserName, string Password)
{
using (cfgContext db = new cfgContext())
{
return(await db.Root.FirstOrDefaultAsync(r => r.Username.ToLower().TrimEnd().Contains(UserName.ToLower().TrimEnd()) && r.Password.Equals(Password)));
}
}
public bool isPartnerExist(long partnerFirmId, long currentFirmId)
{
try
{
using (cfgContext db = new cfgContext())
{
var fm = new FirmManagement.FirmFunctions();
var currentFirm = fm.findFirm(currentFirmId);
var managers = db.Firm
.Include("CustomerFirmManagers").Include("CustomerFirmManagers.Client").Include("CustomerFirmManagers.Client.ManagerFirm")
.FirstOrDefault(q => q.FirmId == currentFirmId).CustomerFirmManagers.ToList();
var customerFirm = managers.FirstOrDefault(w => w.Client.ManagerFirm.FirmId == partnerFirmId);
if (customerFirm != null)
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception e)
{
throw;
}
}
public bool updateWork(Work param, long Id)
{
try
{
using (cfgContext db = new cfgContext())
{
var work = db.Work.Find(Id);
if (work != null)
{
work.Name = param.Name;
work.Title = param.Title;
work.Definition = param.Definition;
work.Status = param.Status;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
throw;
}
}
public bool updateWorkState(long id)
{
try
{
using (cfgContext db = new cfgContext())
{
var work = db.Work.Find(id);
if (work.State == "Tamamlandı")
{
work.State = "Çalışılıyor";
work.Finish_Date = default(DateTime);
}
else
{
work.State = "Çalışılıyor";
work.Start_Date = DateTime.Now;
}
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool updateDepartment(Department param, long Id)
{
try
{
using (cfgContext db = new cfgContext())
{
var department = db.Department.Find(Id);
if (department != null)
{
department.Name = param.Name;
department.Title = param.Title;
department.Definition = param.Definition;
department.Status = param.Status;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
throw;
}
}
public List <Work> WorkList()
{
using (cfgContext db = new cfgContext())
{
return(db.Work.ToList());
}
}
public bool setRead(long uId, long mId, string role)
{
try
{
using (cfgContext db = new cfgContext())
{
if (role == "ClientManager")
{
var msj = db.ClientManager.Include("managerUser").Include("managerUser.Messages").FirstOrDefault(r => r.ClientManagerId == uId).managerUser.Messages.FirstOrDefault(q => q.MessageId == mId);
msj.MessageRead = true;
db.SaveChanges();
return(true);
}
else
{
var msj = db.Personal.Include("personalUser").Include("personalUser.Messages").FirstOrDefault(r => r.PersonalId == uId).personalUser.Messages.FirstOrDefault(q => q.MessageId == mId);
msj.MessageRead = true;
db.SaveChanges();
return(true);
}
}
}
catch (Exception e)
{
return(false);
}
}
public List <ClientManager> ClientManagerList()
{
using (cfgContext db = new cfgContext())
{
return(db.ClientManager.Include("managerUser").Include("ManagerFirm").ToList());
}
}
public void createNotif(string title, string message, string state)
{
try
{
using (cfgContext db = new cfgContext())
{
Notification notif = new Notification
{
title = title,
message = message,
createdate = DateTime.Now,
state = state,
isseen = false,
status = false,
notifstatus = false
};
db.Notification.Add(notif);
db.SaveChanges();
}
}
catch (Exception e)
{
throw;
}
}
public List <Note> ListNotes()
{
using (cfgContext db = new cfgContext())
{
return(db.Note.ToList());
}
}
public void addMessageNotification(Message msg, long pId)
{
try
{
using (cfgContext db = new cfgContext())
{
Notification notif = new Notification
{
title = "Yeni Mesaj Alındı.",
message = msg.SenderUserName + " adlı kişi mesaj gönderdi.",
detailUrl = "#",
createdate = DateTime.Now,
isseen = false,
notifstatus = false,
state = "Bildirilmedi",
status = true
};
var personal = db.Personal.Include("Works").Include("personalUser").Include("personalUser.Notifications").FirstOrDefault(s => s.personalUserId == pId);
if (personal.personalUser.Notifications == null)
{
personal.personalUser.Notifications = new List <Notification>();
}
personal.personalUser.Notifications.Add(notif);
db.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
public bool updateWorkFlow(WorkFlow param, long Id)
{
try
{
using (cfgContext db = new cfgContext())
{
var workflow = db.WorkFlow.Find(Id);
if (workflow != null)
{
workflow.Name = param.Name;
workflow.Title = param.Title;
workflow.Definition = param.Definition;
workflow.State = param.State;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
return(false);
}
}
public bool updateNotificationSeen(long id)
{
try
{
using (cfgContext db = new cfgContext())
{
var notif = db.User.Include("Notifications").FirstOrDefault(r => r.UserId == id).Notifications.Where(r => r.isseen == false).ToList();
foreach (var item in notif)
{
if (item.isseen == false)
{
item.isseen = true;
}
}
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public List <Personal> PersonalList(long id)
{
using (cfgContext db = new cfgContext())
{
return(db.Personal.Include("personalUser").Where(r => r.OwnFirmId == id).ToList());
}
}
public async Task <User> GetUser(string UserName, string Password)
{
using (cfgContext db = new cfgContext())
{
var EncPassword = SessionSettings.Crypting.En_De_crypt._Encrypt(Password);
return(await db.User.FirstOrDefaultAsync(r => r.UserName.ToLower().TrimEnd().Contains(UserName.ToLower().TrimEnd()) && r.EncryptedPassword.Equals(EncPassword)));
}
}
public List <Department> ListDepartment(long id)
{
using (cfgContext db = new cfgContext())
{
return(db.Firm.Include("CustomerFirmManagers").Include("CustomerFirmManagers.Client").Include("CustomerFirmManagers.Client.ManagerFirm").Include("CustomerFirmManagers.Client.ManagerFirm.Departments")
.FirstOrDefault(q => q.FirmId == id).CustomerFirmManagers.ToList().SelectMany(w => w.Client.ManagerFirm.Departments).ToList());
}
}
public ClientManager findNotesManager(long id)
{
using (cfgContext db = new cfgContext())
{
var notes = db.ClientManager.Include("Notes").FirstOrDefault(r => r.managerUserId == id);
return(notes);
}
}
