private void SavePatientAddressData(object parameter) { DataLayer.DB_SERVER db = new DataLayer.DB_SERVER(); var patientAddressInDB = db.Address.FirstOrDefault(e => e.PatientId == PatientId); if (patientAddressInDB != null) { patientAddressInDB.Address1 = Address1; patientAddressInDB.Address2 = Address2; patientAddressInDB.PostalCode = PostalCode; patientAddressInDB.City = City; db.SaveChanges(); } else { db.Address.Add(new tAddress { PatientId = PatientId, Address1 = Address1, Address2 = Address2, PostalCode = PostalCode, City = City }); db.SaveChanges(); } var commandParameter = Convert.ToInt16(parameter); if (commandParameter != null && commandParameter != 0) //save and previous tab { if (SaveAndNextTabAction != null) { SaveAndNextTabAction.Invoke(); } } }
private void Login() { LoginError = ""; LoginSucceed = false; DataLayer.DB_SERVER db = new DataLayer.DB_SERVER(); #region Database and standing data creation if (!db.Database.Exists()) { string _populationStandingData = "IF NOT EXISTS(SELECT *FROM tUser)" + "BEGIN" + " Insert into tUser (UserId,Password) VALUES('sa','123')" + " END" + " IF NOT EXISTS(SELECT * FROM tDoctor)" + " BEGIN" + " INSERT INTO tDoctor (FirstName,LastName)VALUES ('Daud','Ratul')" + " INSERT INTO tDoctor (FirstName,LastName)VALUES ('Shahinur','Kabir')" + " END"; db.Database.CreateIfNotExists(); db.Database.ExecuteSqlCommand(_populationStandingData); } #endregion var user = db.User.FirstOrDefault(e => e.UserId == UserName); if (user == null) { LoginError = "Invalid Login User ID"; return; } else if (user.Password != Password) { LoginError = "Invalid Login User Password"; return; } LoginSucceed = true; if (LoginEvent != null) { LoginEvent.Invoke(); } }
private void Login() { LoginError = ""; LoginSucceed = false; DataLayer.DB_SERVER db = new DataLayer.DB_SERVER(); #region Database and standing data creation if (!db.Database.Exists()) { string _populationStandingData="IF NOT EXISTS(SELECT *FROM tUser)" +"BEGIN" +" Insert into tUser (UserId,Password) VALUES('sa','123')" +" END" +" IF NOT EXISTS(SELECT * FROM tDoctor)" +" BEGIN" +" INSERT INTO tDoctor (FirstName,LastName)VALUES ('Daud','Ratul')" +" INSERT INTO tDoctor (FirstName,LastName)VALUES ('Shahinur','Kabir')" +" END"; db.Database.CreateIfNotExists(); db.Database.ExecuteSqlCommand(_populationStandingData); } #endregion var user=db.User.FirstOrDefault(e => e.UserId==UserName); if (user == null) { LoginError = "Invalid Login User ID"; return; } else if (user.Password != Password) { LoginError = "Invalid Login User Password"; return; } LoginSucceed = true; if (LoginEvent != null) LoginEvent.Invoke(); }
private void SavePatientAddressData(object parameter) { DataLayer.DB_SERVER db = new DataLayer.DB_SERVER(); var patientAddressInDB = db.Address.FirstOrDefault(e => e.PatientId == PatientId); if (patientAddressInDB != null) { patientAddressInDB.Address1 = Address1; patientAddressInDB.Address2 = Address2; patientAddressInDB.PostalCode = PostalCode; patientAddressInDB.City = City; db.SaveChanges(); } else { db.Address.Add(new tAddress { PatientId = PatientId, Address1 = Address1, Address2 = Address2, PostalCode = PostalCode, City = City }); db.SaveChanges(); } var commandParameter = Convert.ToInt16(parameter); if (commandParameter != null && commandParameter != 0) //save and previous tab if (SaveAndNextTabAction != null) SaveAndNextTabAction.Invoke(); }