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");
}
