protected void btnDelete_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnDelete_Click";
WSCSecurity auth = Globals.SecurityState;
if (auth.SecurityGroupName.ToUpper().IndexOf("AG ADMIN") == -1)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "Sorry, you are not authorized to update this information");
return;
}
try {
int bankID = 0;
if (txtBankID.Text.Length > 0)
{
bankID = Convert.ToInt32(txtBankID.Text);
}
WSCBank.BankDelete(bankID, Globals.SecurityState.UserName);
ClearBankDetail();
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnSave_Click";
WSCSecurity auth = Globals.SecurityState;
if (auth.SecurityGroupName.ToUpper().IndexOf("AG ADMIN") == -1)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "Sorry, you are not authorized to update this information");
return;
}
try {
int bankID = 0;
if (txtBankID.Text.Length > 0)
{
bankID = Convert.ToInt32(txtBankID.Text);
}
WSCBank.BankSave(ref bankID, txtBankName.Text, txtBankNumber.Text,
txtShortName.Text, txtAddrLine1.Text, txtAddrLine2.Text, txtCity.Text,
Common.UILib.GetDropDownText(ddlState), txtZip.Text, txtContactName.Text, txtPhone.Text, txtFax.Text,
txtEmail.Text, txtOther.Text, chkIsActive.Checked, (Globals.SecurityState).UserName);
if (bankID > 0)
{
ShowBankDetail(bankID);
}
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
}
private void ShowBankDetail(int bankID)
{
ClearBankDetail();
try {
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
using (SqlDataReader dr = WSCBank.BankGetByID(conn, bankID)) {
if (dr.Read())
{
txtBankName.Text = dr.GetString(dr.GetOrdinal("bnk_name"));
txtBankID.Text = dr.GetInt32(dr.GetOrdinal("bnk_bank_id")).ToString();
txtShortName.Text = dr.GetString(dr.GetOrdinal("bnk_short_name"));
txtBankNumber.Text = dr.GetString(dr.GetOrdinal("bnk_number"));
txtAddrLine1.Text = dr.GetString(dr.GetOrdinal("bnk_addr_line1"));
txtAddrLine2.Text = dr.GetString(dr.GetOrdinal("bnk_addr_line2"));
txtCity.Text = dr.GetString(dr.GetOrdinal("bnk_city"));
Common.UILib.SelectDropDown(ddlState, dr.GetString(dr.GetOrdinal("bnk_state")));
txtZip.Text = dr.GetString(dr.GetOrdinal("bnk_postal_code"));
txtContactName.Text = dr.GetString(dr.GetOrdinal("bnk_contact_name"));
txtPhone.Text = dr.GetString(dr.GetOrdinal("bnk_phone"));
txtFax.Text = dr.GetString(dr.GetOrdinal("bnk_fax"));
txtEmail.Text = dr.GetString(dr.GetOrdinal("bnk_email"));
txtOther.Text = dr.GetString(dr.GetOrdinal("bnk_other"));
chkIsActive.Checked = dr.GetBoolean(dr.GetOrdinal("bnk_is_active"));
}
}
}
}
catch (Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + "ShowBankDetail", ex);
throw (wex);
}
}
private void ShowBankEquityList(int memberID, int cropYear)
{
ClearBankEquityList();
try {
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
using (SqlDataReader dr = WSCBank.BankEquityGetList(conn, memberID, cropYear)) {
grdEquityResults.DataSource = dr;
grdEquityResults.DataBind();
}
}
}
catch (Exception ex) {
Common.CException wex = new Common.CException("BankMaintenance.ShowBankEquityList", ex);
throw (wex);
}
}
private void ShowEquityBankDetail(int bankID)
{
ClearEquityBankDetail();
try {
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
using (SqlDataReader dr = WSCBank.BankGetByID(conn, bankID)) {
if (dr.Read())
{
txtEquityBankName.Text = dr.GetString(dr.GetOrdinal("bnk_name"));
txtEquityBankID.Text = dr.GetInt32(dr.GetOrdinal("bnk_bank_id")).ToString();
}
}
}
}
catch (Exception ex) {
Common.CException wex = new Common.CException("BankMaintenance.ShowEquityBankDetail", ex);
throw (wex);
}
}
private void ShowBankResults()
{
try {
grdResults.DataSource = null;
grdResults.DataBind();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) {
if (radBankName.Checked)
{
using (SqlDataReader dr = WSCBank.BankFindName(conn, txtCriteria.Text, chkIsActive.Checked)) {
grdResults.DataSource = dr;
grdResults.DataBind();
}
}
else
{
if (txtCriteria.Text.Length > 0)
{
try {
Int32 tmp = Int32.Parse(txtCriteria.Text);
}
catch {
Common.AppHelper.ShowWarning(divWarning, "You did not enter a reasonable bank number.");
return;
}
}
using (SqlDataReader dr = WSCBank.BankFindNumber(conn, txtCriteria.Text, chkIsActive.Checked)) {
grdResults.DataSource = dr;
grdResults.DataBind();
}
}
}
}
catch (Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + "ShowBankResults", ex);
throw (wex);
}
}
protected void btnDeleteEquityBank_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnDeleteEquityBank_Click";
WSCSecurity auth = Globals.SecurityState;
if (auth.SecurityGroupName.ToUpper().IndexOf("AG ADMIN") == -1)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "Sorry, you are not authorized to update this information");
return;
}
int equityBankID = 0;
if (txtEquityBankID.Text.Length > 0)
{
equityBankID = Convert.ToInt32(txtEquityBankID.Text);
}
int addressID = 0;
if (txtAddressID.Text.Length > 0)
{
addressID = Convert.ToInt32(txtAddressID.Text);
}
int memberID = 0;
if (txtMemberID.Text.Length > 0)
{
memberID = Convert.ToInt32(txtMemberID.Text);
}
try {
int bankEquityLienID = 0;
if (txtBankEquityLienID.Text.Length > 0)
{
bankEquityLienID = Convert.ToInt32(txtBankEquityLienID.Text);
WSCBank.BankEquityDelete(bankEquityLienID);
}
// delete other year?
if (_otherYear > 0)
{
WSCBank.BankEquityDeleteOtherYear(equityBankID, memberID, _otherYear);
}
ClearEquityBankDetail();
SetAddEquityMode();
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
finally {
try {
if (txtAddressID.Text.Length > 0)
{
addressID = Convert.ToInt32(txtAddressID.Text);
}
ShowBankEquityList(memberID, _cropYear);
}
catch {
//NOP
}
}
}
protected void btnAddEquityBank_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnAdd_Click";
WSCSecurity auth = Globals.SecurityState;
if (auth.SecurityGroupName.ToUpper().IndexOf("AG ADMIN") == -1)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "Sorry, you are not authorized to update this information");
return;
}
int addressID = 0;
int memberID = 0;
try {
// Date required
string eqDate = txtEquityDate.Text;
if (eqDate == null || eqDate.Length == 0)
{
WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("You must enter a date.");
throw (warn);
}
if (!Common.CodeLib.IsDate(eqDate))
{
WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("You must enter a valid date (mm/dd/yyyy).");
throw (warn);
}
int bankEquityLienID = 0;
if (txtBankEquityLienID.Text.Length > 0)
{
bankEquityLienID = Convert.ToInt32(txtBankEquityLienID.Text);
}
if (txtAddressID.Text.Length > 0)
{
addressID = Convert.ToInt32(txtAddressID.Text);
}
if (txtMemberID.Text.Length > 0)
{
memberID = Convert.ToInt32(txtMemberID.Text);
}
int equityBankID = 0;
if (txtEquityBankID.Text.Length > 0)
{
equityBankID = Convert.ToInt32(txtEquityBankID.Text);
}
bool lienPatronShares = chkEqPatronStock.Checked;
bool lienPatronage = chkEqPatronage.Checked;
bool lienRetains = chkEqRetains.Checked;
bool releasePatronShares = chkReleasePatronStock.Checked;
bool releasePatronage = chkReleasePatronage.Checked;
bool releaseRetains = chkReleaseRetains.Checked;
int sequenceNo = 0;
bool isInsert = false;
if (bankEquityLienID == 0)
{
isInsert = true;
}
string userName = Globals.SecurityState.UserName;
WSCBank.BankEquitySave(ref bankEquityLienID, equityBankID, memberID,
sequenceNo, eqDate, lienPatronShares, lienPatronage, lienRetains,
releasePatronShares, releasePatronage, releaseRetains,
_cropYear, userName);
// add/update other year?
if (_otherYear > 0)
{
WSCBank.BankEquitySaveOtherYear(equityBankID, memberID,
eqDate, lienPatronShares, lienPatronage, lienRetains,
releasePatronShares, releasePatronage, releaseRetains,
Convert.ToInt32(_otherYear), isInsert, userName);
}
ClearEquityBankDetail();
SetAddEquityMode();
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
finally {
try {
ShowBankEquityList(memberID, _cropYear);
}
catch {
//NOP
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
const string METHOD_NAME = "btnAdd_Click";
WSCSecurity auth = Globals.SecurityState;
if (auth.SecurityGroupName.ToUpper().IndexOf("AG ADMIN") == -1)
{
Common.AppHelper.ShowWarning((HtmlGenericControl)Master.FindControl("divWarning"), "Sorry, you are not authorized to update this information");
return;
}
int addressID = 0;
try {
int bankPayeeID = 0;
if (txtBankPayeeID.Text.Length > 0)
{
bankPayeeID = Convert.ToInt32(txtBankPayeeID.Text);
}
if (txtAddressID.Text.Length > 0)
{
addressID = Convert.ToInt32(txtAddressID.Text);
}
int bankID = 0;
if (txtBankID.Text.Length > 0)
{
bankID = Convert.ToInt32(txtBankID.Text);
}
bool subRecd = chkSubordination.Checked;
int sequenceNo = 0;
bool isInsert = false;
if (bankPayeeID == 0)
{
WSCBank.BankPayeeSave(ref bankPayeeID, bankID, addressID,
sequenceNo, subRecd, _cropYear, Globals.SecurityState.UserName);
isInsert = true;
}
else
{
WSCBank.BankPayeeSetSub(bankPayeeID, subRecd,
Globals.SecurityState.UserName);
}
// add/update other year?
if (_otherYear > 0)
{
WSCBank.BankPayeeSaveOtherYear(bankID, addressID, subRecd,
Convert.ToInt32(_otherYear), isInsert, Globals.SecurityState.UserName);
}
ClearBankDetail();
SetAddMode();
}
catch (System.Exception ex) {
Common.CException wex = new Common.CException(MOD_NAME + METHOD_NAME, ex);
((PrimaryTemplate)Page.Master).ShowWarning(ex);
}
finally {
try {
ShowBankPayeeList(addressID, _cropYear);
}
catch {
//NOP
}
}
}
