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 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 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 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 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 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 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 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 AddUsers(User record)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
record.isActive = true;
db.User.Add(record);
db.SaveChanges();
return true;
}
catch (Exception)
{
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 static bool Delete(int id)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
var record = db.Application.FirstOrDefault(d => d.ApplicationId == id);
db.Application.Remove(record);
db.SaveChanges();
return true;
}
catch (Exception)
{
return false;
}
}
}
public bool ChangeProjectStatus(int id, int status)
{
bool returnValue = false;
using (DeneysanContext db = new DeneysanContext())
{
if (db.Projects.Any(d => d.ProjeId == id))
{
Projects record = db.Projects.FirstOrDefault(d => d.ProjeId == id);
record.Status = status;
db.SaveChanges();
return true;
}
else
{
return returnValue;
}
}
}
public static bool AddProjectGroup(ProjectGroup record)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
record.Online = true;
record.SortNumber = 9999;
db.ProjectGroup.Add(record);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
}
public static bool AddNews(News record)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
if (!record.TimeCreated.HasValue)
record.TimeCreated = DateTime.Now;
record.Deleted = false;
record.Online = true;
record.SortOrder = 9999;
db.News.Add(record);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
}
public static bool EditAdminFirst(AdminUser model)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
AdminUser record = db.AdminUser.Where(d => d.AdminUserId == model.AdminUserId).SingleOrDefault();
if (record != null)
{
record.Email = model.Email;
record.Password = model.Password;
db.SaveChanges();
return true;
} else return false;
}
catch (Exception ex)
{
return false;
}
}
}
public static bool AddProject(Projects record)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
record.TimeCreated = DateTime.Now;
record.SortOrder = 9999;
record.Online = true;
db.Projects.Add(record);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
}
public static bool EditProductGroup(ProductGroup record)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
ProductGroup editrecord = db.ProductGroup.Where(d => d.ProductGroupId == record.ProductGroupId && d.Deleted == false).SingleOrDefault();
if (record != null)
{
editrecord.TimeUpdated = DateTime.Now;
editrecord.GroupName = record.GroupName;
editrecord.PageSlug = record.PageSlug;
if (!string.IsNullOrEmpty(record.GroupImage))
editrecord.GroupImage = record.GroupImage;
db.SaveChanges();
//LogtrackManager logkeeper = new LogtrackManager();
//logkeeper.LogDate = DateTime.Now;
//logkeeper.LogProcess = EnumLogType.DokumanGrup.ToString();
//logkeeper.Message = LogMessages.ProductGroupAdded;
//logkeeper.User = HttpContext.Current.User.Identity.Name;
//logkeeper.Data = record.GroupName;
//logkeeper.AddInfoLog(logger);
return true;
}
else
return false;
}
catch (Exception ex)
{
return false;
}
}
}
public static bool UpdateStatus(int id)
{
using (DeneysanContext db = new DeneysanContext())
{
var list = db.References.SingleOrDefault(d => d.ReferenceId == id);
try
{
if (list != null)
{
list.Online = list.Online == true ? false : true;
db.SaveChanges();
}
return list.Online;
}
catch (Exception)
{
return list.Online;
}
}
}
public static bool EditHumanResource(HumanResource record)
{
using (DeneysanContext db = new DeneysanContext())
{
HumanResource editrecord = db.HumanResource.SingleOrDefault(d => d.Language == record.Language);
if (editrecord == null)
{
editrecord = new HumanResource();
editrecord.Language = record.Language;
editrecord.Content = record.Content;
db.HumanResource.Add(editrecord);
}
else
{
editrecord.Content = record.Content;
}
db.SaveChanges();
return true;
}
}
public static bool SortRecords(string[] idsList)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
int row = 0;
foreach (string id in idsList)
{
int mid = Convert.ToInt32(id);
GalleryGroup sortingrecord = db.GalleryGroup.SingleOrDefault(d => d.GalleryGroupId == mid);
sortingrecord.SortOrder = Convert.ToInt32(row);
db.SaveChanges();
row++;
}
return true;
}
catch (Exception)
{
return false;
}
}
}
public JsonResult ProjeKaydet(Projects model, string hdndokumanfile, string hdnimagefile)
{
using (DeneysanContext db = new DeneysanContext())
{
model.PageSlug = Utility.SetPagePlug(model.ProjeAdi);
model.TimeCreated = DateTime.Now;
model.Status = 0;
model.Language = lang;
model.Online = true;
if (!string.IsNullOrEmpty(hdnimagefile))
{
model.ProjeDokümani = "/Content/projectfiles/" + hdndokumanfile;
}
db.Projects.Add(model);
db.SaveChanges();
if (!string.IsNullOrEmpty(hdnimagefile))
{
string[] imagesArray = hdnimagefile.Split(',');
if (imagesArray != null && imagesArray.Length > 0)
{
for (int i = 0; i < imagesArray.Length; i++)
{
ProjectsGallery g = new ProjectsGallery();
g.ProjeId = model.ProjeId;
g.Image = "/Content/images/projects/" + imagesArray[i];
g.ImageThumb = "/Content/images/projects/" + "thumb_" + imagesArray[i];
db.ProjectsGallery.Add(g);
}
}
db.SaveChanges();
var mset = MailManager.GetMailSettings();
var msend = MailManager.GetMailUsersList(1);
using (var client = new SmtpClient(mset.ServerHost, mset.Port))
{
client.EnableSsl = false;
client.Credentials = new NetworkCredential(mset.ServerMail, mset.Password);
var mail = new MailMessage();
mail.From = new MailAddress(mset.ServerMail);
foreach (var item in msend)
mail.To.Add(item.MailAddress);
mail.Subject = "Yeni Proje Başvuru Bildirimi";
mail.IsBodyHtml = true;
mail.Body = "<h5><b>" + model.ProjeSahibi + " isimli kişiden bir proje başvurusu sistemde kayıt altına alınmıştır</b></h5>";
if (mail.To.Count > 0) client.Send(mail);
}
}
}
return Json(true);
}
public static bool EditDocument(Document data)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
Document record = db.Document.Where(d => d.DocumentId == data.DocumentId && d.Deleted == false).SingleOrDefault();
if (record != null)
{
record.Name = data.Name;
record.Language = data.Language;
record.DocumentGroupId = data.DocumentGroupId;
if (!string.IsNullOrEmpty(data.DocumentFile))
{
record.DocumentFile = data.DocumentFile;
}
record.TimeUpdated = DateTime.Now;
db.SaveChanges();
LogtrackManager logkeeper = new LogtrackManager();
logkeeper.LogDate = DateTime.Now;
logkeeper.LogProcess = EnumLogType.Dokuman.ToString();
logkeeper.Message = LogMessages.DocumentEdited;
logkeeper.User = HttpContext.Current.User.Identity.Name;
logkeeper.Data = record.Name;
logkeeper.AddInfoLog(logger);
return true;
}
else
return false;
}
catch (Exception ex)
{
return false;
}
}
}
public static object RemoveVideo(int id)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
Product record = db.Product.Where(d => d.ProductId == id && d.Deleted == false).SingleOrDefault();
if (record != null)
{
record.filevideo = null;
db.SaveChanges();
return true;
}
else
return false;
}
catch (Exception ex)
{
return false;
}
}
}
public static bool EditProjectGroup(int id, string name, string pageslug)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
ProjectGroup record = db.ProjectGroup.Where(d => d.ProjectGroupId == id).SingleOrDefault();
if (record != null)
{
record.GroupName = name;
record.PageSlug = pageslug;
db.SaveChanges();
//LogtrackManager logkeeper = new LogtrackManager();
//logkeeper.LogDate = DateTime.Now;
//logkeeper.LogProcess = EnumLogType.DokumanGrup.ToString();
//logkeeper.Message = LogMessages.ProjectGroupEdited;
//logkeeper.User = HttpContext.Current.User.Identity.Name;
//logkeeper.Data = record.GroupName;
//logkeeper.AddInfoLog(logger);
return true;
}
else
return false;
}
catch (Exception ex)
{
return false;
}
}
}
public static bool SortDocuments(string[] idsList)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
int row = 0;
foreach (string id in idsList)
{
int mid = Convert.ToInt32(id);
Document sortingrecord = db.Document.SingleOrDefault(d => d.DocumentId == mid);
sortingrecord.SortNumber = Convert.ToInt32(row);
db.SaveChanges();
row++;
}
return true;
}
catch (Exception)
{
return false;
}
}
}
public static bool EditProduct(Product data)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
Product record = db.Product.Where(d => d.ProductId == data.ProductId && d.Deleted == false).SingleOrDefault();
if (record != null)
{
record.Name = data.Name;
record.Content = data.Content;
record.PageSlug = data.PageSlug;
record.Language = data.Language;
record.Hardware = data.Hardware;
record.HardwarePrice = data.HardwarePrice;
record.Price = data.Price;
record.Code = data.Code;
record.ProductGroupId = data.ProductGroupId;
if (!string.IsNullOrEmpty(data.ProductImage))
{
record.ProductImageThumb = data.ProductImageThumb;
record.ProductImage = data.ProductImage;
}
if (!string.IsNullOrEmpty(data.filexperiment))
{
record.filexperiment = data.filexperiment;
}
if (!string.IsNullOrEmpty(data.filetechnical))
{
record.filetechnical = data.filetechnical;
}
if (!string.IsNullOrEmpty(data.filetraining))
{
record.filetraining = data.filetraining;
}
if (!string.IsNullOrEmpty(data.filevideo))
{
record.filevideo = data.filevideo;
}
db.SaveChanges();
//LogtrackManager logkeeper = new LogtrackManager();
//logkeeper.LogDate = DateTime.Now;
//logkeeper.LogProcess = EnumLogType.Dokuman.ToString();
//logkeeper.Message = LogMessages.ProductEdited;
//logkeeper.User = HttpContext.Current.User.Identity.Name;
//logkeeper.Data = record.Name;
//logkeeper.AddInfoLog(logger);
return true;
}
else
return false;
}
catch (Exception ex)
{
return false;
}
}
}
public static bool EditReference(References referencemodel)
{
using (DeneysanContext db = new DeneysanContext())
{
try
{
References record = db.References.Where(d => d.ReferenceId == referencemodel.ReferenceId && d.Deleted == false).SingleOrDefault();
if (record != null)
{
record.Content = referencemodel.Content;
record.Link = referencemodel.Link;
record.ReferenceName = referencemodel.ReferenceName;
record.Language = referencemodel.Language;
if (!string.IsNullOrEmpty(referencemodel.Logo))
{
record.Logo = referencemodel.Logo;
}
record.Content = referencemodel.Content;
db.SaveChanges();
LogtrackManager logkeeper = new LogtrackManager();
logkeeper.LogDate = DateTime.Now;
logkeeper.LogProcess = EnumLogType.Referans.ToString();
logkeeper.Message = LogMessages.ReferenceEdited;
logkeeper.User = HttpContext.Current.User.Identity.Name;
logkeeper.Data = record.ReferenceName;
logkeeper.AddInfoLog(logger);
return true;
}
else
return false;
}
catch (Exception ex)
{
return false;
}
}
}
