protected void btnModifySave_Click(object sender, EventArgs e)
{
try
{
clsReasonView objReason = new clsReasonView();
objReason.ReasonID = txtModifyReasonId.Text.Trim();
objReason.ReasonDescr = txtModifyReasonDesc.Text.Trim();
objReason.ReasonType = cmbModifyReason_Type.SelectedValue.Trim();
objReason.CreatedBy = Session["uid"].ToString();
clsReasonViewHandler.InsertReasonDetails(objReason, "Update", "", ref strErrMsg, ref strSuccMsg, clsCommonHandler.PageName());
if (strErrMsg.Length >= 1)
{
lblEditMsg.Text = strErrMsg;
lblEditMsg.Visible = true;
mpEditReason.Show();
return;
}
else
{
lblMessages.Text = strSuccMsg;
lblMessages.Visible = true;
txtModifyReasonDesc.Text = "";
txtModifyReasonId.Text = "";
cmbModifyReason_Type.SelectedValue = "0";
bindDataGrid();
mpEditReason.Hide();
}
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName());
}
}
void bindDataGrid()
{
try
{
clsReasonView objReason = new clsReasonView();
objReason.RecID = "";
DataTable dt = clsReasonViewHandler.GetAllReason("AllReason", ref objReason);
gvReason.DataSource = dt;
gvReason.DataBind();
if (dt.Rows.Count != 0)
{
DropDownList ddl = (DropDownList)gvReason.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvReason.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvReason.PageIndex + 1).ToString();
Label lblcount = (Label)gvReason.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvReason.DataSource).Rows.Count.ToString() + " Records.";
if (gvReason.PageCount == 0)
{
((Button)gvReason.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvReason.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvReason.PageIndex + 1 == gvReason.PageCount)
{
((Button)gvReason.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvReason.PageIndex == 0)
{
((Button)gvReason.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvReason.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvReason.PageSize * gvReason.PageIndex) + 1) + " to " + (((gvReason.PageSize * (gvReason.PageIndex + 1)) - 10) + gvReason.Rows.Count);
gvReason.BottomPagerRow.Visible = true;
}
if (dt.Rows.Count != 0)
{
btnDelete.Enabled = true;
btnSearch.Enabled = true;
}
else
{
btnDelete.Enabled = false;
btnSearch.Enabled = false;
}
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName());
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
StringBuilder strXML = new StringBuilder();
strXML.Append("<ent_reason>");
int cnt = 0;
for (int i = 0; i < gvReason.Rows.Count; i++)
{
CheckBox chk = (CheckBox)gvReason.Rows[i].FindControl("DeleteRows");
if (chk.Checked == true)
{
cnt++;
strXML.Append("<Reason>");
strXML.Append("<reason_id>" + gvReason.Rows[i].Cells[2].Text + "</reason_id>");
lblMessages.Text = "Record(s) Deleted Successfully.";
lblMessages.Visible = true;
strXML.Append("</Reason>");
}
}
strXML.Append("</ent_reason>");
if (cnt >= 1)
{
clsReasonView objReason = new clsReasonView();
objReason.CreatedBy = Session["uid"].ToString();
clsReasonViewHandler.InsertReasonDetails(objReason, "Delete", strXML.ToString(), ref strErrMsg, ref strSuccMsg, clsCommonHandler.PageName());
if (strErrMsg.Length >= 1)
{
}
else
{
lblMessages.Text = strSuccMsg;
lblMessages.Visible = true;
}
}
bindDataGrid();
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName());
}
}
public void fillModifyReason(string Reasonid)
{
try
{
clsReasonView objReason = new clsReasonView();
objReason.RecID = Reasonid;
clsReasonViewHandler.GetAllReason("AllReason", ref objReason);
if (objReason != null)
{
cmbModifyReason_Type.SelectedValue = objReason.ReasonType;
txtModifyReasonId.Text = objReason.ReasonID;
txtModifyReasonDesc.Text = objReason.ReasonDescr;
}
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName());
}
}
protected void btnSubmitAdd_Click(object sender, EventArgs e)
{
try
{
clsReasonView objReason = new clsReasonView();
objReason.ReasonID = txtReason_ID.Text.Trim();
objReason.ReasonDescr = txtReason_Description.Text.Trim();
objReason.ReasonType = cmbReason_Type.SelectedValue.Trim();
objReason.CreatedBy = Session["uid"].ToString();
clsReasonViewHandler.InsertReasonDetails(objReason, "Insert", "", ref strErrMsg, ref strSuccMsg, clsCommonHandler.PageName());
if (strErrMsg.Length >= 1)
{
lblAddmsg.Visible = true;
lblAddmsg.Text = strErrMsg;
mpeAddreason.Show();
ScriptManager.RegisterClientScriptBlock(updatepanel3, updatepanel3.GetType(), "Script", "validateChosen();", true);
return;
}
else
{
lblAddmsg.Text = strSuccMsg;
txtReason_ID.Text = "";
txtReason_Description.Text = "";
cmbReason_Type.SelectedValue = "0";
lblAddmsg.Visible = true;
cmbReason_Type.Focus();
bindDataGrid();
mpeAddreason.Show();
ScriptManager.RegisterClientScriptBlock(updatepanel3, updatepanel3.GetType(), "Script", "validateChosen();", true);
}
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName());
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
clsReasonView objReason = new clsReasonView();
objReason.RecID = "";
DataTable dt = clsReasonViewHandler.GetAllReason("AllReason", ref objReason);
if (textreasonid.Text.ToString() == "" && textreasonname.Text.ToString() == "")
{
gvReason.DataSource = dt;
gvReason.DataBind();
}
else
{
String[,] values =
{
{ "Reason_ID~" + textreasonid.Text.Trim(), "S" },
{ "Reason_Description~" + textreasonname.Text.Trim(), "S" }
};
DataTable _tempDT = new DataTable();
Search _sc = new Search();
if (_tempDT != null)
{
_tempDT.Rows.Clear();
}
_tempDT = _sc.searchTable(values, dt);
gvReason.DataSource = _tempDT;
gvReason.DataBind();
}
DropDownList ddl = (DropDownList)gvReason.BottomPagerRow.FindControl("ddlPageNo");
for (int i = 1; i <= gvReason.PageCount; i++)
{
ddl.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
ddl.SelectedValue = (gvReason.PageIndex + 1).ToString();
Label lblcount = (Label)gvReason.BottomPagerRow.FindControl("lblTotal");
lblcount.Text = ((DataTable)gvReason.DataSource).Rows.Count.ToString() + " Records.";
if (gvReason.PageCount == 0)
{
((Button)gvReason.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
((Button)gvReason.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvReason.PageIndex + 1 == gvReason.PageCount)
{
((Button)gvReason.BottomPagerRow.FindControl("btnNext")).Enabled = false;
}
if (gvReason.PageIndex == 0)
{
((Button)gvReason.BottomPagerRow.FindControl("btnPrevious")).Enabled = false;
}
((Label)gvReason.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvReason.PageSize * gvReason.PageIndex) + 1) + " to " + (((gvReason.PageSize * (gvReason.PageIndex + 1)) - 10) + gvReason.Rows.Count);
gvReason.BottomPagerRow.Visible = true;
}
catch (Exception ex)
{
UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName());
}
}
