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;
}
}
}
