public void InsertOfficerDetails() { string Result; objOfficer = new clsOfficerRegistration(); objOfficer.FName = txtFName.Text.Trim(); objOfficer.MName = txtMName.Text.Trim(); objOfficer.LName = txtLName.Text.Trim(); objOfficer.DOB = Convert.ToDateTime(txtDOB.Text); objOfficer.Address = txtAddress.Text; objOfficer.EmailId = txtEmailId.Text.Trim(); objOfficer.PhoneNo = txtPhoneNo.Text.Trim(); objOfficer.UserName = txtUserName.Text.Trim(); objOfficer.Password = txtPassword.Text.Trim(); objOfficer.Experience = txtExperience.Text.Trim(); objOfficer.Photo = (byte[])Session["Photo"]; objOfficer.ImageFile = Session["FileName"].ToString(); int i = objOfficer.InsertOfficerDetails(out Result); if (i > 0) { Page.RegisterClientScriptBlock("Student", "<script>alert('" + Result + "')</script>"); } else { Page.RegisterClientScriptBlock("Student", "<script>alert('" + Result + "')</script>"); } }
public void GetOfficerProfile() { objOfficer = new clsOfficerRegistration(); objOfficer.OfficerId = Convert.ToInt32(Session["OfficerId"]); DataSet dsOfficer = objOfficer.GetOfficerProfile(); if (dsOfficer.Tables[0].Rows.Count > 0) { lblOfficerId.Text = dsOfficer.Tables[0].Rows[0][0].ToString(); txtFirstName.Text = dsOfficer.Tables[0].Rows[0][1].ToString(); txtMiddleName.Text = dsOfficer.Tables[0].Rows[0][2].ToString(); txtLastName.Text = dsOfficer.Tables[0].Rows[0][3].ToString(); txtAddress.Text = dsOfficer.Tables[0].Rows[0][6].ToString(); txtPhone.Text = dsOfficer.Tables[0].Rows[0][8].ToString(); txtEmailId.Text = dsOfficer.Tables[0].Rows[0][7].ToString(); } }
public void UpdateOfficerProfile() { objOfficer = new clsOfficerRegistration(); objOfficer.OfficerId = Convert.ToInt32(Session["OfficerId"]); objOfficer.FName = txtFirstName.Text.Trim(); objOfficer.MName = txtMiddleName.Text.Trim(); objOfficer.LName = txtLastName.Text.Trim(); objOfficer.Address = txtAddress.Text; objOfficer.PhoneNo = txtPhone.Text.Trim(); objOfficer.EmailId = txtEmailId.Text.Trim(); objOfficer.Photo = (byte[])Session["Photo"]; objOfficer.ImageFile = Session["FileName"].ToString(); int i = objOfficer.UpdateOfficerProfile(); if (i > 0) { Page.RegisterClientScriptBlock("Officer", "<script>alert('Profile Updated')</script>"); } else { Page.RegisterClientScriptBlock("Officer", "<script>alert('Bad Request')</script>"); } }