public bool SignIn(string sFirstName, string sLastName, string sEmail, string sPassword, out string sErrMessage)
{
try
{
sErrMessage = "";
dbConection = new SoftBottinBD.SoftBottinDataClassesDataContext();
SoftBottinBD.User niUser = new SoftBottinBD.User
{
FirstName = sFirstName,
LastName = sLastName,
Email = sEmail
};
dbConection.Users.InsertOnSubmit(niUser);
dbConection.SubmitChanges();
SoftBottinBD.UserAccount niUserAccount = new SoftBottinBD.UserAccount
{
UserName = sEmail,
Password = sPassword,
UserId = niUser.Id,
RoleId = 2
};
dbConection.UserAccounts.InsertOnSubmit(niUserAccount);
dbConection.SubmitChanges();
return(true);
}
catch (Exception ex)
{
cUtilities.WriteLog(ex.Message, out sErrMsj);
sErrMessage = ex.Message;
return(false);
}
}
public bool LogIn(string sUserName, string sPassword, out DataSet dsUser, out string sErrMessage)
{
try
{
dbConection = new SoftBottinBD.SoftBottinDataClassesDataContext();
SoftBottinBD.UserAccount niUserAccount = new SoftBottinBD.UserAccount
{
UserName = sUserName,
Password = sPassword
};
var userSigIn = from user in dbConection.UserAccounts
where user.UserName.Equals(niUserAccount.UserName) &&
user.Password.Equals(niUserAccount.Password)
select user;
if (userSigIn.ToList().Count > 0)
{
dsUser = cUtilities.ToDataSet(userSigIn.ToList());
sErrMessage = "";
return(true);
}
else
{
dsUser = new DataSet();
sErrMessage = "Not Found";
return(false);
}
}
catch (Exception ex)
{
dsUser = new DataSet();
cUtilities.WriteLog(ex.Message, out sErrMsj);
sErrMessage = ex.Message;
return(false);
}
}
