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 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 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 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 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 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 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 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 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 InsertOrUpdatePayment(Payments payment)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
if (db.Payments.Any(v => v.PaymentId == payment.PaymentId))
{
db.Entry(payment).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return true;
}
else
{
payment.CreateTime = DateTime.Now;
db.Payments.Add(payment);
db.SaveChanges();
return true;
}
}
catch (Exception ex)
{
return false;
throw;
}
}
}
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 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 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 SoftDelete(District dist)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
dist.DeleteStatus = true;
db.Entry(dist).State = System.Data.Entity.EntityState.Modified;
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 SoftDelete(int id)
{
using (FotografPaketiEntities db = new FotografPaketiEntities())
{
try
{
Languages lng = db.Languages.Find(id);
lng.Status = true;
db.Entry(lng).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return true;
}
catch (Exception ex)
{
return false;
throw;
}
}
}
