/// <summary>
/// Saves the ID number.
/// </summary>
/// <param name="_listIDNumber">The _list ID number.</param>
/// <returns></returns>
public ONSResult SaveIDNumber(List <IDNumber> _listIDNumber)
{
ONSResult _ONSResultSave = new ONSResult();
try
{
using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, DBHelper.TransactionOptions))
{
foreach (IDNumber item in _listIDNumber)
{
if (item.SlNo == 0)
{
_ONSResultSave = ApplicationState.DAClient.InsertIDNumber(item);
}
else
{
_ONSResultSave = ApplicationState.DAClient.UpdateIDNumber(item);
}
}
transaction.Complete();
}
}
catch (Exception ex)
{
ErrorHandler _ErrorHandler = new ErrorHandler();
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResultSave);
}
public ONSResult SaveUserEntryExit(List <UserEntryExit> _listUserEntryExit)
{
ONSResult _ONSResultSave = new ONSResult();
try
{
using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, DBHelper.TransactionOptions))
{
foreach (UserEntryExit item in _listUserEntryExit)
{
if (item.UserEntryExitID == string.Empty)
{
_ONSResultSave = ApplicationState.DAClient.InsertUserEntryExit(item);
}
else
{
_ONSResultSave = ApplicationState.DAClient.UpdateUserEntryExit(item);
}
}
transaction.Complete();
}
}
catch (Exception ex)
{
ErrorHandler _ErrorHandler = new ErrorHandler();
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResultSave);
}
private void btnLogIn_Click(object sender, RoutedEventArgs e)
{
User _User = new User();
_User.UserName = txtUserName.Text;
_User.Password = txtPassword.Password;
if (cboCompany.SelectedValue != null)
{
_User.CompanyId = cboCompany.SelectedValue.ToString();
}
if (cboLocation.SelectedValue != null)
{
_User.LocationId = cboLocation.SelectedValue.ToString();
}
if (!IsValidControlAccount(_User))
{
return;
}
ONSResult _ONSResult = new ONSResult();
_ONSResult = _Setup_BLogic_BLL.CheckUserForLogIn(_User);
MessageBox.Show(_ONSResult.Message, "Save", MessageBoxButton.OK, MessageBoxImage.Warning);
if (_ONSResult.IsSuccess == true)
{
MainAccounts _MainAccounts = new MainAccounts();
_MainAccounts.Show();
this.Close();
}
}
/// <summary>
/// Saves the control accounts.
/// </summary>
/// <param name="_listControlAccount">The _list control account.</param>
/// <returns></returns>
public ONSResult SaveControlAccounts(List <ControlAccount> _listControlAccount)
{
ONSResult _ONSResultSave = new ONSResult();
try
{
using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, DBHelper.TransactionOptions))
{
foreach (ControlAccount item in _listControlAccount)
{
if (String.IsNullOrEmpty(item.ControlId))
{
item.ControlId = _CommonMethods.RandomString(3);
_ONSResultSave = ApplicationState.DAClient.InsertControlAccount(item);
}
else
{
_ONSResultSave = ApplicationState.DAClient.UpdateControlAccount(item);
}
}
transaction.Complete();
}
}
catch (Exception ex)
{
ErrorHandler _ErrorHandler = new ErrorHandler();
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResultSave);
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
List <ControlAccount> _listControlAccount = new List <ControlAccount>();
foreach (var _item in dgControlAccount.Items)
{
ControlAccount item = _item as ControlAccount;
if (item != null && item.IsSelected == true)
{
if (!IsValidControlAccount(item))
{
return;
}
item.CompanyId = SharedState.CompanyId;
item.EntryBy = SharedState.UserId;
item.DateOfEntry = DateTime.Now.Date;
_listControlAccount.Add(item);
}
}
if (_listControlAccount.Count > 0)
{
ONSResult _ONSResult = _Setup_Save_BLL.SaveControlAccounts(_listControlAccount);
MessageBox.Show(_ONSResult.Message, "Save", MessageBoxButton.OK, MessageBoxImage.Warning);
LoadControlAccount();
}
}
public ONSResult DeleteAccount(Account parameter)
{
ONSResult _ONSResultInsert = new ONSResult();
try
{
List <Account> list = new List <Account>();
var query = from a in _dataContext.Accounts
where a.AccountsId == parameter.AccountsId
select a;
list = query.ToList <Account>();
if (list.Count == 1)
{
_dataContext.Accounts.DeleteOnSubmit(list[0]);
_dataContext.SubmitChanges();
_ONSResultInsert.IsSuccess = true;
_ONSResultInsert.Message = "Account deleted successfully.";
}
else
{
_ONSResultInsert.IsSuccess = false;
_ONSResultInsert.Message = "Account not found with this id.";
}
}
catch (Exception ex)
{
_ONSResultInsert.IsSuccess = false;
_ONSResultInsert.Message = ex.Message;
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResultInsert);
}
public ONSResult UpdateControlAccount(ControlAccount parameter)
{
ONSResult _ONSResultInsert = new ONSResult();
try
{
List <ControlAccount> list = new List <ControlAccount>();
var query = from a in _dataContext.ControlAccounts
where a.ControlId == parameter.ControlId
select a;
list = query.ToList <ControlAccount>();
if (list.Count == 1)
{
ControlAccount obj = list[0];
if (!String.IsNullOrEmpty(parameter.ControlId))
{
obj.ControlId = parameter.ControlId;
}
if (!String.IsNullOrEmpty(parameter.GroupId))
{
obj.GroupId = parameter.GroupId;
}
if (!String.IsNullOrEmpty(parameter.Name))
{
obj.Name = parameter.Name;
}
if (!String.IsNullOrEmpty(parameter.CompanyId))
{
obj.CompanyId = parameter.CompanyId;
}
if (parameter.DateOfEntry.HasValue)
{
obj.DateOfEntry = parameter.DateOfEntry.Value;
}
if (!String.IsNullOrEmpty(parameter.EntryBy))
{
obj.EntryBy = parameter.EntryBy;
}
if (!String.IsNullOrEmpty(parameter.Remarks))
{
obj.Remarks = parameter.Remarks;
}
_dataContext.SubmitChanges();
}
_ONSResultInsert.IsSuccess = true;
_ONSResultInsert.Message = "Control Account updated successfully.";
}
catch (Exception ex)
{
_ONSResultInsert.IsSuccess = false;
_ONSResultInsert.Message = ex.Message;
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResultInsert);
}
/// <summary>
/// Inserts the ID number.
/// </summary>
/// <param name="_IDNumber">The _ ID number.</param>
/// <returns></returns>
public ONSResult InsertIDNumber(IDNumber _IDNumber)
{
ONSResult _ONSResultSave = new ONSResult();
try
{
using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, DBHelper.TransactionOptions))
{
_ONSResultSave = ApplicationState.DAClient.InsertIDNumber(_IDNumber);
transaction.Complete();
}
}
catch (Exception ex)
{
ErrorHandler _ErrorHandler = new ErrorHandler();
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResultSave);
}
/// <summary>
/// Updates the group accounts.
/// </summary>
/// <param name="_GroupAccount">The _ group account.</param>
/// <returns></returns>
public ONSResult UpdateGroupAccounts(GroupAccount _GroupAccount)
{
ONSResult _ONSResultSave = new ONSResult();
try
{
using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, DBHelper.TransactionOptions))
{
_ONSResultSave = ApplicationState.DAClient.UpdateGroupAccount(_GroupAccount);
transaction.Complete();
}
}
catch (Exception ex)
{
ErrorHandler _ErrorHandler = new ErrorHandler();
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResultSave);
}
/// <summary>
/// Inserts the control accounts.
/// </summary>
/// <param name="_ControlAccount">The _ control account.</param>
/// <returns></returns>
public ONSResult InsertControlAccounts(ControlAccount _ControlAccount)
{
ONSResult _ONSResultSave = new ONSResult();
try
{
using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, DBHelper.TransactionOptions))
{
_ControlAccount.ControlId = _CommonMethods.RandomString(3);
_ONSResultSave = ApplicationState.DAClient.InsertControlAccount(_ControlAccount);
transaction.Complete();
}
}
catch (Exception ex)
{
ErrorHandler _ErrorHandler = new ErrorHandler();
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResultSave);
}
public ONSResult UpdateGroupAccount(GroupAccount parameter)
{
ONSResult _ONSResultInsert = new ONSResult();
try
{
List <GroupAccount> list = new List <GroupAccount>();
var query = from a in _dataContext.GroupAccounts
where a.GroupId == parameter.GroupId
select a;
list = query.ToList <GroupAccount>();
if (list.Count == 1)
{
GroupAccount obj = list[0];
if (!String.IsNullOrEmpty(parameter.GroupId))
{
obj.GroupId = parameter.GroupId;
}
if (!String.IsNullOrEmpty(parameter.Name))
{
obj.Name = parameter.Name;
}
if (!String.IsNullOrEmpty(parameter.BalanceType))
{
obj.BalanceType = parameter.BalanceType;
}
_dataContext.SubmitChanges();
}
_ONSResultInsert.IsSuccess = true;
_ONSResultInsert.Message = "Group Account updated successfully.";
}
catch (Exception ex)
{
_ONSResultInsert.IsSuccess = false;
_ONSResultInsert.Message = ex.Message;
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResultInsert);
}
public ONSResult InsertGroupAccount(GroupAccount parameter)
{
ONSResult _ONSResultInsert = new ONSResult();
try
{
_dataContext.GroupAccounts.InsertOnSubmit(parameter);
_dataContext.SubmitChanges();
_ONSResultInsert.ID = parameter.GroupId;
_ONSResultInsert.IsSuccess = true;
_ONSResultInsert.Message = "Group Account inserted successfully.";
}
catch (Exception ex)
{
_ONSResultInsert.IsSuccess = false;
_ONSResultInsert.Message = ex.Message;
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResultInsert);
}
public ONSResult InsertIDNumber(IDNumber parameter)
{
ONSResult _ONSResultInsert = new ONSResult();
try
{
_dataContext.IDNumbers.InsertOnSubmit(parameter);
_dataContext.SubmitChanges();
_ONSResultInsert.ID = parameter.SlNo.ToString();
_ONSResultInsert.IsSuccess = true;
_ONSResultInsert.Message = "IDNumber inserted successfully.";
}
catch (Exception ex)
{
_ONSResultInsert.IsSuccess = false;
_ONSResultInsert.Message = ex.Message;
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResultInsert);
}
public ONSResult CheckUserForLogIn(User _User)
{
ONSResult _ONSResult = new ONSResult();
try
{
List <User> _listUser = new List <User>();
_listUser = ApplicationState.DAClient.SelectUser(_User);
if (_listUser.Count > 0)
{
if (!_listUser[0].FirstLogIn.HasValue && !_listUser[0].LastActivated.HasValue)
{
_ONSResult.Remarks = "CP";
_ONSResult.IsSuccess = false;
_ONSResult.Message = "Invalid first login information.";
}
else if (_listUser[0].FirstLogIn.Value == true)
{
_ONSResult.Remarks = "CP";
_ONSResult.IsSuccess = false;
_ONSResult.Message = "Please change your password for the first time log in.";
}
else
{
DateTime LastActivated = _listUser[0].LastActivated.Value;
LastActivated = LastActivated.AddDays((_listUser[0].ActiveDays.HasValue ? _listUser[0].ActiveDays.Value : 0));
if (DateTime.Now.Date.Subtract(LastActivated).Days > 0)
{
_ONSResult.Remarks = "CP";
_ONSResult.IsSuccess = false;
_ONSResult.Message = "Please change your password, Because your activitation time allready over.";
}
else
{
List <UserLoginAssign> listUserLoginAssign = new List <UserLoginAssign>();
listUserLoginAssign = ApplicationState.DAClient.SelectUserLoginAssign
(new UserLoginAssign {
UserName = _listUser[0].UserName, CompanyId = _listUser[0].CompanyId, LocationId = _listUser[0].LocationId
});
if (listUserLoginAssign.Count > 0)
{
ApplicationState.User = _listUser[0].UserName;
ApplicationState.UserFullName = _listUser[0].FullName;
ApplicationState.Department = _listUser[0].UserDepartment.Name;
ApplicationState.Level = _listUser[0].UserLevel.Name;
List <Company> listCompany = ApplicationState.DAClient.SelectCompany(new Company {
CompanyId = listUserLoginAssign[0].CompanyId
});
if (listCompany.Count > 0)
{
ApplicationState.CompanyId = listCompany[0].CompanyId;
ApplicationState.CompanyName = listCompany[0].Name;
ApplicationState.CompanyAddress = listCompany[0].Address;
}
List <Location> listLocation = ApplicationState.DAClient.SelectLocation(new Location {
LocationId = listUserLoginAssign[0].LocationId
});
if (listLocation.Count > 0)
{
ApplicationState.LocationId = listLocation[0].LocationId;
ApplicationState.LocationName = listLocation[0].Name;
}
//ApplicationState.UserEntryExitID = CommonMethods.GetID(Constant.IDType.UEE.ToString(), DateTime.Now.Year);
List <UserEntryExit> _listUserEntryExit = new List <UserEntryExit>();
_listUserEntryExit.Add(new UserEntryExit
{
Name = _listUser[0].UserName,
EntryTime = DateTime.Now.ToLongTimeString(),
EntryDate = DateTime.Now.Date
});
ApplicationState.UserEntryExitID = _Setup_Save_BLL.SaveUserEntryExit(_listUserEntryExit).ID;
_ONSResult.IsSuccess = true;
_ONSResult.Message = "Welcome! You are successfully log in.";
}
else
{
_ONSResult.IsSuccess = false;
_ONSResult.Message = "This user is not assigned for this location.";
}
}
}
}
else
{
_ONSResult.IsSuccess = false;
_ONSResult.Message = "No user found with this user name and password.";
}
}
catch (Exception ex)
{
ErrorHandler _ErrorHandler = new ErrorHandler();
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResult);
}
public ONSResult UpdateUserEntryExit(UserEntryExit parameter)
{
ONSResult _ONSResultInsert = new ONSResult();
try
{
List <UserEntryExit> list = new List <UserEntryExit>();
var query = from a in _dataContext.UserEntryExits
where a.UserEntryExitID == parameter.UserEntryExitID
select a;
list = query.ToList <UserEntryExit>();
if (list.Count == 1)
{
UserEntryExit obj = list[0];
if (!String.IsNullOrEmpty(parameter.UserEntryExitID))
{
obj.UserEntryExitID = parameter.UserEntryExitID;
}
if (!String.IsNullOrEmpty(parameter.Name))
{
obj.Name = parameter.Name;
}
if (!String.IsNullOrEmpty(parameter.EntryTime))
{
obj.EntryTime = parameter.EntryTime;
}
if (!String.IsNullOrEmpty(parameter.ExitTime))
{
obj.ExitTime = parameter.ExitTime;
}
if (parameter.EntryDate.HasValue)
{
obj.EntryDate = parameter.EntryDate.Value;
}
if (parameter.ExitDate.HasValue)
{
obj.ExitDate = parameter.ExitDate.Value;
}
if (!String.IsNullOrEmpty(parameter.CompanyId))
{
obj.CompanyId = parameter.CompanyId;
}
if (!String.IsNullOrEmpty(parameter.LocationId))
{
obj.LocationId = parameter.LocationId;
}
_dataContext.SubmitChanges();
}
_ONSResultInsert.IsSuccess = true;
_ONSResultInsert.Message = "IDNumber updated successfully.";
}
catch (Exception ex)
{
_ONSResultInsert.IsSuccess = false;
_ONSResultInsert.Message = ex.Message;
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResultInsert);
}
public ONSResult UpdateIDNumber(IDNumber parameter)
{
ONSResult _ONSResultInsert = new ONSResult();
try
{
List <IDNumber> list = new List <IDNumber>();
var query = from a in _dataContext.IDNumbers
where a.SlNo == parameter.SlNo
select a;
list = query.ToList <IDNumber>();
if (list.Count == 1)
{
IDNumber obj = list[0];
if (parameter.SlNo != 0)
{
obj.SlNo = parameter.SlNo;
}
if (!String.IsNullOrEmpty(parameter.IDNo))
{
obj.IDNo = parameter.IDNo;
}
if (!String.IsNullOrEmpty(parameter.IDTypeId))
{
obj.IDTypeId = parameter.IDTypeId;
}
if (!String.IsNullOrEmpty(parameter.CompanyId))
{
obj.CompanyId = parameter.CompanyId;
}
if (!String.IsNullOrEmpty(parameter.LocationId))
{
obj.LocationId = parameter.LocationId;
}
if (!String.IsNullOrEmpty(parameter.EntryBy))
{
obj.EntryBy = parameter.EntryBy;
}
if (parameter.DateOfEntry.HasValue)
{
obj.DateOfEntry = parameter.DateOfEntry.Value;
}
if (parameter.IDYear.HasValue)
{
obj.IDYear = parameter.IDYear.Value;
}
_dataContext.SubmitChanges();
}
_ONSResultInsert.IsSuccess = true;
_ONSResultInsert.Message = "IDNumber updated successfully.";
}
catch (Exception ex)
{
_ONSResultInsert.IsSuccess = false;
_ONSResultInsert.Message = ex.Message;
_ErrorHandler.ONSERRORProcessing(ex);
}
return(_ONSResultInsert);
}
