/*This is the confirm deletion button which actually deletes the row in the database and displays
* the updated table*/
protected void DeleteAccountButton_Click(object sender, EventArgs e)
{
bool returnValue;
long accountToBeDeleted = GetSelectedRecord();
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();
returnValue = sc.DeleteAccount(accountToBeDeleted);
if (returnValue)
{
Label2.Text = "Account deleted successfully";
DataSet ds = sc.GetCustomerId(int.Parse(CustomerIdTextBox.Text));
//This if-else displays the updated table after deletion
if (ds.Tables[0].Rows.Count == 0)
{
Label2.Text = "No Accounts available";
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
{
Label2.Text = "Accounts available are";
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
else
{
Label2.Text = "Account not deleted!!";
}
}
/*This is the confirm deletion button which actually deletes the row in the database and displays
* the updated table*/
protected void DeleteAccountButton_Click(object sender, EventArgs e)
{
bool returnValue;
long accountToBeDeleted = GetSelectedRecord();
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();
returnValue = sc.DeleteAccount(accountToBeDeleted);
if (returnValue)
{
Label2.Text = Resources.Resource.accountDeleted;
IList <Account> aobj = sc.GetCustomerId(int.Parse(CustomerIdTextBox.Text));
//This if-else displays the updated table after deletion
if (aobj.Count == 0)
{
Label2.Text = Resources.Resource.accountNotFound;
GridView1.DataSource = aobj;
GridView1.DataBind();
}
else
{
Label2.Text = Resources.Resource.accountFound;
GridView1.DataSource = aobj;
GridView1.DataBind();
}
}
else
{
Label2.Text = Resources.Resource.accountNotDeleted;
}
}
/*This function takes customer Id entered in the text box and on clicking the button all available accounts for
* the corresponding customer Id is displayed by recieving a DataSet and filling the GridView*/
protected void SubmitButton_Click(object sender, EventArgs e)
{
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();
IList <Account> aobj = sc.GetCustomerId(int.Parse(CustomerIdTextBox.Text));
int rows = aobj.Count;
if (rows == 0)
{
Label2.Text = Resources.Resource.customerNotExists;
GridView1.DataSource = aobj;
GridView1.DataBind();
AddButton.Visible = false;
EditButton.Visible = false;
DeleteButton.Visible = false;
}
else if (int.Parse(aobj[0].customerId.ToString()) == int.Parse(CustomerIdTextBox.Text.ToString()) && aobj[0].accountNo != 0)
{
Label2.Text = Resources.Resource.accountFound;
GridView1.DataSource = aobj;
GridView1.DataBind();
AddButton.Visible = true;
EditButton.Visible = true;
DeleteButton.Visible = true;
}
else
{
Label2.Text = Resources.Resource.customerExists;
AddButton.Visible = true;
EditButton.Visible = false;
DeleteButton.Visible = false;
}
}
/*This button is pressed after all the edited values are entered and then they are updated in the database.
* The updated table is displayed again*/
protected void EditedDetailsSubmitButton_Click(object sender, EventArgs e)
{
bool returnValue;
Account editedAccount = new Account();
editedAccount.customerId = int.Parse(CustomerIdTextBox.Text);
editedAccount.accountType = AccountTypeTextBox.Text;
editedAccount.DateOfOpen = DateOfOpeneningTextBox.Text;
editedAccount.status = StatusTextBox.Text;
editedAccount.dateOfEdited = DateTime.Today.ToString("dd-MM-yyyy");
editedAccount.ClosingDate = ClosingDateTextBox.Text;
editedAccount.amount = int.Parse(AmountTextBox.Text);
editedAccount.accountNo = GetSelectedRecord();
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();
returnValue = sc.EditAccount(editedAccount);
if (returnValue)
{
Label2.Text = "Account Edited successfully";
DataSet ds = sc.GetCustomerId(int.Parse(CustomerIdTextBox.Text));
//This if-else is to display the updated table to the manager/staff
if (ds.Tables[0].Rows.Count == 0)
{
Label2.Text = "No Accounts available";
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
{
Label2.Text = "Accounts available are";
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
else
{
Label2.Text = "Account not edited!!";
}
}
/*This button is clicked after selecting one of the radio buttons. It checks which radio button is selected and
* then displays the corresponding text boxes forthe managers/staff to enter edited values. This function popualtes
* the previous values first into the text boxes and then the manager/staff can change those values */
protected void EditButton_Click(object sender, EventArgs e)
{
long selectedRecord;
selectedRecord = GetSelectedRecord();
if (selectedRecord == 0)
{
Label2.Text = "Please select an account to edit!!";
}
//Making all fields visible
else
{
Label2.Text = selectedRecord + "";
AccountTypeLabel.Visible = true;
AccountTypeTextBox.Visible = true;
DateOfOpeneningLabel.Visible = true;
DateOfOpeneningTextBox.Visible = true;
StatusLabel.Visible = true;
StatusTextBox.Visible = true;
DateOfEditedLabel.Visible = true;
DateOfEditedTextBox.Visible = true;
ClosingDateLabel.Visible = true;
ClosingDateTextBox.Visible = true;
AmountLabel.Visible = true;
AmountTextBox.Visible = true;
EditedDetailsSubmitButton.Visible = true;
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();
DataSet ds = sc.GetCustomerId(int.Parse(CustomerIdTextBox.Text));
//This is to populate existing values into text boxes
AccountTypeTextBox.Text = ds.Tables[0].Rows[i]["accountType"].ToString();
DateOfOpeneningTextBox.Text = ds.Tables[0].Rows[i]["DateOfOpen"].ToString();
StatusTextBox.Text = ds.Tables[0].Rows[i]["status"].ToString();
DateOfEditedTextBox.Text = ds.Tables[0].Rows[i]["dateOfEdited"].ToString();
ClosingDateTextBox.Text = ds.Tables[0].Rows[i]["ClosingDate"].ToString();
AmountTextBox.Text = ds.Tables[0].Rows[i]["amount"].ToString();
}
}
/*This button is pressed after all the edited values are entered and then they are updated in the database.
* The updated table is displayed again*/
protected void EditedDetailsSubmitButton_Click(object sender, EventArgs e)
{
bool returnValue;
Account editedAccount = new Account();
editedAccount.customerId = int.Parse(CustomerIdTextBox.Text);
editedAccount.accountType = AccountTypeTextBox.Text;
editedAccount.DateOfOpen = DateOfOpeneningTextBox.Text;
editedAccount.status = StatusTextBox.Text;
editedAccount.dateOfEdited = DateTime.Today.ToString("dd-MM-yyyy");
editedAccount.ClosingDate = ClosingDateTextBox.Text;
editedAccount.amount = int.Parse(AmountTextBox.Text);
editedAccount.accountNo = GetSelectedRecord();
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();
returnValue = sc.EditAccount(editedAccount);
if (returnValue)
{
Label2.Text = Resources.Resource.accountEdited;
IList <Account> aobj = sc.GetCustomerId(int.Parse(CustomerIdTextBox.Text));
//This if-else is to display the updated table to the manager/staff
if (aobj.Count == 0)
{
Label2.Text = Resources.Resource.accountNotFound;
GridView1.DataSource = aobj;
GridView1.DataBind();
}
else
{
Label2.Text = Resources.Resource.accountFound;
GridView1.DataSource = aobj;
GridView1.DataBind();
}
}
else
{
Label2.Text = Resources.Resource.accountNotEdited;
}
}
/*This button is clicked after selecting one of the radio buttons. It checks which radio button is selected and
* then displays the corresponding text boxes forthe managers/staff to enter edited values. This function popualtes
* the previous values first into the text boxes and then the manager/staff can change those values */
protected void EditButton_Click(object sender, EventArgs e)
{
long selectedRecord;
selectedRecord = GetSelectedRecord();
if (selectedRecord == 0)
{
Label2.Text = Resources.Resource.accountError;
}
//Making all fields visible
else
{
Label2.Text = selectedRecord + "";
AccountTypeLabel.Visible = true;
AccountTypeTextBox.Visible = true;
DateOfOpeneningLabel.Visible = true;
DateOfOpeneningTextBox.Visible = true;
StatusLabel.Visible = true;
StatusTextBox.Visible = true;
DateOfEditedLabel.Visible = true;
DateOfEditedTextBox.Visible = true;
ClosingDateLabel.Visible = true;
ClosingDateTextBox.Visible = true;
AmountLabel.Visible = true;
AmountTextBox.Visible = true;
//EditedDetailsSubmitButton.Visible = true;
DetailsSubmitButton.Visible = false;
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();
IList <Account> aobj = sc.GetCustomerId(int.Parse(CustomerIdTextBox.Text));
//This is to populate existing values into text boxes
AccountTypeTextBox.Text = aobj[0].accountType.ToString();
DateOfOpeneningTextBox.Text = aobj[0].DateOfOpen.ToString();
StatusTextBox.SelectedValue = aobj[0].status;
DateOfEditedTextBox.Text = aobj[0].dateOfEdited.ToString();
ClosingDateTextBox.Text = aobj[0].ClosingDate.ToString();
AmountTextBox.Text = aobj[0].amount.ToString();
}
}
/*This function takes customer Id entered in the text box and on clicking the button all available accounts for
* the corresponding customer Id is displayed by recieving a DataSet and filling the GridView*/
protected void SubmitButton_Click(object sender, EventArgs e)
{
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();
DataSet ds = sc.GetCustomerId(int.Parse(CustomerIdTextBox.Text));
if (ds.Tables[0].Rows.Count == 0)
{
Label2.Text = "No Accounts available";
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
{
Label2.Text = "Accounts available are";
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
/*This button is displayed at the end, when all text boxes are filled and the manager/staff wants to add the
* all the values in the text boxes into the database */
protected void DetailsSubmitButton_Click(object sender, EventArgs e)
{
bool returnValue;
string[] Details = { CustomerIdTextBox.Text,
AccountTypeTextBox.Text,
DateTime.Today.ToString("dd-MM-yyyy"),
StatusTextBox.Text,
DateTime.Today.ToString("dd-MM-yyyy"),
ClosingDateTextBox.Text,
AmountTextBox.Text };
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();
returnValue = sc.AddAccount(Details);
if (returnValue)
{
Label2.Text = "Account Added successfully";
//This is to display updated gridview after insertion
DataSet ds = sc.GetCustomerId(int.Parse(CustomerIdTextBox.Text));
if (ds.Tables[0].Rows.Count == 0)
{
Label2.Text = "No Accounts available";
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
{
Label2.Text = "Accounts available are";
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
else
{
Label2.Text = "Account not Added";
}
}
/*This button is displayed at the end, when all text boxes are filled and the manager/staff wants to add the
* all the values in the text boxes into the database */
protected void DetailsSubmitButton_Click(object sender, EventArgs e)
{
bool returnValue;
string[] Details = { CustomerIdTextBox.Text,
AccountTypeTextBox.Text,
DateTime.Today.ToString("dd-MM-yyyy"),
StatusTextBox.Text,
DateTime.Today.ToString("dd-MM-yyyy"),
ClosingDateTextBox.Text,
AmountTextBox.Text };
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();
returnValue = sc.AddAccount(Details);
if (returnValue)
{
Label2.Text = Resources.Resource.accountAdded;
//This is to display updated gridview after insertion
IList <Account> aobj = sc.GetCustomerId(int.Parse(CustomerIdTextBox.Text));
if (aobj.Count == 0)
{
Label2.Text = Resources.Resource.accountNotFound;
GridView1.DataSource = aobj;
GridView1.DataBind();
}
else
{
Label2.Text = Resources.Resource.accountFound;
GridView1.DataSource = aobj;
GridView1.DataBind();
}
}
else
{
Label2.Text = Resources.Resource.accountNotAdded;
}
}
/*This method is called whenever we need to check which radio button is selected and returns the account number
* of the selected row */
private long GetSelectedRecord()
{
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();
for (i = 0; i < GridView1.Rows.Count; i++)
{
RadioButton rb = (RadioButton)GridView1.Rows[i].Cells[0].FindControl("RadioButton1");
if (rb != null)
{
if (rb.Checked)
{
DataSet ds = sc.GetCustomerId(int.Parse(CustomerIdTextBox.Text));
//Returning the account number of selected row
return((long)ds.Tables[0].Rows[i]["accountNo"]);
}
}
}
return(0);
}
/*This method is called whenever we need to check which radio button is selected and returns the account number
* of the selected row */
private long GetSelectedRecord()
{
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();
for (i = 0; i < GridView1.Rows.Count; i++)
{
RadioButton rb = (RadioButton)GridView1.Rows[i].Cells[0].FindControl("RadioButton1");
if (rb != null)
{
if (rb.Checked)
{
IList <Account> aobj = sc.GetCustomerId(int.Parse(CustomerIdTextBox.Text));
//Returning the account number of selected row
return(long.Parse(aobj[0].accountNo.ToString()));
}
}
}
return(0);
}
/*This function takes customer Id entered in the text box and on clicking the button all available accounts for
* the corresponding customer Id is displayed by recieving a DataSet and filling the GridView*/
protected void SubmitButton_Click(object sender, EventArgs e)
{
try
{
ServiceReference1.Service1Client sc = new ServiceReference1.Service1Client();
IList <Account> aobj = sc.GetCustomerId(int.Parse(CustomerIdTextBox.Text));
int rows = aobj.Count;
if (rows == 0)
{
Label2.Text = "No Accounts available for the given customer id.Add a new Customer and come back";
GridView1.DataSource = aobj;
GridView1.DataBind();
AddButton.Visible = false;
EditButton.Visible = false;
DeleteButton.Visible = false;
}
else if (int.Parse(aobj[0].customerId.ToString()) == int.Parse(CustomerIdTextBox.Text))
{
Label2.Text = "Customer Already exists!! Add a New Account";
AddButton.Visible = true;
EditButton.Visible = false;
DeleteButton.Visible = false;
}
else
{
Label2.Text = "Accounts available are";
GridView1.DataSource = aobj;
GridView1.DataBind();
AddButton.Visible = true;
EditButton.Visible = true;
DeleteButton.Visible = true;
}
}
catch (Exception exc)
{
Label3.Text = "Enter valid Details!!";
}
}
