protected void btnSubmit_Click(object sender, EventArgs e) { if (Page.IsValid == false) { return; } SqlConnection Cn = new SqlConnection(); Class1.OpenConn(Cn); int mID = Convert.ToInt16(lblId.InnerText.ToString()); int mNewId = 0; if (mID == 0) { String strR = ""; SqlCommand Cmd = new SqlCommand("Select Max(CID) from CriminalMaster", Cn); strR = Cmd.ExecuteScalar().ToString(); if (strR != "") { mNewId = Convert.ToInt16(strR); } mNewId = mNewId + 1; } SqlDataAdapter Da = new SqlDataAdapter("Select * from CriminalMaster where CID = " + mID, Cn); SqlCommandBuilder Cb = new SqlCommandBuilder(Da); DataTable Ds = new DataTable(); DataRow r; Da.Fill(Ds); if (mID == 0) { r = Ds.NewRow(); r["CID"] = mNewId; r["CreatedBy"] = Class1.sUserName(); r["CreatedDate"] = DateTime.Now; } else { r = Ds.Rows[0]; } r["FName"] = txtFName.Text.ToString(); r["MName"] = txtMName.Text.ToString(); r["LName"] = txtLName.Text.ToString(); if (txtBirthDate.Text.ToString() != "") { r["DOB"] = Convert.ToDateTime(txtBirthDate.Text.ToString()); } r["RelAddress"] = txtAddress.Text.ToString(); r["RelMobileNo"] = txtMobileNo.Text.ToString(); r["RelResiNo"] = txtResiNo.Text.ToString(); r["SkinColor"] = txtSkinColor.Text.ToString(); r["HairColor"] = txtHairColor.Text.ToString(); r["Height"] = txtHeight.Text.ToString(); r["Weight"] = txtWeight.Text.ToString(); r["Scars"] = txtScars.Text.ToString(); r["PhysicalDeformity"] = txtPhyDeformity.Text.ToString(); if (Fupd.FileName.ToString() != "") { r["Photo"] = mNewId + Fupd.FileName.ToString(); Fupd.SaveAs(Server.MapPath("~/") + "photos/Dept/" + mNewId.ToString() + Fupd.FileName.ToString()); } if (mID == 0) { Ds.Rows.Add(r); } Da.Update(Ds); Da.Dispose(); Cb.Dispose(); Ds.Dispose(); Response.Redirect("ManageCriminalData.aspx"); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (Page.IsValid == false) { return; } SqlConnection Cn = new SqlConnection(); Class1.OpenConn(Cn); int mId = Convert.ToInt16(lblUserId.InnerText.ToString()); String StrSql = ""; if (mId == 0) { String strR = ""; if (lblType.InnerHtml.ToString() == "dept") { StrSql = "Select max(FCID) from FoundCitizenMaster"; } else { StrSql = "Select max(MID) from MissingCitizenMaster"; } SqlCommand Cmd9 = new SqlCommand(StrSql, Cn); strR = Cmd9.ExecuteScalar().ToString(); Cmd9.Dispose(); if (strR != "") { mId = Convert.ToInt16(strR); } mId = mId + 1; } if (lblType.InnerHtml.ToString() == "dept") { StrSql = "Select * from FoundCitizenMaster where FCID = " + mId; } else { StrSql = "Select * from MissingCitizenMaster where MID = " + mId; } SqlDataAdapter Da = new SqlDataAdapter(StrSql, Cn); SqlCommandBuilder Cb = new SqlCommandBuilder(Da); DataTable Ds = new DataTable(); DataRow r; Da.Fill(Ds); if (Convert.ToInt16(lblUserId.InnerText.ToString()) == 0) { r = Ds.NewRow(); r["CreatedById"] = Class1.iUserId(); r["CreatedBy"] = Class1.sUserName(); r["CreatedDate"] = DateTime.Now; r["LastStatus"] = "New"; r["Location"] = Class1.sUserLocation(); if (lblType.InnerHtml.ToString() == "dept") { r["FCID"] = mId; r["MID"] = 0; } else { r["MID"] = mId; r["PID"] = 0; } } else { r = Ds.Rows[0]; } r["FName"] = txtFName.Text.ToString(); r["MName"] = txtMName.Text.ToString(); r["LName"] = txtLName.Text.ToString(); r["MobileNo"] = txtMobileNo.Text.ToString(); r["ResiNo"] = txtResiNo.Text.ToString(); r["Address"] = txtAddress.Text.ToString(); if (txtBirthDate.Text.ToString() != "") { r["DOB"] = Convert.ToDateTime(txtBirthDate.Text.ToString()); } r["Details"] = txtDetails.Text.ToString(); if (Fupd.FileName.ToString() != "") { r["Photo"] = mId + Fupd.FileName.ToString(); Fupd.SaveAs(Server.MapPath("~/") + "photos/Citizen/" + mId.ToString() + Fupd.FileName.ToString()); } r["SkinColor"] = txtSkinColor.Text.ToString(); r["HairColor"] = txtHairColor.Text.ToString(); r["Height"] = txtHeight.Text.ToString(); r["Weight"] = txtWeight.Text.ToString(); r["Scars"] = txtScars.Text.ToString(); r["PhysicalDeformity"] = txtPhyDeformity.Text.ToString(); if (Convert.ToInt16(lblUserId.InnerText.ToString()) == 0) { Ds.Rows.Add(r); } Da.Update(Ds); Da.Dispose(); Cb.Dispose(); Ds.Dispose(); if (lblType.InnerHtml.ToString() == "dept") { Response.Redirect("ManageMissingCitizen.aspx"); } else { Response.Redirect("ViewComplaint.aspx"); } }
protected void btnSubmit_Click(object sender, EventArgs e) { lblMessage.Visible = false; if (Page.IsValid == false) { return; } if (ddlLocation.SelectedIndex == 0) { lblMessage.InnerHtml = "Select Location from the List"; lblMessage.Visible = true; return; } SqlConnection Cn = new SqlConnection(); Class1.OpenConn(Cn); int mUserId = Convert.ToInt16(lblUserId.InnerText.ToString()); if (mUserId == 0) { String strR = ""; SqlCommand Cmd = new SqlCommand("Select Max(UID) from UserMaster", Cn); strR = Cmd.ExecuteScalar().ToString(); if (strR != "") { mUserId = Convert.ToInt16(strR); } mUserId = mUserId + 1; } SqlDataAdapter Da = new SqlDataAdapter("Select * from UserMaster where UID = " + mUserId, Cn); SqlCommandBuilder Cb = new SqlCommandBuilder(Da); DataTable Ds = new DataTable(); DataRow r; Da.Fill(Ds); if (Convert.ToInt16(lblUserId.InnerText.ToString()) == 0) { r = Ds.NewRow(); r["UID"] = mUserId; r["CreatedBy"] = Class1.sUserName(); r["CreatedDate"] = DateTime.Now; r["Password"] = "******"; } else { r = Ds.Rows[0]; } r["FName"] = txtFName.Text.ToString(); r["MName"] = txtMName.Text.ToString(); r["LName"] = txtLName.Text.ToString(); r["MobileNo"] = txtMobileNo.Text.ToString(); r["ResiNo"] = txtResiNo.Text.ToString(); r["EmailId"] = txtEmailId.Text.ToString(); if (txtBirthDate.Text.ToString() != "") { r["DOB"] = Convert.ToDateTime(txtBirthDate.Text.ToString()); } r["UserType"] = lblUserType.InnerHtml.ToString(); r["Details"] = txtDetails.Text.ToString(); r["Location"] = ddlLocation.SelectedItem.Text.ToString(); if (Fupd.FileName.ToString() != "") { r["PhotoName"] = mUserId + Fupd.FileName.ToString(); Fupd.SaveAs(Server.MapPath("~/") + "photos/User/" + mUserId.ToString() + Fupd.FileName.ToString()); } if (Convert.ToInt16(lblUserId.InnerText.ToString()) == 0) { Ds.Rows.Add(r); } Da.Update(Ds); Da.Dispose(); Cb.Dispose(); Ds.Dispose(); Response.Redirect("ManageUser.aspx"); }