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