public static bool Delete(int pcid)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
PhotographerCities pc = Find(pcid);
db.Entry(pc).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return true;
}
}
public static bool Delete(int wordid)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
Words word = Find(wordid);
db.Entry(word).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return true;
}
}
public static bool Update(Credits credit)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
db.Entry(credit).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Delete(City city)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
db.Entry(city).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Delete(int rmid)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
RoleModules rm = Find(rmid);
db.Entry(rm).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Delete(int adminId)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
Administrator admin = db.Administrator.Find(adminId);
db.Entry(admin).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Delete(int id)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
District dist = Find(id);
db.Entry(dist).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Delete(int memberId)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
Members member = Find(memberId);
db.Entry(member).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Insert(Credits credit)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
credit.Status = false;
db.Credits.Add(credit);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Delete(int pcid)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
PhotographerCredits pc = Find(pcid);
db.Entry(pc).State = EntityState.Deleted;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Delete(int pgid)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
PhotographerGenres pg = Find(pgid);
db.Entry(pg).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Insert(Gallery gallery)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
gallery.DeleteStatus = false;
gallery.CreateTime = DateTime.Now.ToString();
db.Gallery.Add(gallery);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Insert(MemberFavorites mf)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
if (IsFavoriteExist((int)mf.MemberId, (int)mf.PhotographerId))
return false;
mf.DeleteStatus = false;
db.MemberFavorites.Add(mf);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Insert(Words word)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
if (db.Words.Any(v => v.Word == word.Word))
return false;
word.Status = false;
db.Words.Add(word);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Insert(RoleModules rm)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
db.RoleModules.Add(rm);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Update(Words word)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
if (db.Words.Any(v => v.Word == word.Word))
return false;
db.Entry(word).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool SoftDelete(Genres genre)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
genre.DeleteStatus = true;
db.Entry(genre).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Insert(Modules module)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
module.DeleteStatus = false;
db.Modules.Add(module);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Login(string username, string password)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
bool result = LoginControl(username, password);
if (result)
{
Administrator admin = db.Administrator.Where(v => v.Username == username).FirstOrDefault();
string sessionId = admin.AdministratorId.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString();
HttpContext.Current.Session.Add("admin", sessionId);
admin.SessionId = sessionId;
db.Entry(admin).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return true;
}
else
return false;
}
}
public static bool Insert(City city)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
city.DeleteStatus = false;
db.City.Add(city);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Insert(Administrator admin)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
string hashpassword = FormsAuthentication.HashPasswordForStoringInConfigFile(admin.Password, "md5");
admin.Password = hashpassword;
admin.CreateTime = DateTime.Now;
admin.DeleteStatus = false;
db.Administrator.Add(admin);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Insert(Members member)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
member.CreateDate = DateTime.Now;
member.LoginDate = DateTime.Now;
string hashpassword = FormsAuthentication.HashPasswordForStoringInConfigFile(member.Password, "md5");
member.Password = hashpassword;
member.Status = 0;
db.Members.Add(member);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Insert(PhotographerCredits pc)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
pc.AddTime = DateTime.Now;
db.PhotographerCredits.Add(pc);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Update(PhotographerCredits pc)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
db.Entry(pc).State = EntityState.Modified;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Login(string email, string password,bool rememberme)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
bool loginResult = LoginControl(email, password);
if (loginResult)
{
Members member = db.Members.Where(v => v.Email == email).FirstOrDefault();
string sessionId = member.MemberId.ToString() + DateTime.Now.Minute + DateTime.Now.Second + DateTime.Now.Millisecond;
member.SessionId = sessionId;
db.Entry(member).State = System.Data.Entity.EntityState.Modified;
int updateResult = db.SaveChanges();
if (updateResult > 0)
{
HttpContext.Current.Session.Add("memberSession", sessionId);
if (rememberme)
{
CookieUtil.CreateCookie("memberCookie", sessionId, 30);
}
return true;
}
else
return false;
}
else
return false;
}
}
public static bool SoftDelete(int cid)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
Country c = Find(cid);
c.Status = true;
db.Entry(c).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return true;
}
}
public static bool SoftDelete(Members member)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
member.Status = 1;
db.Entry(member).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Insert(Photo photo)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
photo.GalleryId = -1;
photo.CreateTime = DateTime.Now;
photo.LikeCount = 0;
photo.Hit = 0;
photo.Status = false;
db.Entry(photo).State = System.Data.Entity.EntityState.Added;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Insert(Role role)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
role.DeleteStatus = false;
role.CreateTime = DateTime.Now;
db.Role.Add(role);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
public static bool Insert(PhotographerGenres pg)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
if (IsExist((int)pg.PhotographerId, (int)pg.GenreId))
return false;
pg.Status = false;
db.PhotographerGenres.Add(pg);
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
