/// <summary> /// Inserts the user entry exit. /// </summary> /// <param name="_UserEntryExit">The _ user entry exit.</param> /// <returns></returns> public ONSResult InsertUserEntryExit(UserEntryExit _UserEntryExit) { ONSResult _ONSResultSave = new ONSResult(); try { using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, DBHelper.TransactionOptions)) { _ONSResultSave = ApplicationState.DAClient.InsertUserEntryExit(_UserEntryExit); transaction.Complete(); } } catch (Exception ex) { ErrorHandler _ErrorHandler = new ErrorHandler(); _ErrorHandler.ONSERRORProcessing(ex); } return(_ONSResultSave); }
public ONSResult InsertUserEntryExit(UserEntryExit parameter) { ONSResult _ONSResultInsert = new ONSResult(); try { _dataContext.UserEntryExits.InsertOnSubmit(parameter); _dataContext.SubmitChanges(); _ONSResultInsert.ID = parameter.UserEntryExitID; _ONSResultInsert.IsSuccess = true; _ONSResultInsert.Message = "UserEntryExit inserted successfully."; } catch (Exception ex) { _ONSResultInsert.IsSuccess = false; _ONSResultInsert.Message = ex.Message; _ErrorHandler.ONSERRORProcessing(ex); } return(_ONSResultInsert); }
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); }