/// <summary>
/// Update FinancialInstituion() is a function which takes FinancialInstituionBO as parameter and update its data in database.
/// It returns the number of rows affected by the operation which is 1 in success and 0 in failure.
/// </summary>
/// <param name="financialInstitutionBO">An object of FinancialInstitutionBO class which is used to hold the name and id of Financia lInstitution.</param>
/// <returns>int</returns>
public int UpdateFinancialInstitution(FinancialInstitutionBO financialInstitutionBO)
{
SQLHelper helper = SQLHelper.GetInstance(this.connectionString);
int numberOfRowImpacted = 0;
try
{
helper.OpenConnection();
query = @"
UPDATE [dbo].[FinancialInstitutionMaster]
SET [FinancialInstitutionName] = '" + financialInstitutionBO.FinancialInstitutionName + @"',
[FinancialInstitutionAddress = '" + financialInstitutionBO.FinancialInstitutionAddress + @"'
WHERE [FinancialInstitutionID] = " + financialInstitutionBO.FinancialInstitutionCD;
numberOfRowImpacted = helper.ExecuteNonQuery(query);
}
catch (Exception ex)
{
numberOfRowImpacted = -1;
}
finally
{
helper.CloseConnection();
}
return(numberOfRowImpacted);
}
public string GetFinancialInstitution(FinancialInstitutionBO financialInstitutionBO)
{
SQLHelper helper = SQLHelper.GetInstance(this.connectionString);
try
{
helper.OpenConnection();
query = @"
SELECT [FinancialInstitutionID] as FinancialInstitutionCD
,[FinancialInstitutionName] as FinancialInstitutionName
,[FinancialInstitutionAddress] as FinancialInstitutionAddress
FROM [dbo].[FinancialInstitutionMaster]
WHERE [FinancialInstitutionID] = " + financialInstitutionBO.FinancialInstitutionCD;
ds = helper.ExecuteDataSet(query);
}
catch (Exception ex)
{
string err = ex.Message;
}
finally
{
helper.CloseConnection();
}
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
return(StringUtil.SerializeObjectToJSON(ds.Tables[0]));
}
else
{
return("DB_ERROR : " + dbErrMsg);
}
}
public int RemoveFinancialInstitution(FinancialInstitutionBO financialInstitutionBO)
{
SQLHelper helper = SQLHelper.GetInstance(this.connectionString);
int numberOfRowImpacted = 0;
try
{
helper.OpenConnection();
query = @"
DELETE FROM [dbo].[FinancialInstitutionMaster]
WHERE [FinancialInstitutionID] = "
+ financialInstitutionBO.FinancialInstitutionCD;
numberOfRowImpacted = helper.ExecuteNonQuery(query);
}
catch (Exception ex)
{
numberOfRowImpacted = -1;
}
finally
{
helper.CloseConnection();
}
return(numberOfRowImpacted);
}
/// <summary>
///
/// </summary>
/// <param name="financialInstitutionBO"></param>
/// <returns>int</returns>
public int AddFinancialInstitution(FinancialInstitutionBO financialInstitutionBO)
{
SQLHelper helper = SQLHelper.GetInstance(this.connectionString);
int numberOfRowImpacted = 0;
try
{
helper.OpenConnection();
query = @"
INSERT INTO [dbo].[FinancialInstitutionMaster]
([FinancialInstitutionName],[FinancialInstitutionAddress] )
VALUES ('"
+ financialInstitutionBO.FinancialInstitutionName + @"', '"
+ financialInstitutionBO.FinancialInstitutionAddress +
@"')";
numberOfRowImpacted = helper.ExecuteNonQuery(query);
}
catch (Exception ex)
{
numberOfRowImpacted = -1;
}
finally
{
helper.CloseConnection();
}
return(numberOfRowImpacted);
}
public static bool UpdateFinancialInstitution(FinancialInstitutionBO financialInstitutionBO)
{
DeptDesigAndFinInstitutionDAS deptDesigAndFinInstitutionDAS = new DeptDesigAndFinInstitutionDAS();
int numberOfRowImpacted = 0;
numberOfRowImpacted = deptDesigAndFinInstitutionDAS.UpdateFinancialInstitution(financialInstitutionBO);
return(numberOfRowImpacted > 0);
}
private bool DeleteAction()
{
bool result = false;
switch (this.SelectedTypeCode)
{
case "DT":
DepartmentBO department = new DepartmentBO();
department.DepartmentCD = this.RequestCode;
result = DeptDesigAndFinInstitutionBusController.RemoveDepartment(department);
if (result)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Department Deleted Successfully')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Department Not Deleted. Some Problem Occurred')", true);
}
this.SelectedTypeCode = null;
break;
case "DS":
DesignationBO designation = new DesignationBO();
designation.DesignationCD = this.RequestCode;
result = DeptDesigAndFinInstitutionBusController.RemoveDesignation(designation);
if (result)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Deleted Successfully')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Not Deleted. Some Problem Occurred')", true);
}
this.SelectedTypeCode = null;
break;
case "FI":
FinancialInstitutionBO financialInstitution = new FinancialInstitutionBO();
financialInstitution.FinancialInstitutionCD = this.RequestCode;
result = DeptDesigAndFinInstitutionBusController.RemoveFinancialInstitution(financialInstitution);
if (result)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Financial Institution Deleted Successfully')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Financial Institution Not Deleted. Some Problem Occurred')", true);
}
this.SelectedTypeCode = null;
break;
default:
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Bad Request.')", true);
break;
}
return(result);
}
public static FinancialInstitutionBO GetFinancialInstitutionBO(FinancialInstitutionBO financialInstitutionBO)
{
DeptDesigAndFinInstitutionDAS deptDesigAndFinInstitutionDAS = new DeptDesigAndFinInstitutionDAS();
string jsondata = deptDesigAndFinInstitutionDAS.GetFinancialInstitution(financialInstitutionBO);
List <FinancialInstitutionBO> financialInstitutionBOs;
if (!jsondata.StartsWith("DB_ERROR"))
{
financialInstitutionBOs = StringUtil.DeserializeObjectFromJSON <List <FinancialInstitutionBO> >(jsondata);
financialInstitutionBO = financialInstitutionBOs.ElementAt(0);
}
return(financialInstitutionBO);
}
public static bool IsFinancialInstitutionPresent(FinancialInstitutionBO financialInstitution)
{
DeptDesigAndFinInstitutionDAS deptDesigAndFinInstitutionDAS = new DeptDesigAndFinInstitutionDAS();
string jsondata = deptDesigAndFinInstitutionDAS.GetFinancialInstitution(financialInstitution);
if (!jsondata.StartsWith("DB_ERROR"))
{
return(true);
}
else
{
return(false);
}
}
private void EditAction()
{
string postbackurl = ResourceTable("PageURL");
switch (this.SelectedTypeCode)
{
case "DT":
DepartmentBO department = new DepartmentBO();
department.DepartmentCD = this.RequestCode;
department = DeptDesigAndFinInstitutionBusController.GetDepartmentBO(department);
lbl_Dept_title.Text = ResourceTable("EditDept");
this.txtDeptName.Text = department.DepartmentName;
this.txtBankAcc.Text = department.DepartmentBankAccount;
postbackurl += "?CD=" + StringUtil.Encode(department.DepartmentCD);
this.btnAddDept.PostBackUrl = postbackurl;
this.btnAddDept.Text = ResourceTable("StringUpdate");
break;
case "DS":
DesignationBO designation = new DesignationBO();
designation.DesignationCD = this.RequestCode;
designation = DeptDesigAndFinInstitutionBusController.GetDesignationBO(designation);
lbl_Desig_title.Text = ResourceTable("EditDesig");
this.txtDesigName.Text = designation.DesignationName;
postbackurl += "?CD=" + StringUtil.Encode(designation.DesignationCD);
this.btnDesigAdd.PostBackUrl = postbackurl;
this.btnDesigAdd.Text = ResourceTable("StringUpdate");
break;
case "FI":
FinancialInstitutionBO financialInstitution = new FinancialInstitutionBO();
financialInstitution.FinancialInstitutionCD = this.RequestCode;
financialInstitution = DeptDesigAndFinInstitutionBusController.GetFinancialInstitutionBO(financialInstitution);
lbl_Fin_title.Text = ResourceTable("EditFin");
this.txtFinInstName.Text = financialInstitution.FinancialInstitutionName;
this.txtFinInstAddress.Text = financialInstitution.FinancialInstitutionAddress;
postbackurl += "?CD=" + StringUtil.Encode(financialInstitution.FinancialInstitutionCD);
this.btnFinInstAdd.PostBackUrl = postbackurl;
this.btnFinInstAdd.Text = ResourceTable("StringUpdate");
break;
default:
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Bad Request.')", true);
break;
}
}
protected void btnFinInstAdd_Click(object sender, EventArgs e)
{
FinancialInstitutionBO financialInstitution = new FinancialInstitutionBO();
if (this.RequestCode != null)
{
financialInstitution.FinancialInstitutionCD = this.RequestCode;
if (DeptDesigAndFinInstitutionBusController.IsFinancialInstitutionPresent(financialInstitution))
{
financialInstitution.FinancialInstitutionName = this.txtFinInstName.Text;
financialInstitution.FinancialInstitutionAddress = this.txtFinInstAddress.Text;
bool result = DeptDesigAndFinInstitutionBusController.UpdateFinancialInstitution(financialInstitution);
if (result)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Financial Institution Updated Successfully')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Financial Institution Not Updated. Some Problem Occurred')", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Bad Request.')", true);
}
}
else
{
financialInstitution.FinancialInstitutionName = this.txtFinInstName.Text;
financialInstitution.FinancialInstitutionAddress = this.txtFinInstAddress.Text;
bool result = DeptDesigAndFinInstitutionBusController.AddFinancialInstitution(financialInstitution);
if (result)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Financial Institution Added Successfully')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Financial Institution Not Added. Some Problem Occurred')", true);
}
}
}
