public void Delete(modelClient client, bool reload = true) { db.Delete("tblClient", "ID", client); if (reload) { LoadClients(); } }
public void Update(modelClient client, bool reload = true) { if (client.CreatedDate.Year < 2000) { client.CreatedDate = new DateTime(2000, 1, 1); } client.UpdatedDate = DateTime.Now; db.Update("tblClient", "ID", client); if (reload) { LoadClients(); } }
public void Insert(modelClient client, bool reload = true) { if (client.ID == 0) { client.ID = Program.GData.LongID(); client.CreatedDate = DateTime.Now; client.UpdatedDate = DateTime.Now; } db.Insert("tblClient", "ID", false, client); if (reload) { LoadClients(); } }
public void InitData() { dataLOV = new domainListOfValues(); dataLOV.LoadData(); dataPerson = new domainPerson(); dataPerson.LoadData(); dataOrganization = new domainOrganization(); dataOrganization.LoadData(); dataProject = new domainProject(); dataProject.LoadData(); dataActivity = new domainActivity(); dataActivity.LoadData(); string computerName = SystemInformation.ComputerName; var client = dataLOV.getClients.FirstOrDefault(c => c.ComputerName.ToUpper() == computerName.ToUpper()); if (client != null) { CFGStationID = client.ComputerID; } else { CFGStationID = dataLOV.getClients.Max(c => c.ComputerID) + 1; var clnt = new modelClient(computerName, CFGStationID); dataLOV.Insert(clnt); } projectCalls = new List <modelProjectCall>(); projectCalls.Add(new modelProjectCall("2017-1", new DateTime(2017, 5, 1))); projectCalls.Add(new modelProjectCall("2017-2", new DateTime(2017, 8, 1))); projectCalls.Add(new modelProjectCall("2017-3", new DateTime(2018, 1, 1))); projectCalls.Add(new modelProjectCall("2018-1", new DateTime(2018, 5, 1))); projectCalls.Add(new modelProjectCall("2018-2", new DateTime(2018, 8, 1))); projectCalls.Add(new modelProjectCall("2018-3", new DateTime(2019, 1, 1))); projectCalls.Add(new modelProjectCall("2019-1", new DateTime(2019, 5, 1))); projectCalls.Add(new modelProjectCall("2019-2", new DateTime(2019, 8, 1))); }