public bool Delete(T_PHONE_BOOK item)
{
bool isDeleted = false;
if (item != null)
{
try
{
using (PHONE_BOOK_DBEntities db = new PHONE_BOOK_DBEntities())
{
item.DELETED_DATE = DateTime.Now;
db.T_PHONE_BOOK.Add(item);
db.Entry(item).State = System.Data.Entity.EntityState.Modified; // delete logjik
db.SaveChanges();
isDeleted = true;
}
}
catch (Exception ex)
{
// write logs into file logs
}
}
return(isDeleted);
}
public string Put(PhoneBookModel model)
{
if (model != null && model.Id.HasValue)
{
//Test2
T_PHONE_BOOK item = service.GetById(model.Id.Value);
if (item != null)
{
//Test4 --> Test2-->Test4
model.Fill(item);
if (service.Put(item))
{
return("Elementi u modifikua me sukses");
}
else
{
return("Probleme gjate modifikimie");
}
}
else
{
return("Elementi nuk u gjet ne bazen e te dhenave");
}
}
else
{
return("Specifikoni nje objekt te vlefshem");
}
}
public string Delete(long id)
{
if (id > 0)
{
T_PHONE_BOOK item = service.GetById(id);
if (item != null)
{
if (service.Delete(item))
{
return("Elementi u fshi me sukses");
}
else
{
return("Probleme gjate fshirjes");
}
}
else
{
return("Elementi nuk u gjet ne bazen e te dhenave");
}
}
else
{
return("Specifikoni nje id te vleshfshme");
}
}
public void Fill(T_PHONE_BOOK itemtoFill)
{
itemtoFill.NAME = this.Name;
itemtoFill.SURNAME = this.Surname;
itemtoFill.ID_PHONE_TYPE = this.IdPhoneType;
itemtoFill.NUMBER = this.Number;
}
public void Preselect(T_PHONE_BOOK item)
{
if (item != null)
{
this.Name = item.NAME;
this.Surname = item.SURNAME;
this.IdPhoneType = item.ID_PHONE_TYPE;
this.Number = item.NUMBER;
}
}
public string Save(PhoneBookModel model)
{
T_PHONE_BOOK item = new T_PHONE_BOOK();
model.Fill(item);
if (model != null)
{
if (service.Save(item))
{
return("Elementi u shtua me sukses");
}
else
{
return("Probleme gjate shtimit");
}
}
else
{
return("Specifikoni nje objekt te vlefshem");
}
}
public bool Save(T_PHONE_BOOK item)
{
bool isInserted = false;
if (item != null)
{
try
{
using (PHONE_BOOK_DBEntities db = new PHONE_BOOK_DBEntities())
{
item.INSERTED_DATE = DateTime.Now;
db.T_PHONE_BOOK.Add(item);
db.SaveChanges();
isInserted = true;
}
}
catch (Exception ex)
{
// write logs into file logs
}
}
return(isInserted);
}
/// <summary>
/// Kjo metode tenton te realizoje nje delete fizik mbi bazen e te dhenave per objektin e percaktuar
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool DeleteFizik(T_PHONE_BOOK item)
{
bool isDeleted = false;
if (item != null)
{
try
{
using (PHONE_BOOK_DBEntities db = new PHONE_BOOK_DBEntities())
{
db.T_PHONE_BOOK.Attach(item);
db.T_PHONE_BOOK.Remove(item);
db.SaveChanges();
isDeleted = true;
}
}
catch (Exception ex)
{
// write logs into file logs
}
}
return(isDeleted);
}
