public SelectList getTransactionMasters(string frequency = null)
{
List <TransactionMasterDTO> lstentitleDto = _ddlRepo.GetTransactionMasters(frequency);
TransactionMasterDTO trMasterDTO = new TransactionMasterDTO();
trMasterDTO.TranMasterId = -1;
trMasterDTO.TransactionName = string.Empty;
lstentitleDto.Insert(0, trMasterDTO);
return(new SelectList(lstentitleDto, "TranMasterId", "TransactionName"));
}
public StatusDTO <List <TransactionMasterDTO> > GetAllTransactioMasters()
{
using (IDbSvc dbSvc = new DbSvc(_configSvc))
{
try
{
MySqlCommand command = new MySqlCommand();
command.CommandText = "SELECT TranMasterId, TransactionName, TransactionType, IsPenalty, Frequency, DayToRun, YearlyDayToRun, IsdifferentTo, Active FROM transactionmaster";
command.Connection = dbSvc.GetConnection() as MySqlConnection;
MySqlDataAdapter dataAdap = new MySqlDataAdapter(command);
_dtResult = new DataTable("TRANS_MASTER");
dataAdap.Fill(_dtResult);
StatusDTO <List <TransactionMasterDTO> > status = new StatusDTO <List <TransactionMasterDTO> >();
if (_dtResult != null && _dtResult.Rows.Count > 0)
{
status.ReturnObj = new List <TransactionMasterDTO>();
TransactionMasterDTO trMaster;
foreach (DataRow dr in _dtResult.Rows)
{
trMaster = new TransactionMasterDTO();
trMaster.TranMasterId = (int)dr["TranMasterId"];
trMaster.TransactionName = dr["TransactionName"].ToString();
trMaster.TransactionType = dr["TransactionType"].ToString();
trMaster.IsPenalty = string.Equals(dr["IsPenalty"].ToString(), "1") ? true : false;
trMaster.Frequency = dr["Frequency"].ToString();
trMaster.DayToRun = dr["DayToRun"].ToString();
trMaster.YearlyDayToRun = dr["YearlyDayToRun"].ToString();
trMaster.IsDiffTo = dr["IsdifferentTo"].ToString();
trMaster.Active = string.Equals(dr["Active"].ToString(), "1") ? true : false;
status.ReturnObj.Add(trMaster);
}
}
status.IsSuccess = true;
status.IsException = false;
return(status);
}
catch (Exception exp)
{
_logger.Log(exp);
throw exp;
}
}
}
public StatusDTO <TransactionMasterDTO> Insert(TransactionMasterDTO data)
{
StatusDTO <TransactionMasterDTO> status = new StatusDTO <TransactionMasterDTO>();
using (IDbSvc dbSvc = new DbSvc(_configSvc))
{
try
{
dbSvc.OpenConnection();
MySqlCommand command = new MySqlCommand();
command.CommandText = "INSERT INTO transactionmaster (TransactionType, TransactionName, IsPenalty, Frequency, DayToRun, YearlyDayToRun, IsdifferentTo, Active)" +
" VALUES(@transactionType, @trName, @isPenalty, @frequency, @dayToRun, @yearlyDayToRun, @isdifferentTo, @active)";
command.Connection = dbSvc.GetConnection() as MySqlConnection;
command.Parameters.Add("@transactionType", MySqlDbType.String).Value = data.TransactionType;
command.Parameters.Add("@trName", MySqlDbType.String).Value = data.TransactionName;
command.Parameters.Add("@isPenalty", MySqlDbType.Bit).Value = data.IsPenalty;
command.Parameters.Add("@frequency", MySqlDbType.String).Value = data.Frequency;
command.Parameters.Add("@dayToRun", MySqlDbType.String).Value = data.DayToRun;
command.Parameters.Add("@yearlyDayToRun", MySqlDbType.String).Value = data.YearlyDayToRun;
command.Parameters.Add("@isdifferentTo", MySqlDbType.String).Value = data.IsDiffTo;
command.Parameters.Add("@active", MySqlDbType.Bit).Value = data.Active;
if (command.ExecuteNonQuery() > 0)
{
status.IsSuccess = true;
status.IsException = false;
status.ReturnObj = data;
}
return(status);
}
catch (Exception exp)
{
_logger.Log(exp);
throw exp;
}
}
}
public List <TransactionMasterDTO> GetTransactionMasters(string frequency = null)
{
using (IDbSvc dbSvc = new DbSvc(_configSvc))
{
try
{
dbSvc.OpenConnection();
MySqlCommand command = new MySqlCommand();
command.CommandText = "select TranMasterId, TransactionName from transactionmaster where Active=1";
if (!string.IsNullOrEmpty(frequency))
{
command.CommandText = command.CommandText + " AND Frequency=@freq";
command.Parameters.Add("@freq", MySqlDbType.VarChar).Value = frequency;
}
command.Connection = dbSvc.GetConnection() as MySqlConnection;
_dtData = new DataTable();
MySqlDataAdapter msDa = new MySqlDataAdapter(command);
msDa.Fill(_dtData);
List <TransactionMasterDTO> lstTrMaster = new List <TransactionMasterDTO>();
if (_dtData != null && _dtData.Rows.Count > 0)
{
TransactionMasterDTO trMaster = null;
foreach (DataRow dr in _dtData.Rows)
{
trMaster = new TransactionMasterDTO();
trMaster.TranMasterId = (int)dr["TranMasterId"];
trMaster.TransactionName = dr["TransactionName"].ToString();
lstTrMaster.Add(trMaster);
}
}
return(lstTrMaster);
}
catch (Exception exp)
{
throw exp;
}
}
}
public StatusDTO <List <TransactionMasterDTO> > Select(TransactionMasterDTO data)
{
throw new NotImplementedException();
}
public StatusDTO <TransactionMasterDTO> Delete(TransactionMasterDTO data)
{
throw new NotImplementedException();
}
void SaveData()
{
dTable = TransactionMasterDTO.CreateDataTable();
dRow = dTable.NewRow();
dRow["TranOID"] =
// dRow["FileType"]=
// dRow["GroupName"]=
// dRow["ANZCustomerId"]=
// dRow["CustRegisterName"]=
// dRow["CustCompanyAddress"]=
// dRow["CustCompanyAddressCountry"]=
// dRow["CustContractAddress"]=
// dRow["CustContractAddressCountry"]=
// dRow["TransactionMethod"]=
// dRow["BeneTranxRefNo"]=
// dRow["BeneBankName"]=
//dRow["SendIdType"]=
// dRow["SendIdNo"]=
// dRow["SendIdIssueBy"]=
// dRow["BeneIdNo"]=
// dRow["BeneIdIssueBy"]=
// dRow["Remark"]=
// dRow["MappingSourceDB"] =
//dRow["BeneIdType"]=
dRow["CustomerInstrumentId"] = txtInstrumentId.Text; // PK
dRow["CustomerBankAccountNumber"] = txtBANKAccount.Text; // PK
dRow["CustRegisterID"] = txtANZRegisterID.Text;
dRow["CustBusinessCode"] = txtANZBusinessCode.Text;
dRow["CustRegisterAddress"] = txtANZAddress.Text;
dRow["CustRegisterAddressCountry"] = txtANZCountry.Text;
dRow["CustRegisterDate"] = Utility.ConvertFormatDatetime(txtANZRegisterDate.Text);
dRow["TransactionDate"] = Utility.ConvertFormatDatetime(txtTransactionDate.Text);
dRow["TranxAmountThb"] = txtTranxAmountTHB.Text;
dRow["TranxAmountCurrency"] = txtCurrency.Text;
dRow["TranxCurrency"] = txtCurrency.Text;
dRow["TranxExchangeRate"] = txtExchangeRate.Text;
dRow["TranxCurrency"] = txtANZCountry.Text;
dRow["TranxAmountThbInThWord"] = "";
dRow["TranxInternationalOrDomestic"] = "";
dRow["TranxSendReceive"] = txtTranxSendReceive.Text;
dRow["TranxObjective"] = txtObjective.Text;
dRow["SendTranxRefNo"] = txtSendTranxRefNo.Text;
dRow["SendBankName"] = txtSendBankName.Text;
dRow["SendBankCountry"] = txtSendBankCountry.Text;
dRow["SendBankAccountNo"] = txtSendAccountNumber.Text;
dRow["SendName"] = txtSendName.Text;
dRow["SendAddress"] = txtSendAddress.Text;
dRow["SendIdDescription"] = txtSendDescription.Text;
dRow["BeneBankAccountNo"] = txtBeneAccountNumber.Text;
dRow["BeneBankCountry"] = txtBeneBankCountry.Text;
dRow["BeneName"] = txtBeneName.Text;
dRow["BeneBankName"] = txtBeneBankName.Text;
dRow["BeneTranxRefNo"] = txtBeneTranxRefNo.Text;
dRow["BeneAddress"] = txtBeneAddress.Text;
dRow["BeneIdDescription"] = txtBeneDescription.Text;
dTable.Rows.Add(dRow);
bal = new TransactionMasterBAL();
if (bal.Add(dTable))
{
MessageBox.Show(MessageDto.SaveSuccess, "Saving");
popDetail.Visible = false;
InitialData();
}
}
public JsonResult GetIsDifferentTo(TransactionMasterDTO trnsMaster)
{
string isDiffTo = _trnsMaster.GetIsDifferentTo(trnsMaster.TranMasterId);
return(Json(new { status = true, diffTo = isDiffTo }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTransactionMasters(TransactionMasterDTO trnsMaster)
{
List <TransactionMasterDTO> transactionMasters = _ddlRepo.GetTransactionMasters(trnsMaster.Frequency);
return(Json(new { status = true, data = transactionMasters }, JsonRequestBehavior.AllowGet));
}
