public static bool EditUser(User model) { using (DeneysanContext db = new DeneysanContext()) { try { User record = db.User.Where(d => d.UserId == model.UserId).SingleOrDefault(); if (record != null) { record.FullName = model.FullName; record.Email = model.Email; if(model.Password != "") record.Password = model.Password; record.Institution = model.Institution; record.Contact = model.Contact; db.SaveChanges(); return true; } else return false; } catch (Exception) { return false; } } }
public static bool DeleteGroup(int id) { using (DeneysanContext db = new DeneysanContext()) { try { var record = db.ProjectGroup.FirstOrDefault(d => d.ProjectGroupId == id); db.ProjectGroup.Remove(record); db.SaveChanges(); //LogtrackManager logkeeper = new LogtrackManager(); //logkeeper.LogDate = DateTime.Now; //logkeeper.LogProcess = EnumLogType.DokumanGrup.ToString(); //logkeeper.Message = LogMessages.ProjectGroupDeleted; //logkeeper.User = HttpContext.Current.User.Identity.Name; //logkeeper.Data = record.GroupName; //logkeeper.AddInfoLog(logger); return true; } catch (Exception) { return false; } } }
public static bool EditInstituional(Institutional record) { using (DeneysanContext db = new DeneysanContext()) { try { Institutional editrecord = db.Institutional.SingleOrDefault(d => d.TypeId == record.TypeId && d.Language == record.Language); if (editrecord == null) { editrecord = new Institutional(); editrecord.TimeUpdated = DateTime.Now; editrecord.TypeId = record.TypeId; editrecord.Language = record.Language; editrecord.Content = record.Content; db.Institutional.Add(editrecord); } else { editrecord.TimeUpdated = DateTime.Now; editrecord.Content = record.Content; } db.SaveChanges(); return true; } catch (Exception) { return false; } } }
public static AdminUser GetAdminFirst() { using (DeneysanContext db = new DeneysanContext()) { return db.AdminUser.FirstOrDefault(); } }
public static dynamic EditNews(News newsmodel) { using (DeneysanContext db = new DeneysanContext()) { try { News record = db.News.Where(d => d.NewsId == newsmodel.NewsId && d.Deleted == false).SingleOrDefault(); if (record != null) { record.Header = newsmodel.Header; record.Language = newsmodel.Language; record.Content = newsmodel.Content; if (!string.IsNullOrEmpty(newsmodel.NewsImage)) { record.NewsImage = newsmodel.NewsImage; } record.PageSlug = newsmodel.PageSlug; record.TimeUpdated = DateTime.Now; record.Spot = newsmodel.Spot; db.SaveChanges(); return true; } else return false; } catch (Exception ex) { return false; } } }
public static bool AddReference(References record) { using (DeneysanContext db = new DeneysanContext()) { try { if (!record.TimeCreated.HasValue) record.TimeCreated = DateTime.Now; record.Deleted = false; record.Online = true; db.References.Add(record); db.SaveChanges(); LogtrackManager logkeeper = new LogtrackManager(); logkeeper.LogDate = DateTime.Now; logkeeper.LogProcess = EnumLogType.Referans.ToString(); logkeeper.Message = LogMessages.ReferenceAdded; logkeeper.User = HttpContext.Current.User.Identity.Name; logkeeper.Data = record.ReferenceName; logkeeper.AddInfoLog(logger); return true; } catch (Exception ex) { return false; } } }
public static bool Delete(int id) { using (DeneysanContext db = new DeneysanContext()) { try { var record = db.News.FirstOrDefault(d => d.NewsId == id); record.Deleted = true; db.SaveChanges(); LogtrackManager logkeeper = new LogtrackManager(); logkeeper.LogDate = DateTime.Now; logkeeper.LogProcess = EnumLogType.Haber.ToString(); logkeeper.Message = LogMessages.NewsDeleted; logkeeper.User = HttpContext.Current.User.Identity.Name; logkeeper.Data = record.Header; logkeeper.AddInfoLog(logger); return true; } catch (Exception) { return false; } } }
public static bool AddProduct(Product record) { using (DeneysanContext db = new DeneysanContext()) { try { record.TimeCreated = DateTime.Now; record.Deleted = false; record.Online = true; record.SortNumber = 9999; db.Product.Add(record); db.SaveChanges(); //LogtrackManager logkeeper = new LogtrackManager(); //logkeeper.LogDate = DateTime.Now; //logkeeper.LogProcess = EnumLogType.Dokuman.ToString(); //logkeeper.Message = LogMessages.ProductAdded; //logkeeper.User = HttpContext.Current.User.Identity.Name; //logkeeper.Data = record.Name; //logkeeper.AddInfoLog(logger); return true; } catch (Exception ex) { return false; } } }
public static bool AddBankInfo(BankInfo record) { using (DeneysanContext db = new DeneysanContext()) { try { record.Online = true; db.BankInfo.Add(record); db.SaveChanges(); LogtrackManager logkeeper = new LogtrackManager(); logkeeper.LogDate = DateTime.Now; logkeeper.LogProcess = EnumLogType.BankaBilgisi.ToString(); logkeeper.Message = LogMessages.BankAdded; logkeeper.User = HttpContext.Current.User.Identity.Name; logkeeper.Data = record.BankName; logkeeper.AddInfoLog(logger); return true; } catch (Exception ex) { return false; } } }
public static List<Projects> GetProjectListForFront(string language) { using (DeneysanContext db = new DeneysanContext()) { var list = db.Projects.Where(d => d.Language == language && d.Online==true).OrderBy(d => d.SortOrder).ToList(); return list; } }
public static List<MailUsers> GetMailUsersList(int type) { using (DeneysanContext db = new DeneysanContext()) { var list = db.MailUsers.Where(d => d.MailType == type).ToList(); return list; } }
public static List<BankInfo> GetBankInfoListForFront(string language) { using (DeneysanContext db = new DeneysanContext()) { var list = db.BankInfo.Where(d => d.Language == language && d.Online==true).ToList(); return list; } }
public static HumanResource GetHRByLanguage(string language) { using (DeneysanContext db = new DeneysanContext()) { HumanResource instional_info = db.HumanResource.SingleOrDefault(d => d.Language == language); return instional_info; } }
public static List<DocumentGroup> GetDocumentGroupList(string language) { using (DeneysanContext db = new DeneysanContext()) { var list = db.DocumentGroup.Where(d => d.Deleted == false && d.Language == language).OrderBy(d=>d.SortNumber).ToList(); return list; } }
public static List<ProductGroup> GetProductGroupListForFront(string language) { using (DeneysanContext db = new DeneysanContext()) { var list = db.ProductGroup.Where(d => d.Deleted == false && d.Language == language && d.Online==true).OrderBy(d => d.SortNumber).ToList(); return list; } }
public static List<References> GetReferenceListForFront(string language) { using (DeneysanContext db = new DeneysanContext()) { var list = db.References.Where(d => d.Deleted == false && d.Language == language && d.Online==true).OrderBy(d=>d.SortOrder).ToList(); return list; } }
public static Institutional GetInstationalByLanguage(string language,int typeid) { using (DeneysanContext db = new DeneysanContext()) { Institutional instional_info = db.Institutional.SingleOrDefault(d => d.TypeId == typeid && d.Language == language); return instional_info; } }
public static List<News> GetNewsListForFront(string language) { using (DeneysanContext db = new DeneysanContext()) { var news_list = db.News.Where(d => d.Deleted == false && d.Language == language && d.Online == true).OrderByDescending(d => d.TimeCreated).OrderBy(d => d.SortOrder).ToList(); return news_list; } }
public static News GetNewsItem(int id) { using (DeneysanContext db = new DeneysanContext()) { News news = db.News.Where(d => d.NewsId == id).SingleOrDefault(); return news; } }
public static Contact GetContact(string language) { using (DeneysanContext db = new DeneysanContext()) { var list = db.Contact.Where(d=>d.Language == language).SingleOrDefault(); return list; } }
public static IEnumerable<Languages> GetLanguages() { using (DeneysanContext db=new DeneysanContext()) { IEnumerable<Languages> language_items = db.Languages.ToList(); return language_items; } }
public ActionResult BekleyenProjeler() { string sellang = FillLanguagesList(); using (DeneysanContext db = new DeneysanContext()) { List<Projects> projeler = db.Projects.Where(x => x.Status == (int)EnumProjectStatus.Wait && x.Language == sellang && x.Deleted == false).ToList(); return View(projeler); } }
public static bool ChangePassword(string password, string email) { using (DeneysanContext db = new DeneysanContext()) { User record = db.User.SingleOrDefault(d => d.Email == email); if (record != null) { record.Password = password; db.SaveChanges(); return true; } else return false; } }
public static dynamic EditContact(Contact record) { using (DeneysanContext db = new DeneysanContext()) { try { Contact contact = db.Contact.Where(d => d.Language == record.Language).SingleOrDefault(); if (contact == null) { contact = new Contact(); contact.Address = record.Address; contact.Phone = record.Phone; contact.Fax = record.Fax; contact.Taxnumber = record.Taxnumber; contact.Taxoffice = record.Taxoffice; contact.Email = record.Email; contact.Language = record.Language; db.Contact.Add(contact); } else { contact.Address = record.Address; contact.Phone = record.Phone; contact.Fax = record.Fax; contact.Taxnumber = record.Taxnumber; contact.Taxoffice = record.Taxoffice; contact.Email = record.Email; } db.SaveChanges(); LogtrackManager logkeeper = new LogtrackManager(); logkeeper.LogDate = DateTime.Now; logkeeper.LogProcess = EnumLogType.Contact.ToString(); logkeeper.Message = LogMessages.ContactEdited; logkeeper.User = HttpContext.Current.User.Identity.Name; logkeeper.Data = record.Address; logkeeper.AddInfoLog(logger); return true; } catch (Exception ex) { return false; } } }
public static bool AddApplication(Application record) { using (DeneysanContext db = new DeneysanContext()) { try { db.Application.Add(record); db.SaveChanges(); return true; } catch (Exception ex) { return false; } } }
public static bool AddMailUsers(MailUsers record) { using (DeneysanContext db = new DeneysanContext()) { try { db.MailUsers.Add(record); db.SaveChanges(); return true; } catch (Exception ex) { return false; } } }
public void DeleteProjectImage(int id) { using (DeneysanContext db = new DeneysanContext()) { try { var record = db.ProjectsGallery.FirstOrDefault(d => d.ProjeId == id); db.ProjectsGallery.Remove(record); db.SaveChanges(); } catch (Exception) { } } }
public static bool Delete(int id) { using (DeneysanContext db = new DeneysanContext()) { try { var record = db.Projects.FirstOrDefault(d => d.ProjectId == id); db.Projects.Remove(record); db.SaveChanges(); return true; } catch (Exception) { return false; } } }
public static bool Login(string email,string password) { using(DeneysanContext db=new DeneysanContext()) { AdminUser record = db.AdminUser.SingleOrDefault(d => d.Email == email && d.Password == password); if (record != null) { FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, record.FullName, DateTime.Now, DateTime.Now.AddMinutes(120), false, "Admin", FormsAuthentication.FormsCookiePath); string encTicket = FormsAuthentication.Encrypt(ticket); HttpCookie cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encTicket); if (ticket.IsPersistent) cookie.Expires = ticket.Expiration; HttpContext.Current.Response.Cookies.Add(cookie); return true; } else return false; } }
public static bool AddUsers(User record) { using (DeneysanContext db = new DeneysanContext()) { try { record.isActive = true; db.User.Add(record); db.SaveChanges(); return true; } catch (Exception) { return false; } } }