public ActionResult Register(RegisterModel model)
{
if (!ModelState.IsValid)
{
return View();
}
string username = model.Username;
string password = model.Password;
string name = model.Name;
string email = model.Email;
DateTime date = DateTime.Now;
string userType = "DF";
string errormsg = null;
UserInfoTableAdapter UserInfoAdapter = new UserInfoTableAdapter();
DataTable UserInfoDT = UserInfoAdapter.GetDataByUsername(username);
if (UserInfoDT.Rows.Count == 1)
{
errormsg += "Tên đăng nhập ";
}
if (!string.IsNullOrEmpty(email))
{
AccountTableAdapter AccountAdapter = new AccountTableAdapter();
DataTable AccountDT = AccountAdapter.GetDataByEmail(email);
if (AccountDT.Rows.Count == 1)
{
if (errormsg != null)
{
errormsg += ", Email ";
}
else errormsg += "Email ";
}
}
if (errormsg != null)
{
errormsg += "đã tồn tại!";
ModelState.AddModelError("", errormsg);
return View(model);
}
else
{
AccountTableAdapter AccountAdapter = new AccountTableAdapter();
UserInfoAdapter.Connection.Open();
AccountAdapter.Connection = UserInfoAdapter.Connection;
using (SqlTransaction transaction = UserInfoAdapter.Connection.BeginTransaction())
{
UserInfoAdapter.AttachTransaction(transaction);
AccountAdapter.AttachTransaction(transaction);
try
{
UserInfoAdapter.InsertUserInfo(username, name, userType, 0, date, null, null, null, false, false, date, username, date);
Log.ActivityLog("Insert into UserInfo: Username = "******"Insert into Account: Username = "******"register"] = "Đăng ký thành công!";
}
catch (Exception ex)
{
transaction.Rollback();
Log.ErrorLog(ex.Message);
Session["register"] = "Đăng ký thất bại!";
}
}
}
return RedirectToAction("HomePage", "Home");
}
private static void sync(string xmlFilePath, string ignoreSyncID)
{
XDocument xDoc;
XElement newDataSetEl;
DateTime lastSync;
xDoc = XDocument.Load(xmlFilePath);
newDataSetEl = xDoc.Element("NewDataSet");
lastSync = GetLastUpdatedClient(ignoreSyncID);
UserInfoTableAdapter userInfoTA = new UserInfoTableAdapter();
TransactionHistoryTableAdapter transactionHistoryTA = new TransactionHistoryTableAdapter();
userInfoTA.Connection.Open();
transactionHistoryTA.Connection = userInfoTA.Connection;
using (SqlTransaction transaction = userInfoTA.Connection.BeginTransaction())
{
userInfoTA.AttachTransaction(transaction);
transactionHistoryTA.AttachTransaction(transaction);
try
{
IList<XElement> ElList = newDataSetEl.Descendants("UserInfo").ToList();
foreach (XElement userInfoEl in ElList)
{
// not null value parse
string username = userInfoEl.Element("Username").Value;
// nullable value parse
byte[] fingerPrintIMG;
if (userInfoEl.Element("FingerPrintIMG") == null)
{
fingerPrintIMG = null;
}
else
{
fingerPrintIMG = Convert.FromBase64String(userInfoEl.Element("FingerPrintIMG").Value);
}
DateTime? lastUpdatedFingerPrint;
if (userInfoEl.Element("LastUpdatedFingerPrint") == null)
{
lastUpdatedFingerPrint = null;
}
else
{
lastUpdatedFingerPrint = DateTime.Parse(userInfoEl.Element("LastUpdatedFingerPrint").Value);
}
int? fingerPosition;
if (userInfoEl.Element("FingerPosition") == null)
{
fingerPosition = null;
}
else
{
fingerPosition = int.Parse(userInfoEl.Element("FingerPosition").Value);
}
DataTable userInfoDT = new UserInfoTableAdapter().GetDataByUsername(username);
if (userInfoDT.Rows.Count != 1)
{
throw new Exception("Comflic while Sync. The updated row doesn't exist.");
}
DataRow userInfoRow = userInfoDT.Rows[0];
DateTime? oriLastUpdateFingerPrint = userInfoRow.Field<DateTime?>("LastUpdatedFingerPrint");
if (oriLastUpdateFingerPrint == null || (lastUpdatedFingerPrint != null
&& lastUpdatedFingerPrint > oriLastUpdateFingerPrint))
{
//userInfoTA.Update(userInfoRow.Field<string>("Name"), userInfoRow.Field<string>("TypeShortName")
// , userInfoRow.Field<int>("AmountOfMoney"), userInfoRow.Field<DateTime>("LastUpdatedMoney"), fingerPrintIMG
// , lastUpdatedFingerPrint, fingerPosition, userInfoRow.Field<bool>("IsCafeteriaStaff")
// , userInfoRow.Field<bool>("IsActive"), userInfoRow.Field<DateTime>("InsertedDate"), userInfoRow.Field<string>("UpdatedBy")
// , userInfoRow.Field<DateTime>("LastUpdated"), username);
userInfoTA.Update(userInfoRow.Field<string>("Name"), userInfoRow.Field<string>("TypeShortName")
, userInfoRow.Field<int>("AmountOfMoney"), userInfoRow.Field<DateTime>("LastUpdatedMoney"), fingerPrintIMG
, lastUpdatedFingerPrint, fingerPosition, userInfoRow.Field<bool>("IsCafeteriaStaff")
, true, userInfoRow.Field<DateTime>("InsertedDate"), userInfoRow.Field<string>("UpdatedBy")
, userInfoRow.Field<DateTime>("LastUpdated"), username);
//SaveUserInfoXml(userInfoRow.Field<string>("Username"), userInfoRow.Field<string>("Name"), userInfoRow.Field<string>("TypeShortName")
// , userInfoRow.Field<int>("AmountOfMoney"), userInfoRow.Field<DateTime>("LastUpdatedMoney"), fingerPrintIMG
// , lastUpdatedFingerPrint, fingerPosition, userInfoRow.Field<bool>("IsCafeteriaStaff")
// , userInfoRow.Field<bool>("IsActive"), userInfoRow.Field<DateTime>("InsertedDate"), userInfoRow.Field<string>("UpdatedBy")
// , userInfoRow.Field<DateTime>("LastUpdated"), ignoreSyncID);
SaveUserInfoXml(userInfoRow.Field<string>("Username"), userInfoRow.Field<string>("Name"), userInfoRow.Field<string>("TypeShortName")
, userInfoRow.Field<int>("AmountOfMoney"), userInfoRow.Field<DateTime>("LastUpdatedMoney"), fingerPrintIMG
, lastUpdatedFingerPrint, fingerPosition, userInfoRow.Field<bool>("IsCafeteriaStaff")
, true, userInfoRow.Field<DateTime>("InsertedDate"), userInfoRow.Field<string>("UpdatedBy")
, userInfoRow.Field<DateTime>("LastUpdated"), ignoreSyncID);
}
}
ElList = newDataSetEl.Descendants("TransactionHistory").ToList();
foreach (XElement transactionHistoryEl in ElList)
{
// not null value parse
int transactionHistoryID = int.Parse(transactionHistoryEl.Element("TransactionHistoryID").Value);
string username = transactionHistoryEl.Element("Username").Value;
int transactionTypeID = int.Parse(transactionHistoryEl.Element("TransactionTypeID").Value);
int value = int.Parse(transactionHistoryEl.Element("Value").Value);
string transactionContent = transactionHistoryEl.Element("TransactionContent").Value;
bool isAuto = bool.Parse(transactionHistoryEl.Element("IsAuto").Value);
DateTime insertedDate = DateTime.Parse(transactionHistoryEl.Element("InsertedDate").Value);
DateTime lastUpdated = DateTime.Parse(transactionHistoryEl.Element("LastUpdated").Value);
// nullable value parse
int? scheduleMealSetDetailID;
if (transactionHistoryEl.Element("ScheduleMealSetDetailID") == null)
{
scheduleMealSetDetailID = null;
}
else
{
scheduleMealSetDetailID = int.Parse(transactionHistoryEl.Element("ScheduleMealSetDetailID").Value);
}
string updatedBy = transactionHistoryEl.TryGetElementValue("UpdatedBy");
if (insertedDate > lastSync)
{
if (scheduleMealSetDetailID != null)
{
int? check = new ScheduleMealSetDetailTableAdapter().CheckID(scheduleMealSetDetailID.Value);
if (check == null)
{
scheduleMealSetDetailID = null;
}
}
transactionHistoryTA.Insert(username, transactionTypeID, value, transactionContent, scheduleMealSetDetailID,
isAuto, insertedDate, updatedBy, lastUpdated);
SaveTransactionHistoryXml(transactionHistoryID, username, transactionTypeID, value, transactionContent
, scheduleMealSetDetailID, isAuto, insertedDate, updatedBy, lastUpdated, ignoreSyncID);
}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
public ActionResult EditUser(EditUserModel model)
{
UserTypeTableAdapter userTypeAdapter = new UserTypeTableAdapter();
DataTable userTypeDT = userTypeAdapter.GetData();
List<SelectListItem> items = new List<SelectListItem>();
foreach (DataRow row in userTypeDT.Rows)
{
items.Add(new SelectListItem { Text = row["TypeName"].ToString(), Value = row["TypeShortName"].ToString() });
}
ViewData["UserType"] = items;
if (!ModelState.IsValid)
{
return View(model);
}
string email = model.Email;
if (!string.IsNullOrEmpty(email))
{
AccountTableAdapter AccountAdapter = new AccountTableAdapter();
DataTable dt = AccountAdapter.GetDataByUsername(model.Username);
if (!dt.Rows[0]["Email"].ToString().Equals(email))
{
DataTable AccountDT = AccountAdapter.GetDataByEmail(email);
if (AccountDT.Rows.Count == 1)
{
if (!AccountDT.Rows[0]["Username"].ToString().Equals(model.Username))
{
Log.ActivityLog(AccountDT.Rows[0]["Username"].ToString().Equals(model.Username).ToString());
ModelState.AddModelError("", "Email đã tồn tại");
return View(model);
}
}
}
}
string updateBy = AccountInfo.GetUserName(Request);
DateTime date = DateTime.Now;
string username = model.Username;
string name = model.Name;
string userTypeID = model.UserTypeID;
bool isCafeteriaStaff = false;
int role = model.Role;
bool isActive = model.isActive;
if (role == 2)
{
isCafeteriaStaff = true;
}
AccountTableAdapter accountAdapter = new AccountTableAdapter();
UserInfoTableAdapter userInfoAdapter = new UserInfoTableAdapter();
DataTable userInfoDT = userInfoAdapter.GetDataByUsername(username);
DataRow userInfoRow = userInfoDT.Rows[0];
int amountOfMoney = userInfoRow.Field<int>("AmountOfMoney");
DateTime lastUpdatedMoney = userInfoRow.Field<DateTime>("LastUpdatedMoney");
byte[] fingerPrintIMG = userInfoRow.Field<byte[]>("FingerPrintIMG");
DateTime? lastUpdatedFingerPrint = userInfoRow.Field<DateTime?>("LastUpdatedFingerPrint");
int? fingerPosition = userInfoRow.Field<int?>("FingerPosition");
DateTime insertedDate = userInfoRow.Field<DateTime>("InsertedDate");
accountAdapter.Connection.Open();
userInfoAdapter.Connection = accountAdapter.Connection;
using (SqlTransaction transaction = accountAdapter.Connection.BeginTransaction())
{
accountAdapter.AttachTransaction(transaction);
userInfoAdapter.AttachTransaction(transaction);
try
{
userInfoAdapter.UpdateUserInfo(username, name, userTypeID, amountOfMoney, lastUpdatedMoney, fingerPrintIMG
, lastUpdatedFingerPrint, fingerPosition, isCafeteriaStaff, isActive, insertedDate, updateBy, date, username);
Log.ActivityLog("Update to UserInfo: username = "******"Update to Account: username = "******"editUser"] = "******";
}
catch (Exception ex)
{
transaction.Rollback();
Log.ErrorLog(ex.Message);
Session["editUser"] = "******";
}
}
return RedirectToAction("EditUser", "Account", new { @username = model.Username });
}