public ReturnDto NotebooksUpdate(string NotebooksCode, string Users, string Vendor, string SerialNum, string PcName, string WifiMac, string EthMac, string OperationSystem, string Specification, string WindowsCdkey, string SSD, string SSDSerial, DateTime PurchaseDate, string InvoiceNumber, string OldUser)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var m = data.TB_Notebooks.Where(p => p.UserCode == NotebooksCode).FirstOrDefault();
m.EthMac = EthMac;
m.InvoiceNumber = InvoiceNumber;
m.OldUser = OldUser;
m.OperationSystem = OperationSystem;
m.PcName = PcName;
m.PurchaseDate = PurchaseDate;
m.SerialNum = SerialNum;
m.Specification = Specification;
m.SSD = SSD;
m.SSDSerial = SSDSerial;
m.Users = Users;
m.Vendor = Vendor;
m.WifiMac = WifiMac;
m.WindowsCdKey = WindowsCdkey;
data.SaveChanges();
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
public ReturnDto mobileUpdate(string MobileCode, string Demirbas, string Name, string Phone, string Number, string SerialNumber, string IMEI, string MAC, DateTime PurchaseDate, string InvInvoiceNumber, string Olduser)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var m = data.TB_Mobile.Where(p => p.UserCode == MobileCode).FirstOrDefault();
m.Demirbas = Demirbas;
m.IMEI = IMEI;
m.InvoiceNumber = InvInvoiceNumber;
m.MAC = MAC;
m.Name = Name;
m.Number = Number;
m.OldUser = Olduser;
m.Phone = Phone;
m.PurchaseDate = PurchaseDate;
m.SerialNumber = SerialNumber;
data.SaveChanges();
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
public ReturnDto PrintersUpdate(string PrintersCode, string Brand, string IP, string BasicFeatures, string SerialNumber, string NetworkName, string Location, string InventoryNumber, string InvoiceContract, string Status, DateTime PurchaseDate)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var m = data.TB_Printers.Where(p => p.UserCode == PrintersCode).FirstOrDefault();
m.BasicFeatures = BasicFeatures;
m.Brand = Brand;
m.InventoryNumber = InventoryNumber;
m.InvoiceContract = InvoiceContract;
m.IP = IP;
m.Location = Location;
m.NetworkName = NetworkName;
m.PurchaseDate = PurchaseDate;
m.SerialNumber = SerialNumber;
m.Status = Status;
data.SaveChanges();
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
public ReturnDto OthersUpdate(string OthersCode, string Users, string Brand, string SerialNumber, string Features, string Location, string Specification, DateTime PurchaseDate, string InvoiceNumber, string OldUser)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var m = data.TB_Others.Where(p => p.UserCode == OthersCode).FirstOrDefault();
m.Brand = Brand;
m.Features = Features;
m.InvoiceNumber = InvoiceNumber;
m.Location = Location;
m.PurchaseDate = PurchaseDate;
m.OldUser = OldUser;
m.SerialNumber = SerialNumber;
m.Specification = Specification;
m.Users = Users;
data.SaveChanges();
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
/// <summary>
/// DELETE Department method
/// </summary>
/// <param name="depart"></param>
/// <returns>
/// bool value of method's execution
/// </returns>
public static bool Remove(Depart depart)
{
using (EquipmentsEntities context = new EquipmentsEntities())
{
try
{
int id = Convert.ToInt32(depart.Id);
DeptEntity dept = context.Depts.Single(d => d.Id == id);
context.Depts.Remove(dept);
var equipments = context.Equip.Where(e => e.DeptsId == dept.Id).ToList();
foreach (var eq in equipments)
{
eq.DeptsId = null;
}
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
public ReturnDto MonitorsUpdate(string MonitorsCode, string Demirbas, string Brand, string Users, string SerialNumber, string BrandFeatures, string Place, string Status, DateTime PurchaseDate, string InvoiceNumber, string Olduser)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var m = data.TB_Monitors.Where(p => p.UserCode == MonitorsCode).FirstOrDefault();
m.Brand = Brand;
m.BrandFeatures = BrandFeatures;
m.Demirbas = Demirbas;
m.SerialNumber = SerialNumber;
m.InvoiceNumber = InvoiceNumber;
m.OldUser = Olduser;
m.Place = Place;
m.PurchaseDate = PurchaseDate;
m.Status = Status;
m.Users = Users;
data.SaveChanges();
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
/// <summary>
/// DELETE Manufacturer method
/// </summary>
/// <param name="manufact"></param>
/// <returns>
/// bool value of method's execution
/// </returns>
public static bool Remove(Manufact manufact)
{
using (EquipmentsEntities context = new EquipmentsEntities())
{
try
{
int id = Convert.ToInt32(manufact.Id);
var man = context.Manufactures.Single(m => m.Id == id);
var equipments = context.Equip.Where(e => e.ManufacturesId == man.Id).ToList();
foreach (var eq in equipments)
{
eq.ManufacturesId = null;
}
context.Manufactures.Remove(man);
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
/// <summary>
/// CREATE Equipment method
/// </summary>
/// <param name="equipment"></param>
/// <returns>
/// bool value of method's execution
/// </returns>
public static bool Create(Equipment equipment)
{
using (EquipmentsEntities context = new EquipmentsEntities())
{
try
{
EquipEntity newE = new EquipEntity();
newE.EuqipName = equipment.Name;
newE.EquipPrice = equipment.Price;
newE.EuqipTitle = equipment.Title;
newE.EquipSerialNumber = equipment.SerialNumber;
newE.EuqipPartNumber = equipment.PartNumber;
newE.ManufacturesId = equipment.ManId;
newE.DeptsId = equipment.DepId;
newE.DateIn = equipment.DateIn;
context.Equip.Add(newE);
context.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
public ReturnDto VınnUpdate(string VınnCode, string Users, string Operator, string SerialNumber, string IMEI, string DeviceName, string SımCardNo, string PIN1, string PIN2, string PUK1, string PUK2, string Special, string Status, DateTime PurchaseDate, string Olduser)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var m = data.TB_VINN.Where(p => p.UserCode == VınnCode).FirstOrDefault();
m.IMEI = IMEI;
m.DeviceName = DeviceName;
m.OldUser = Olduser;
m.Operator = Operator;
m.PIN1 = PIN1;
m.PIN2 = PIN2;
m.PUK1 = PUK1;
m.PUK2 = PUK2;
m.PurchaseDate = PurchaseDate;
m.SerialNumber = SerialNumber;
m.Special = Special;
m.Status = Status;
m.SımCardNo = SımCardNo;
m.Users = Users;
data.SaveChanges();
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
public ReturnDto SoftwareAdd(string Name, string Status, DateTime PurchaseDate)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
string kod;
int max_id = data.TB_Software.Max(p => p.ID);
kod = "Mt-" + max_id;
TB_Software m = new TB_Software();
m.UserCode = kod;
m.Name = Name;
m.Status = Status;
m.PurchaseDate = PurchaseDate;
m.KayitDurum = "Active";
data.TB_Software.Add(m);
data.SaveChanges();
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
public ReturnDto NotebooksAdd(string Users, string Vendor, string SerialNum, string PcName, string WifiMac, string EthMac, string OperationSystem, string Specification, string WindowsCdkey, string SSD, string SSDSerial, DateTime PurchaseDate, string InvoiceNumber, string OldUser)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var t = data.TB_Notebooks.Where(p => p.SerialNum == SerialNum).Select(p => p.SerialNum).FirstOrDefault();
var t1 = data.TB_Notebooks.Where(p => p.EthMac == EthMac).Select(p => p.EthMac).FirstOrDefault();
var t2 = data.TB_Notebooks.Where(p => p.WifiMac == WifiMac).Select(p => p.WifiMac).FirstOrDefault();
if (SerialNum == t)
{
return(new ReturnDto(false, ReturnDto.SerialError));
}
if (WifiMac == t2)
{
return(new ReturnDto(false, ReturnDto.WifiErro));
}
if (EthMac == t1)
{
return(new ReturnDto(false, ReturnDto.EthMac));
}
string kod;
int max_id = data.TB_Notebooks.Max(p => p.ID);
kod = "Mv-" + max_id;
TB_Notebooks m = new TB_Notebooks();
m.EthMac = EthMac;
m.InvoiceNumber = InvoiceNumber;
m.KayıtTarihi = DateTime.Now;
m.OldUser = OldUser;
m.OperationSystem = OperationSystem;
m.PcName = PcName;
m.PurchaseDate = PurchaseDate;
m.SerialNum = SerialNum;
m.Specification = Specification;
m.SSD = SSD;
m.SSDSerial = SSDSerial;
m.UserCode = kod;
m.Users = Users;
m.Vendor = Vendor;
m.WifiMac = WifiMac;
m.KayitDurum = "Active";
m.WindowsCdKey = WindowsCdkey;
data.TB_Notebooks.Add(m);
data.SaveChanges();
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
public ReturnDto VınnAdd(string Users, string Operator, string IMEI, string SerialNumber, string DeviceName, string SımCardNo, string PIN1, string PIN2, string PUK1, string PUK2, string Special, string Status, DateTime PurchaseDate, string Olduser)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var t = data.TB_VINN.Where(p => p.SerialNumber == SerialNumber).Select(p => p.SerialNumber).FirstOrDefault();
if (SerialNumber == t)
{
return(new ReturnDto(false, ReturnDto.SerialError));
}
else
{
string kod;
int max_id = data.TB_VINN.Max(p => p.ID);
kod = "Mt-" + max_id;
TB_VINN m = new TB_VINN();
m.UserCode = kod;
m.Users = Users;
m.Operator = Operator;
m.SerialNumber = SerialNumber;
m.IMEI = IMEI;
m.DeviceName = DeviceName;
m.SımCardNo = SımCardNo;
m.PIN1 = PIN1;
m.PIN2 = PIN2;
m.PUK1 = PUK1;
m.PUK2 = PUK2;
m.Special = Special;
m.Status = Status;
m.PurchaseDate = PurchaseDate;
m.OldUser = Olduser;
m.KayitDurum = "Active";
data.TB_VINN.Add(m);
data.SaveChanges();
}
return(new ReturnDto(true, ReturnDto.Success));
}
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
public ReturnDto OthersAdd(string Users, string Brand, string SerialNumber, string Features, string Location, string Specification, DateTime PurchaseDate, string InvoiceNumber, string OldUser)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var t = data.TB_Others.Where(p => p.SerialNumber == SerialNumber).Select(p => p.SerialNumber).FirstOrDefault();
if (SerialNumber == t)
{
return(new ReturnDto(false, ReturnDto.SerialError));
}
else
{
string kod;
int max_id = data.TB_Others.Max(p => p.ID);
kod = "Mt-" + max_id;
TB_Others m = new TB_Others();
m.UserCode = kod;
m.Users = Users;
m.Brand = Brand;
m.SerialNumber = SerialNumber;
m.Users = Users;
m.Features = Features;
m.Location = Location;
m.Specification = Specification;
m.PurchaseDate = PurchaseDate;
m.InvoiceNumber = InvoiceNumber;
m.OldUser = OldUser;
m.KayitDurum = "Active";
m.PurchaseDate = PurchaseDate;
data.TB_Others.Add(m);
data.SaveChanges();
}
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
public ReturnDto mobileAdd(string Demirbas, string Name, string Phone, string Number, string SerialNumber, string IMEI, string MAC, DateTime PurchaseDate, string InvInvoiceNumber, string Olduser)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var t = data.TB_Mobile.Where(p => p.SerialNumber == SerialNumber).Select(p => p.SerialNumber).FirstOrDefault();
if (SerialNumber == t)
{
return(new ReturnDto(false, ReturnDto.SerialError));
}
else
{
string kod;
int max_id = data.TB_Mobile.Max(p => p.ID);
kod = "M-" + max_id;
TB_Mobile m = new TB_Mobile();
m.UserCode = kod;
m.Demirbas = Demirbas;
m.Name = Name;
m.Phone = Phone;
m.Number = Number;
m.SerialNumber = SerialNumber;
m.IMEI = IMEI;
m.MAC = MAC;
m.PurchaseDate = PurchaseDate;
m.InvoiceNumber = InvInvoiceNumber;
m.OldUser = Olduser;
m.KayitDurumu = "Active";
data.TB_Mobile.Add(m);
data.SaveChanges();
}
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
public ReturnDto ServersDelete(string ServerCode)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var m = data.TB_Servers.Where(p => p.ServerCode == ServerCode).FirstOrDefault();
m.KayitDurum = "Inactive";
data.SaveChanges();
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
public ReturnDto PrintersAdd(string Brand, string IP, string BasicFeatures, string SerialNumber, string NetworkName, string Location, string InventoryNumber, string InvoiceContract, string Status, DateTime PurchaseDate)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var t = data.TB_Printers.Where(p => p.SerialNumber == SerialNumber).Select(p => p.SerialNumber).FirstOrDefault();
if (SerialNumber == t)
{
return(new ReturnDto(false, ReturnDto.SerialError));
}
else
{
string kod;
int max_id = data.TB_Printers.Max(p => p.ID);
kod = "Ma-" + max_id;
TB_Printers m = new TB_Printers();
m.UserCode = kod;
m.Brand = Brand;
m.IP = IP;
m.SerialNumber = SerialNumber;
m.BasicFeatures = BasicFeatures;
m.NetworkName = NetworkName;
m.Location = Location;
m.InventoryNumber = InventoryNumber;
m.InvoiceContract = InvoiceContract;
m.Status = Status;
m.PurchaseDate = PurchaseDate;
m.KayitDurum = "Active";
data.TB_Printers.Add(m);
data.SaveChanges();
}
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
/// <summary>
/// UPDATE Department method
/// </summary>
/// <param name="depart"></param>
/// <returns>
/// bool value of method's execution
/// </returns>
public static bool Update(Depart depart)
{
using (EquipmentsEntities context = new EquipmentsEntities())
{
try
{
int id = Convert.ToInt32(depart.Id);
var dep = context.Depts.SingleOrDefault(d => d.Id == id);
dep.DeptName = depart.Name;
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
/// <summary>
/// DELETE Equipment method
/// </summary>
/// <param name="equipment"></param>
/// <returns>
/// bool value of method's execution
/// </returns>
public static bool Remove(Equipment equipment)
{
using (EquipmentsEntities context = new EquipmentsEntities())
{
try
{
int id = Convert.ToInt32(equipment.Id);
EquipEntity equip = context.Equip.Single(e => e.Id == id);
context.Equip.Remove(equip);
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
/// <summary>
/// CREATE Manufacturer method
/// </summary>
/// <param name="manufact"></param>
/// <returns>
/// bool value of method's execution
/// </returns>
public static bool Create(Manufact manufact)
{
using (EquipmentsEntities context = new EquipmentsEntities())
{
try
{
ManufactureEntity newE = new ManufactureEntity();
newE.ManufName = manufact.Name;
context.Manufactures.Add(newE);
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
/// <summary>
/// UPDATE Manufacturer method
/// </summary>
/// <param name="manufact"></param>
/// <returns>
/// bool value of metho's execution
/// </returns>
public static bool Update(Manufact manufact)
{
using (EquipmentsEntities context = new EquipmentsEntities())
{
try
{
int id = Convert.ToInt32(manufact.Id);
var man = context.Manufactures.SingleOrDefault(m => m.Id == id);
man.ManufName = manufact.Name;
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
/// <summary>
/// CREATE Department method
/// </summary>
/// <param name="depart"></param>
/// <returns>
/// bool value of method's execution
/// </returns>
public static bool Create(Depart depart)
{
using (EquipmentsEntities context = new EquipmentsEntities())
{
try
{
DeptEntity newE = new DeptEntity();
newE.DeptName = depart.Name;
context.Depts.Add(newE);
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public ReturnDto SoftwareUpdate(string SoftwareCode, string Name, string Status, DateTime PurchaseDate)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var m = data.TB_Software.Where(p => p.UserCode == SoftwareCode).FirstOrDefault();
m.Name = Name;
m.PurchaseDate = PurchaseDate;
m.Status = Status;
data.SaveChanges();
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
public ReturnDto ServersUpdate(string ServersCode, string ServerName, string Location, string SerialNumber)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var m = data.TB_Servers.Where(p => p.ServerCode == ServersCode).FirstOrDefault();
m.Location = Location;
m.SerialNumber = SerialNumber;
m.ServerCode = ServersCode;
m.ServerName = ServerName;
data.SaveChanges();
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
public ReturnDto ServersAdd(string ServerName, string Location, string SerialNumber)
{
try
{
using (EquipmentsEntities data = new EquipmentsEntities())
{
var t = data.TB_Servers.Where(p => p.SerialNumber == SerialNumber).Select(p => p.SerialNumber).FirstOrDefault();
if (SerialNumber == t)
{
return(new ReturnDto(false, ReturnDto.SerialError));
}
else
{
string kod;
int max_id = data.TB_Servers.Max(p => p.ID);
kod = "Ms-" + max_id;
TB_Servers m = new TB_Servers();
m.ServerCode = kod;
m.ServerName = ServerName;
m.SerialNumber = SerialNumber;
m.Location = Location;
m.KayitDurum = "Active";
data.TB_Servers.Add(m);
data.SaveChanges();
}
}
return(new ReturnDto(true, ReturnDto.Success));
}
catch (Exception)
{
return(new ReturnDto(false, ReturnDto.Failed));
}
}
