public bool add(string address) { Places place = new Serwis.Places { address = address }; pe.Places.Add(place); try { pe.SaveChanges(); return(true); } catch { return(false); } }
/* * int column * 1 - name * 2 - city * 3 - street * 4 - houseNo * 5 - locumNo * 6 - phone * 7 - mail * 8 - nip */ public bool edit(int column, int id, string value) { try { using (ProjektEntities pe = new ProjektEntities()) { var firm = pe.Firms.Find(id); switch (column) { case 1: firm.name = value; break; case 2: firm.city = value; break; case 3: firm.street = value; break; case 4: firm.house_no = value; break; case 5: firm.locum_no = value; break; case 6: firm.phone = value; break; case 7: firm.mail = value; break; case 8: firm.nip = value; break; } pe.SaveChanges(); } return(true); } catch { return(false); } }
/* * int column * 1 - name * 2 - surname * 3 - city * 4 - street * 5 - houseNo * 6 - locumNo * 7 - phone * 8 - mail */ public bool edit(int column, int id, string value) { try { using (ProjektEntities pe = new ProjektEntities()) { var client = pe.Clients.Find(id); switch (column) { case 1: client.name = value; break; case 2: client.surname = value; break; case 3: client.city = value; break; case 4: client.street = value; break; case 5: client.house_no = value; break; case 6: client.locum_no = value; break; case 7: client.phone = value; break; case 8: client.mail = value; break; } pe.SaveChanges(); } return(true); } catch { return(false); } }
public bool add(bool firm, string model, string manufacturer, string serialNo, int deviceType, int statusId, int clientId) { // TODO: Add statuses try { if (firm == true) { device = new DevicesCards { manufacturer = manufacturer, model = model, serial_no = serialNo, type_id = deviceType, status_id = statusId, firm_id = clientId, created_at = DateTime.Now, updated_at = DateTime.Now }; } else { device = new DevicesCards { manufacturer = manufacturer, model = model, serial_no = serialNo, type_id = deviceType, status_id = statusId, client_id = clientId, created_at = DateTime.Now, updated_at = DateTime.Now }; } using (ProjektEntities pe = new ProjektEntities()) { pe.DevicesCards.Add(device); pe.SaveChanges(); } return(true); } catch { return(false); } }
public bool add(string username, string password, int access_level, string place) { int placeId = pe.Places.FirstOrDefault(p => p.address == place).id; Users user = new Users { name = username, password = generateSha1(password), access_level = Convert.ToByte(access_level), place_id = placeId, created_at = DateTime.Now, updated_at = DateTime.Now }; pe.Users.Add(user); try { pe.SaveChanges(); } catch { return(false); } return(true); }
public bool delete(int id) { try { using (ProjektEntities pe = new ProjektEntities()) { var firm = pe.Firms.Find(id); pe.Firms.Remove(firm); pe.SaveChanges(); } return(true); } catch { return(false); } }
public bool delete(int id) { try { using (ProjektEntities pe = new ProjektEntities()) { var deviceType = pe.DeviceTypes.Find(id); pe.DeviceTypes.Remove(deviceType); pe.SaveChanges(); } return(true); } catch { return(false); } }
public bool edit(int id, string type) { try { using (ProjektEntities pe = new ProjektEntities()) { var deviceType = pe.DeviceTypes.Find(id); deviceType.type = type; pe.SaveChanges(); } return(true); } catch { return(false); } }
public bool delete(int id) { try { using (ProjektEntities pe = new ProjektEntities()) { var client = pe.Clients.Find(id); pe.Clients.Remove(client); pe.SaveChanges(); } return(true); } catch { return(false); } }
public bool delete(int id) { try { using (ProjektEntities pe = new ProjektEntities()) { var status = pe.Statuses.Find(id); pe.Statuses.Remove(status); pe.SaveChanges(); } return(true); } catch { return(false); } }
public bool edit(int id, string statusName) { try { using (ProjektEntities pe = new ProjektEntities()) { var status = pe.Statuses.Find(id); status.name = statusName; pe.SaveChanges(); } return(true); } catch { return(false); } }
public bool diagnosis(int id, string diag) { try { using (ProjektEntities pe = new ProjektEntities()) { var drc = pe.DeviceRepairCards.Find(id); drc.diagnosis = diag; drc.updated_at = DateTime.Now; pe.SaveChanges(); } return(true); } catch { return(false); } }
public bool makeRepaired(int id) { try { using (ProjektEntities pe = new ProjektEntities()) { var drc = pe.DeviceRepairCards.Find(id); drc.repaired = true; drc.updated_at = DateTime.Now; pe.SaveChanges(); } return(true); } catch { return(false); } }
public bool add(int id, string damageDesc) { User user = new User(); try { using (ProjektEntities pe = new ProjektEntities()) { var repairCard = new DeviceRepairCards { damage_desc = damageDesc, repaired = false, created_at = DateTime.Now, updated_at = DateTime.Now, device_id = id, place_id = user.from(user.getCurrentUserId()) }; pe.DeviceRepairCards.Add(repairCard); pe.SaveChanges(); } return(true); } catch { return(false); } }
public bool add(string statusName) { try { var status = new Statuses { name = statusName }; using (ProjektEntities pe = new ProjektEntities()) { pe.Statuses.Add(status); pe.SaveChanges(); } return(true); } catch { return(false); } }
public bool add(string type) { try { using (ProjektEntities pe = new ProjektEntities()) { DeviceTypes deviceType = new DeviceTypes { type = type }; pe.DeviceTypes.Add(deviceType); pe.SaveChanges(); } return(true); } catch { return(false); } }
public bool statusChange(int id, int status) { try { using (ProjektEntities pe = new ProjektEntities()) { var dc = pe.DevicesCards.Find(id); dc.status_id = status; dc.updated_at = DateTime.Now; pe.SaveChanges(); } return(true); } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); //System.Windows.Forms.MessageBox.Show(ex.InnerException.ToString()); return(false); } }
override public bool addClient(string name, string surname, string city, string street, string houseNo, string locumNo, string phoneNo, string mail) { try { using (ProjektEntities pe = new ProjektEntities()) { Clients client = new Clients { name = name, surname = surname, city = city, street = street, house_no = houseNo, locum_no = locumNo, phone = phoneNo, mail = mail, created_at = DateTime.Now, updated_at = DateTime.Now }; pe.Clients.Add(client); pe.SaveChanges(); return(true); } } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.InnerException.ToString()); return(false); } }