public StatusDTO <UserTransactionDTO> Delete(UserTransactionDTO data) { StatusDTO <UserTransactionDTO> status = new StatusDTO <UserTransactionDTO>(); status.IsSuccess = false; using (IDbSvc dbSvc = new DbSvc(_configSvc)) { try { dbSvc.OpenConnection(); MySqlCommand command = new MySqlCommand(); command.CommandText = "DELETE FROM UserTransaction WHERE UserTransactionId=@userTrans"; command.Parameters.Add("@userTrans", MySqlDbType.Int32).Value = data.UserTransactionId; command.Connection = dbSvc.GetConnection() as MySqlConnection; if (command.ExecuteNonQuery() > 0) { status.IsSuccess = true; } return(status); } catch (Exception exp) { _logger.Log(exp); throw exp; } } }
public void DeleteUserTransaction(UserTransactionDTO transaction) { UserTransaction t = db.UserTransactions.GetById(transaction.Id); db.UserTransactions.Delete(t); db.Save(); }
public StatusDTO UpdateTransLastRunNextRun(UserTransactionDTO userTrans) { StatusDTO status = new StatusDTO(); status.IsSuccess = false; using (IDbSvc dbSvc = new DbSvc(_configSvc)) { try { dbSvc.OpenConnection(); MySqlCommand command = new MySqlCommand(); command.CommandText = "UPDATE UserTransaction SET LastAutoTransactionOn=@lastTransOn, NextAutoTransactionOn=@nextAutoTransOn WHERE UserTransactionId=@userTrans"; command.Parameters.Add("@lastTransOn", MySqlDbType.Date).Value = userTrans.LastAutoTransactionOn; command.Parameters.Add("@nextAutoTransOn", MySqlDbType.Date).Value = userTrans.NextAutoTransactionOn; command.Parameters.Add("@userTrans", MySqlDbType.Int32).Value = userTrans.UserTransactionId; command.Connection = dbSvc.GetConnection() as MySqlConnection; if (command.ExecuteNonQuery() > 0) { status.IsSuccess = true; } return(status); } catch (Exception exp) { _logger.Log(exp); throw exp; } } }
public JsonResult DeleteUserTransaction(UserTransactionDTO uTrans) { if (_userTrans.Delete(uTrans).IsSuccess) { return(Json(new { status = true, message = "Deleted successfully." }, JsonRequestBehavior.AllowGet)); } return(Json(new { status = false, message = "Delete failed." }, JsonRequestBehavior.AllowGet)); }
public void EditUserTransaction(UserTransactionDTO transaction) { UserTransaction utdb = db.UserTransactions.GetById(transaction.Id); utdb.Description = transaction.Description; utdb.Sum = transaction.Sum; db.UserTransactions.Update(utdb); db.Save(); }
public StatusDTO <UserTransactionDTO> Update(UserTransactionDTO data) { StatusDTO <UserTransactionDTO> status = new StatusDTO <UserTransactionDTO>(); status.IsSuccess = false; using (IDbSvc dbSvc = new DbSvc(_configSvc)) { try { dbSvc.OpenConnection(); MySqlCommand command = new MySqlCommand(); command.CommandText = "UPDATE UserTransaction SET TranMasterId=@tranMasterId, GraceAmountOn=@graceAmountOn, GraceAmount=@graceAmount WHERE UserTransactionId=@uTranId"; if (data.Transaction != null && data.Transaction.TranMasterId > 0) { command.Parameters.Add("@tranMasterId", MySqlDbType.Int32).Value = data.Transaction.TranMasterId; } else { command.Parameters.Add("@tranMasterId", MySqlDbType.Int32).Value = DBNull.Value; } if (!string.IsNullOrEmpty(data.GraceAmountIn) && !string.Equals(data.GraceAmountIn, "-1")) { command.Parameters.Add("@graceAmountOn", MySqlDbType.String).Value = data.GraceAmountIn; } else { command.Parameters.Add("@graceAmountOn", MySqlDbType.String).Value = DBNull.Value; } if (data.GraceAmount != null) { command.Parameters.Add("@graceAmount", MySqlDbType.String).Value = data.GraceAmount.Value; } else { command.Parameters.Add("@graceAmount", MySqlDbType.String).Value = DBNull.Value; } command.Parameters.Add("@uTranId", MySqlDbType.Int32).Value = data.UserTransactionId; command.Connection = dbSvc.GetConnection() as MySqlConnection; if (command.ExecuteNonQuery() > 0) { status.IsSuccess = true; } return(status); } catch (Exception exp) { _logger.Log(exp); throw exp; } } }
void DeleteUserTransactionClick(object sender, EventArgs e) { UserTransactionDTO ut = new UserTransactionDTO { Id = Convert.ToInt16(transactionId.Text), Description = transactionDescription.Text, Sum = Convert.ToDecimal(transactionSum.Text) }; new UserTransactionService(Server).DeleteUserTransaction(ut); ClearUserTransactionEditForm(); }
public void AddTransaction(string user, UserTransactionDTO ut) { UserTransaction utdb = new UserTransaction { Id = db.UserTransactions.GetLastUsedUserTransactionId() + 1, Date = ut.Date, User = db.Users.GetUserByLogin(user), Description = ut.Description, Sum = ut.Sum }; db.UserTransactions.Create(utdb); db.Save(); }
public List <UserTransactionDTO> GetUserTransactions(int trMasterId, int userMasterId) { using (IDbSvc dbSvc = new DbSvc(_configSvc)) { try { dbSvc.OpenConnection(); MySqlCommand command = new MySqlCommand(); command.CommandText = "SELECT UserTransactionId, TranMasterId, GraceAmountOn, GraceAmount FROM UserTransaction WHERE UserMasterId=@umId AND TranMasterId=@tranMasterId AND Active=1"; command.Parameters.Add("@umId", MySqlDbType.Int32).Value = userMasterId; command.Parameters.Add("@tranMasterId", MySqlDbType.Int32).Value = trMasterId; command.Connection = dbSvc.GetConnection() as MySqlConnection; MySqlDataAdapter mDa = new MySqlDataAdapter(command); _dtResult = new DataTable(); mDa.Fill(_dtResult); List <UserTransactionDTO> lstUTrans = null; if (_dtResult != null && _dtResult.Rows.Count > 0) { lstUTrans = new List <UserTransactionDTO>(); UserTransactionDTO uTrans = null; foreach (DataRow dr in _dtResult.Rows) { uTrans = new UserTransactionDTO(); uTrans.UserTransactionId = (int)dr["UserTransactionId"]; uTrans.Transaction = new TransactionMasterDTO(); uTrans.Transaction.TranMasterId = (int)dr["TranMasterId"]; uTrans.GraceAmountIn = string.IsNullOrEmpty(dr["GraceAmountOn"].ToString()) ? "-1" : dr["GraceAmountOn"].ToString(); if (string.IsNullOrEmpty(dr["GraceAmount"].ToString())) { uTrans.GraceAmount = null; } else { uTrans.GraceAmount = double.Parse(dr["GraceAmount"].ToString()); } lstUTrans.Add(uTrans); } } return(lstUTrans); } catch (Exception exp) { _logger.Log(exp); throw exp; } } }
void EditUserTransactionClick(object sender, EventArgs e) { if (!CheckAddUserTransactionTextboxesForMinimumValidData()) { return; } UserTransactionDTO transaction = new UserTransactionDTO { Id = Convert.ToInt16(transactionId.Text), Description = transactionDescription.Text, Sum = Convert.ToDecimal(transactionSum.Text), }; new UserTransactionService(Server).EditUserTransaction(transaction); ClearUserTransactionEditForm(); }
void AddUserTransaction(object sender, EventArgs e) { string login = transactionUser.Text; if (!CheckAddUserTransactionTextboxesForMinimumValidData()) { return; } UserTransactionDTO ut = new UserTransactionDTO { Date = transactionDate.Value, Description = transactionDescription.Text, Sum = Convert.ToDecimal(transactionSum.Text) }; new UserTransactionService(Server).AddTransaction(login, ut); ClearUserTransactionEditForm(); transactionUser.Text = login; }
public void AddRegularTransactions() { FillTransDetails(); DataTable dtReader = _uTransSvc.GetUserTransactions(_runDate); if (dtReader != null) { foreach (DataRow reader in dtReader.Rows) { try { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required)) { DateTime?lastDayOfRun = null; DateTime?nextDayToRun = null; string isDiffTo = string.Empty; int transMasterId = (int)reader["TranMasterId"]; if (IsTransactionRequired(transMasterId, string.IsNullOrEmpty(reader["NextAutoTransactionOn"].ToString())?null: reader["NextAutoTransactionOn"], string.IsNullOrEmpty(reader["LastAutoTransactionOn"].ToString())?null: reader["LastAutoTransactionOn"], out lastDayOfRun, out nextDayToRun, out isDiffTo)) { DataRow[] rules = GetRuleRow(transMasterId, isDiffTo, reader["StandardId"], reader["SectionId"], reader["UserMasterId"], reader["ClassTypeId"]); if (rules != null) { //Insert records as pending in trans log TransactionLogDTO trnsLogDto = new TransactionLogDTO(); trnsLogDto.Active = true; trnsLogDto.User = new UserMasterDTO(); trnsLogDto.User.UserMasterId = (int)reader["UserMasterId"]; trnsLogDto.TransactionDate = _runDate; if (rules[0]["FirstDueAfterDays"] != null || !string.IsNullOrEmpty(rules[0]["FirstDueAfterDays"].ToString())) { trnsLogDto.TransactionDueDate = _runDate.AddDays((int)rules[0]["FirstDueAfterDays"]); } else { trnsLogDto.TransactionDueDate = null; } trnsLogDto.TransactionPreviousDueDate = null; trnsLogDto.ParentTransactionLogId = null; trnsLogDto.IsCompleted = false; trnsLogDto.CompletedOn = null; trnsLogDto.AmountImposed = CalculateAmount(string.IsNullOrEmpty(reader["GraceAmountOn"].ToString())?null: reader["GraceAmountOn"], string.IsNullOrEmpty(reader["GraceAmount"].ToString())?null: reader["GraceAmount"], double.Parse(rules[0]["ActualAmount"].ToString())); trnsLogDto.AmountGiven = null; trnsLogDto.DueAmount = trnsLogDto.AmountImposed; trnsLogDto.TransferMode = null; trnsLogDto.Location = null; if (string.Equals(reader["RoleId"].ToString(), _commonConfig["STUD_ROLE_ID"])) { trnsLogDto.StandardSectionMap = new StandardSectionMapDTO(); trnsLogDto.StandardSectionMap.StandardSectionId = (int)reader["StandardSectionId"]; } else { trnsLogDto.StandardSectionMap = null; } trnsLogDto.TransactionType = reader["TransactionType"].ToString(); trnsLogDto.HasPenalty = false; trnsLogDto.TransactionRule = new TransactionRuleDTO(); trnsLogDto.TransactionRule.TranRuleId = (int)rules[0]["TranRuleId"]; if (trnsLogDto.TransactionDueDate != null) { trnsLogDto.PenaltyTransactionRule = new TransactionRuleDTO(); trnsLogDto.PenaltyTransactionRule.TranRuleId = trnsLogDto.TransactionRule.TranRuleId; } StatusDTO <TransactionLogDTO> status = _transLog.Insert(trnsLogDto); if (status.IsSuccess) { UserTransactionDTO uTrns = new UserTransactionDTO(); uTrns.LastAutoTransactionOn = lastDayOfRun; uTrns.NextAutoTransactionOn = nextDayToRun; uTrns.UserTransactionId = (int)reader["UserTransactionId"]; StatusDTO uTrnsStatus = _uTransSvc.UpdateTransLastRunNextRun(uTrns); if (uTrnsStatus.IsSuccess) { ts.Complete(); } } } } } } catch (Exception exp) { _logger.Log(exp); } } } //Disposing source data _uTransSvc.Dispose(); if (dtReader != null) { dtReader.Dispose(); dtReader = null; } }
public StatusDTO <List <UserTransactionDTO> > Select(UserTransactionDTO data) { throw new NotImplementedException(); }