protected void Page_Load(object sender, EventArgs e)
{
try
{
//ddlSelDocBoy.Items.Insert(0, new ListItem("--Select--", "-1"));
if ((HttpContext.Current.Session["LoginId"]) == null)
{
Response.Redirect("~/Login.aspx");
}
if (!Page.IsPostBack)
{
lblPrjId.Text = Session["ProjectID"].ToString();
txtDate.Text = DateTime.Now.Date.ToShortDateString();
BLDocumentBoy blObjDocB = new BLDocumentBoy();
SqlDataReader dr = blObjDocB.getDocumentBoy1();
ddlSelDocBoy.Items.Clear();
ddlSelDocBoy.Items.Insert(0, new ListItem("--Select--", "-1"));
if (dr.HasRows)
{
while (dr.Read())
{
string strcode = dr.GetString(1);
string strname = dr.GetString(2);
string strCodeName = strcode + " - " + strname;
ddlSelDocBoy.Items.Add(strCodeName);
}
}
else
{
lblCatchError.Text = "";
}
dr.Close();
fillgridDocBoyHistory();
fillgridDocBoyHistoryDetails();
}
else
{
lblresult.Text = "";
lblresult1.Text = "";
lblCatchError.Text = "";
lblErrorMsg.Text = "";
}
}
catch (Exception ex)
{
lblCatchError.Text = ex.Message.ToString();
}
}
protected void GdVwViewDocumentBoy_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
BLDocumentBoy blc = new BLDocumentBoy();
if (e.CommandName == "Editdocboy")
{
GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer;
int rowIndex = gvr.RowIndex;
int DocBoyId = Convert.ToInt32(GdVwViewDocumentBoy.Rows[rowIndex].Cells[1].Text);
Session["DocBoyId"] = DocBoyId;
SqlDataReader dr2 = blc.getDocBoyDetailsForUpdate1(DocBoyId);
if (dr2.HasRows == true)
{
while (dr2.Read())
{
txtCodeDocBoy.Enabled = false;
txtNameDocBoy.Enabled = false;
btnClearDocBoy.Enabled = false;
txtNameDocBoy.Text = dr2.GetString(1);
txtMobileDocBoy.Text = dr2.GetString(2);
txtCodeDocBoy.Text = dr2.GetString(4);
if (dr2["MailID"] == DBNull.Value)
{
txtMailIDDocBoy.Text = "";
}
else
{
txtMailIDDocBoy.Text = dr2.GetString(6);
}
bool isdel = dr2.GetBoolean(3);
if (isdel == true)
rbYesIsDelDocBoy.Checked = true;
else
rbNoIsDelDocBoy.Checked = true;
int approve = dr2.GetInt32(5);
if (approve == 1)
ChkBxApprovDocBoy.Checked = true;
else
ChkBxApprovDocBoy.Checked = false;
if (txtMobileDocBoy.Text == "-")
{
txtMobileDocBoy.Text = "";
}
}
dr2.Close();
}
}
}
catch (Exception ex)
{
lblCatchError.Text = ex.Message.ToString();
}
}
protected void ddlDocBoy_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
BLDocumentBoy bldb = new BLDocumentBoy();
string strName = Convert.ToString(ddlDocBoy.SelectedItem.Text);
SqlDataReader dr = bldb.getDocBoyCode1(strName);
if (dr.HasRows == true)
{
while (dr.Read())
txtCode1.Text = dr.GetString(1);
dr.Close();
}
if (ddlDocBoy.SelectedItem.Text == "--Select--")
{
txtCode1.Text = "";
}
SqlConnection con = new SqlConnection(connstr);
SqlCommand cmd = new SqlCommand();
SqlParameter param;
//DataSet ds = new DataSet();
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "getDocBoyCode";
param = new SqlParameter("@Name", ddlDocBoy.SelectedItem.Text);
param.Direction = ParameterDirection.Input;
param.DbType = DbType.String;
cmd.Parameters.Add(param);
da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds.Tables[0].Rows.Count != 0)
{
GdVwViewDocumentBoy.DataSource = ds.Tables[0];
GdVwViewDocumentBoy.DataBind();
}
else
{
lblErrorMsg.Text = "Records not available";
GdVwViewDocumentBoy.DataSource = null;
GdVwViewDocumentBoy.DataBind();
}
con.Close();
}
catch (Exception ex)
{
lblCatchError.Text = ex.Message.ToString();
}
}
protected void ddlApprovDocBoy_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlApprovDocBoy.SelectedItem.Text == "--Select--")
{
GdVwViewDocumentBoy.DataSource = null;
GdVwViewDocumentBoy.DataBind();
}
else
{
string strName = ddlDocBoy.SelectedItem.Text;
int intApprove = int.Parse(ddlApprovDocBoy.SelectedItem.Value);
if (ddlDocBoy.SelectedItem.Text == "--Select--" && ddlApprovDocBoy.SelectedItem.Text != "--Select--")
{
BLDocumentBoy blpr = new BLDocumentBoy();
SqlDataReader dr = blpr.gridFillApproveDocumentBoy1(intApprove);
DataTable dt = new DataTable();
if (dr.HasRows == true)
{
dt.Load(dr);
GdVwViewDocumentBoy.DataSource = dt;
GdVwViewDocumentBoy.DataBind();
}
else
{
lblErrorMsg.Text = "Records not Available";
GdVwViewDocumentBoy.DataSource = dt;
GdVwViewDocumentBoy.DataBind();
}
dr.Close();
}
if (ddlDocBoy.SelectedItem.Text != "--Select--" && ddlApprovDocBoy.SelectedItem.Text != "--Select--")
{
BLDocumentBoy blpr = new BLDocumentBoy();
SqlDataReader dr = blpr.gridFillApproveDocumentBoyName1(strName, intApprove);
DataTable dt = new DataTable();
if (dr.HasRows == true)
{
dt.Load(dr);
GdVwViewDocumentBoy.DataSource = dt;
GdVwViewDocumentBoy.DataBind();
}
else
{
lblErrorMsg.Text = "Records not Available";
GdVwViewDocumentBoy.DataSource = dt;
GdVwViewDocumentBoy.DataBind();
}
dr.Close();
}
}
}
catch (Exception ex)
{
lblCatchError.Text = ex.Message.ToString();
}
}
protected void ChkbxShowDeletedDocBoy_CheckedChanged(object sender, EventArgs e)
{
try
{
string strName = ddlDocBoy.SelectedItem.Text;
// int intApprove = int.Parse(ddlApprovDocBoy.SelectedItem.Value);
int intIsDeleted;
if (ChkbxShowDeletedDocBoy.Checked == true)
intIsDeleted = 1;
else
intIsDeleted = 0;
if (ddlDocBoy.SelectedItem.Text == "--Select--" && ddlApprovDocBoy.SelectedItem.Text == "--Select--" && (ChkbxShowDeletedDocBoy.Checked == true || ChkbxShowDeletedDocBoy.Checked == false))
{
BLDocumentBoy blpr = new BLDocumentBoy();
SqlDataReader dr = blpr.isDelDocBoyChecked1(intIsDeleted);
DataTable dt = new DataTable();
if (dr.HasRows == true)
{
dt.Load(dr);
GdVwViewDocumentBoy.DataSource = dt;
GdVwViewDocumentBoy.DataBind();
}
else
{
lblErrorMsg.Text = "Records not Available";
GdVwViewDocumentBoy.DataSource = null;
GdVwViewDocumentBoy.DataBind();
}
dr.Close();
}
if (ddlDocBoy.SelectedItem.Text != "--Select--" && ddlApprovDocBoy.SelectedItem.Text == "--Select--" && (ChkbxShowDeletedDocBoy.Checked == true || ChkbxShowDeletedDocBoy.Checked == false))
{
BLDocumentBoy blpr = new BLDocumentBoy();
SqlDataReader dr = blpr.isDelDocBoyNameChecked1(strName, intIsDeleted);
DataTable dt = new DataTable();
if (dr.HasRows == true)
{
dt.Load(dr);
GdVwViewDocumentBoy.DataSource = dt;
GdVwViewDocumentBoy.DataBind();
}
else
{
lblErrorMsg.Text = "Records not Available";
GdVwViewDocumentBoy.DataSource = null;
GdVwViewDocumentBoy.DataBind();
}
dr.Close();
}
if (ddlDocBoy.SelectedItem.Text != "--Select--" && ddlApprovDocBoy.SelectedItem.Text != "--Select--" && (ChkbxShowDeletedDocBoy.Checked == true || ChkbxShowDeletedDocBoy.Checked == false))
{
int intApprove = int.Parse(ddlApprovDocBoy.SelectedItem.Value);
BLDocumentBoy blpr = new BLDocumentBoy();
SqlDataReader dr = blpr.isDelDocBoyNameAppChecked1(strName, intApprove, intIsDeleted);
DataTable dt = new DataTable();
if (dr.HasRows == true)
{
dt.Load(dr);
GdVwViewDocumentBoy.DataSource = dt;
GdVwViewDocumentBoy.DataBind();
}
else
{
lblErrorMsg.Text = "Records not Available";
GdVwViewDocumentBoy.DataSource = null;
GdVwViewDocumentBoy.DataBind();
}
dr.Close();
}
}
catch (Exception ex)
{
lblCatchError.Text = ex.Message.ToString();
}
}
protected void btnSaveDocBoy_Click(object sender, EventArgs e)
{
try
{
BLDocumentBoy bldb = new BLDocumentBoy();
SqlDataReader dr = bldb.getDocBoyDetailsForUpdate1(intDocumentBoyID);
setparameters();
if (Session["DocBoyId"] != null)
{
setparameters();
intDocumentBoyID = int.Parse(Session["DocBoyId"].ToString()); //int.Parse(Request.QueryString["DocBoyId"]);
bldb.updateDocumentBoy1(intDocumentBoyID, strMobile, intIsDeleted, intApprove, strMailID);
fillgrid();
lblResult.Visible = true;
lblResult.ForeColor = System.Drawing.Color.Green;
lblResult.Text = "Document Boys Details are Updated Successfully";
txtNameDocBoy.Enabled = true;
btnClearDocBoy.Enabled = true;
fillgrid();
Session["DocBoyId"] = null;
getMaxCode();
}
else
{
string msg = bldb.saveDocumentBoy1(strName, strMobile, intIsDeleted, strCode, intApprove, strMailID); //mail id added
fillgrid();
if (msg == "1")
{
lblResult.Visible = true;
lblResult.ForeColor = System.Drawing.Color.Green;
lblResult.Text = "Document Boy Details Details are Added Successfully";
fillDDLDocBoy();
}
else
{
lblResult.Visible = true;
lblResult.ForeColor = System.Drawing.Color.Red;
lblResult.Text = "Document Boy Details Details are already Exists";
}
fillgrid();
Session["DocBoyId"] = null;
getMaxCode();
}
ClearFields();
}
catch (Exception ex)
{
lblCatchError.Text = ex.Message.ToString();
}
}