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();
}