public void Add(MFTransactions MFTransactions)
{
try
{
string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(SELECT_ID, MFTransactions.MFId));
DataBase.DBService.BeginTransaction();
DataBase.DBService.ExecuteCommandString(string.Format(INSERT_MFTransactions,
MFTransactions.MFId,
MFTransactions.Nav, MFTransactions.Units, MFTransactions.CurrentValue,
MFTransactions.TransactionType, MFTransactions.TransactionDate,
MFTransactions.CreatedOn.ToString("yyyy-MM-dd hh:mm:ss"), MFTransactions.CreatedBy,
MFTransactions.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"), MFTransactions.UpdatedBy), true);
Activity.ActivitiesService.Add(ActivityType.CreateMFTransactions, EntryStatus.Success,
Source.Server, MFTransactions.UpdatedByUserName, "MFTransactions", MFTransactions.MachineName);
DataBase.DBService.CommitTransaction();
}
catch (Exception ex)
{
DataBase.DBService.RollbackTransaction();
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
public IList <MFTransactions> GetAll(int plannerId)
{
try
{
Logger.LogInfo("Get: Mutual fund transaction process start");
IList <MFTransactions> lstMFTransactionsOption = new List <MFTransactions>();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ALL, plannerId));
foreach (DataRow dr in dtAppConfig.Rows)
{
MFTransactions mf = convertToMFTransactions(dr);
lstMFTransactionsOption.Add(mf);
}
Logger.LogInfo("Get: Mutual fund transaction process completed.");
return(lstMFTransactionsOption);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
private void btnSaveMFTrans_Click(object sender, EventArgs e)
{
MFTransactions mfTrans = getMFTransData();
bool isSaved = false;
MFTransInfo mfTransInfo = new MFTransInfo();
if (mfTrans != null && mfTrans.Id == 0)
{
isSaved = mfTransInfo.Add(mfTrans);
}
else
{
isSaved = mfTransInfo.Update(mfTrans);
}
if (isSaved)
{
MessageBox.Show("Record save successfully.", "Record Saved", MessageBoxButtons.OK, MessageBoxIcon.Information);
fillMFTransData();
grpMFTransaction.Enabled = false;
}
else
{
MessageBox.Show("Unable to save record.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private MFTransactions getMFTransData()
{
MFTransactions mfTrans = new MFTransactions();
mfTrans.Id = int.Parse(lblSchemenameVal.Tag.ToString());
mfTrans.MFId = this.mf.Id;
mfTrans.Nav = float.Parse(txtNav.Text);
mfTrans.Units = int.Parse(txtUnits.Text);
mfTrans.TransactionType = cmbTransType.Text;
mfTrans.TransactionDate = dtTransDate.Value;
return(mfTrans);
}
private void btnDeleteMF_Click(object sender, EventArgs e)
{
if (dtGridMFTrans.SelectedRows.Count > 0)
{
if (MessageBox.Show("Are you sure, you want to delete this record?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
MFTransInfo mutualFundInfo = new MFTransInfo();
MFTransactions mfTrans = getMFTransData();
mutualFundInfo.Delete(mfTrans);
fillMFTransData();
}
}
}
private MFTransactions convertToMFTransactions(DataRow dr)
{
MFTransactions MFTransactions = new MFTransactions();
MFTransactions.Id = dr.Field <int>("ID");
MFTransactions.MFId = dr.Field <int>("MFId");
MFTransactions.TransactionType = dr.Field <string>("TransactionType");
MFTransactions.TransactionDate = dr.Field <DateTime>("TransactionDate");
MFTransactions.Nav = float.Parse(dr["NAV"].ToString());
MFTransactions.Units = dr.Field <int>("units");
MFTransactions.UpdatedBy = dr.Field <int>("UpdatedBy");
MFTransactions.UpdatedOn = dr.Field <DateTime>("UpdatedOn");
//MFTransactions.UpdatedByUserName = dr.Field<string>("UpdatedByUserName");
return(MFTransactions);
}
public Result Delete(MFTransactions mf)
{
var result = new Result();
try
{
MFTransactionsService MFTransactionsService = new MFTransactionsService();
MFTransactionsService.Delete(mf);
result.IsSuccess = true;
}
catch (Exception exception)
{
result.IsSuccess = false;
result.ExceptionInfo = exception;
}
return(result);
}
internal bool Delete(MFTransactions MFTransactions)
{
try
{
FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization();
string apiurl = Program.WebServiceUrl + "/" + DELETE_MFTransactions_API;
RestAPIExecutor restApiExecutor = new RestAPIExecutor();
var restResult = restApiExecutor.Execute <MFTransactions>(apiurl, MFTransactions, "POST");
return(true);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(false);
}
}
public MFTransactions Get(int id)
{
try
{
Logger.LogInfo("Get: Mutual fund by id process start");
MFTransactions MFTransactions = new MFTransactions();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ID, id));
foreach (DataRow dr in dtAppConfig.Rows)
{
MFTransactions = convertToMFTransactions(dr);
}
Logger.LogInfo("Get: Mutual fund by id process completed");
return(MFTransactions);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
public void Delete(MFTransactions MFTransactions)
{
try
{
string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(SELECT_ID, MFTransactions.Id));
DataBase.DBService.BeginTransaction();
DataBase.DBService.ExecuteCommandString(string.Format(DELETE_MFTransactions,
MFTransactions.Id), true);
Activity.ActivitiesService.Add(ActivityType.DeleteMFTransactions, EntryStatus.Success,
Source.Server, MFTransactions.UpdatedByUserName, "MFTransactions", MFTransactions.MachineName);
DataBase.DBService.CommitTransaction();
}
catch (Exception ex)
{
DataBase.DBService.RollbackTransaction();
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
