public string GetDesignation(DesignationBO designationBO)
{
SQLHelper helper = SQLHelper.GetInstance(this.connectionString);
try
{
helper.OpenConnection();
query = @"
SELECT [DesignationID] as DesignationCD,[DesignationName] as DesignationName
FROM [dbo].[DesignationMaster]
WHERE [DesignationID] = " + designationBO.DesignationCD;
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);
}
}
/// <summary>
/// UpdateDesignation() is a function which takes DesignationBO 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="designationBO">An object of DesignationBO class which is used to hold the name and id of designation.</param>
/// <returns>int</returns>
public int UpdateDesignation(DesignationBO designationBO)
{
SQLHelper helper = SQLHelper.GetInstance(this.connectionString);
int numberOfRowImpacted = 0;
try
{
helper.OpenConnection();
query = @"
UPDATE [dbo].[DesignationMaster]
SET [DesignationName] = '" + designationBO.DesignationName + @"'
WHERE [DesignationID] = " + designationBO.DesignationCD;
numberOfRowImpacted = helper.ExecuteNonQuery(query);
}
catch (Exception ex)
{
numberOfRowImpacted = -1;
}
finally
{
helper.CloseConnection();
}
return(numberOfRowImpacted);
}
/// <summary>
/// AddDesignation() is a function which takes DesignationBO as parameter and insert 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="designationBO">An object of DesignationBO class which is used to hold the name and id of designation.</param>
/// <returns>int</returns>
public int AddDesignation(DesignationBO designationBO)
{
SQLHelper helper = SQLHelper.GetInstance(this.connectionString);
int numberOfRowImpacted = 0;
try
{
helper.OpenConnection();
query = @"
INSERT INTO [dbo].[DesignationMaster]
([DesignationID],[DesignationName])
VALUES (
CAST((SELECT TOP 1 d.[DesignationID] FROM [DesignationMaster] as d ORDER BY CAST(d.[DesignationID] as int) DESC)+1 as varchar),'"
+ designationBO.DesignationName +
@"')";
numberOfRowImpacted = helper.ExecuteNonQuery(query);
}
catch (Exception ex)
{
numberOfRowImpacted = -1;
}
finally
{
helper.CloseConnection();
}
return(numberOfRowImpacted);
}
public static bool UpdateDesignation(DesignationBO designationBO)
{
DeptDesigAndFinInstitutionDAS deptDesigAndFinInstitutionDAS = new DeptDesigAndFinInstitutionDAS();
int numberOfRowImpacted = 0;
numberOfRowImpacted = deptDesigAndFinInstitutionDAS.UpdateDesignation(designationBO);
return(numberOfRowImpacted > 0);
}
/// <summary>
/// To Update details of Designation in tbl_Designation_M table
/// Created By : Darshan, 09/15/2014
/// Modified By :
/// </summary>
/// <param name="objDesignationBO"></param>
/// <returns></returns>
public ApplicationResult Designation_Update(DesignationBO objDesignationBO)
{
try
{
pSqlParameter = new SqlParameter[6];
pSqlParameter[0] = new SqlParameter("@DesignationID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objDesignationBO.DesignationID;
pSqlParameter[1] = new SqlParameter("@DesignationNameENG", SqlDbType.VarChar);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objDesignationBO.DesignationNameENG;
pSqlParameter[2] = new SqlParameter("@DesignationNameGUJ", SqlDbType.NVarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objDesignationBO.DesignationNameGUJ;
pSqlParameter[3] = new SqlParameter("@Description", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objDesignationBO.Description;
pSqlParameter[4] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objDesignationBO.LastModifiedUserID;
pSqlParameter[5] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objDesignationBO.LastModifiedDate;
sSql = "usp_tbl_Designation_M_Update";
int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objDesignationBO = null;
}
}
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 DesignationBO GetDesignationBO(DesignationBO designationBO)
{
DeptDesigAndFinInstitutionDAS deptDesigAndFinInstitutionDAS = new DeptDesigAndFinInstitutionDAS();
string jsondata = deptDesigAndFinInstitutionDAS.GetDesignation(designationBO);
List <DesignationBO> designationBOs;
if (!jsondata.StartsWith("DB_ERROR"))
{
designationBOs = StringUtil.DeserializeObjectFromJSON <List <DesignationBO> >(jsondata);
designationBO = designationBOs.ElementAt(0);
}
return(designationBO);
}
public static bool IsDesignationPresent(DesignationBO designation)
{
DeptDesigAndFinInstitutionDAS deptDesigAndFinInstitutionDAS = new DeptDesigAndFinInstitutionDAS();
string jsondata = deptDesigAndFinInstitutionDAS.GetDesignation(designation);
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 btnDesigAdd_Click(object sender, EventArgs e)
{
DesignationBO designation = new DesignationBO();
if (this.RequestCode != null)
{
designation.DesignationCD = this.RequestCode;
if (DeptDesigAndFinInstitutionBusController.IsDesignationPresent(designation))
{
designation.DesignationName = txtDesigName.Text;
bool result = DeptDesigAndFinInstitutionBusController.UpdateDesignation(designation);
if (result)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Updated Successfully')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Not Updated. Some Problem Occurred')", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Bad Request.')", true);
}
}
else
{
designation.DesignationName = txtDesigName.Text;
bool result = DeptDesigAndFinInstitutionBusController.AddDesignaion(designation);
if (result)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Added Successfully')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Designation Not Added. Some Problem Occurred')", true);
}
}
this.SelectedTypeCode = null;
ShowDiv();
}
protected void btnSaveClass_OnClick(object sender, EventArgs e)
{
try
{
DesignationBO objDesignationBO = new DesignationBO();
DesignationBL objDesignationBL = new DesignationBL();
ApplicationResult objResult = new ApplicationResult();
DataTable dtResult = new DataTable();
int intDesignationID = 0;
objDesignationBO.DesignationNameENG = txtDesignationNameENG.Text.Trim();
objDesignationBO.DesignationNameGUJ = txtDesignationNameGUJ.Text.Trim();
objDesignationBO.Description = txtDescription.Text.Trim();
objDesignationBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objDesignationBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
//Code For Validate Designation Name
if (ViewState["Mode"].ToString() == "Save")
{
intDesignationID = -1;
}
else if (ViewState["Mode"].ToString() == "Edit")
{
intDesignationID = Convert.ToInt32(ViewState["DesignationID"].ToString());
}
objResult = objDesignationBL.Designation_ValidateName(intDesignationID, objDesignationBO.DesignationNameENG);
if (objResult != null)
{
dtResult = objResult.resultDT;
if (dtResult.Rows.Count > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Designation name already exist.');</script>");
}
else
{
if (ViewState["Mode"].ToString() == "Save")
{
objDesignationBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objDesignationBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResult = objDesignationBL.Designation_Insert(objDesignationBO);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record saved successfully.');</script>");
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objDesignationBO.DesignationID = Convert.ToInt32(ViewState["DesignationID"].ToString());
objResult = objDesignationBL.Designation_Update(objDesignationBO);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>");
}
}
ClearAll();
BindDesignation();
PanelVisibility(1);
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
public int Put([FromBody] DesignationBO value)
{
return(_iDesignationBL.UpdateDesignation(value));
}
// POST api/values
public int Post([FromBody] DesignationBO value)
{
return(_iDesignationBL.AddDesignation(value));
}
