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();
}
