protected void btnAddmore_Click(object sender, EventArgs e) { Criminal_Education_InformationObject ceiObject = new Criminal_Education_InformationObject(); CriminalInformationService cisObj = new CriminalInformationService(); try { ceiObject.RefNo = txtRefNo.Text; ceiObject.EducationalStatus = txtEducationalStatus.Text; ceiObject.NameofInstitution = txtNameofInstitution.Text; ceiObject.PoliticalInvolvementinInstitution = txtPoliticalInvolvementinInstitution.Text; ceiObject.CreateBy = Membership.GetUser().UserName; ceiObject.CreateDate = DateTime.Now; ceiObject.LastUpdateBy = Membership.GetUser().UserName; ; ceiObject.LastUpdateDate = DateTime.Now; if (cisObj.InsertEducationInformation(ceiObject)) { txtEducationalStatus.Text = ""; txtNameofInstitution.Text = ""; txtPoliticalInvolvementinInstitution.Text = ""; SuccessMessage.Text = "One record Added."; } } catch (Exception ex) { ErrorMessage.Text = ex.Message; } }
protected void btnSave_Click(object sender, EventArgs e) { Criminal_Education_InformationObject ceiObject = new Criminal_Education_InformationObject(); CriminalInformationService cisObj = new CriminalInformationService(); try { ceiObject.RefNo = txtRefNo.Text; ceiObject.EducationalStatus = txtEducationalStatus.Text; ceiObject.NameofInstitution = txtNameofInstitution.Text; ceiObject.PoliticalInvolvementinInstitution = txtPoliticalInvolvementinInstitution.Text; ceiObject.CreateBy = Membership.GetUser().UserName; ceiObject.CreateDate = DateTime.Now; ceiObject.LastUpdateBy = Membership.GetUser().UserName; ; ceiObject.LastUpdateDate = DateTime.Now; if (cisObj.InsertEducationInformation(ceiObject)) { Response.Redirect("criminal-death-information.aspx?refno=" + txtRefNo.Text); } } catch (Exception ex) { ErrorMessage.Text = ex.Message; } }
/// <summary> /// Insert Criminal Education Information using this fuction /// </summary> /// <returns></returns> public bool InsertEducationInformation(Criminal_Education_InformationObject ceiObject) { clsBase baseObj = new clsBase(); string sqlstring = "INSERT INTO [Criminal_Education_Information] ([RefNo],[EducationalStatus]" + ",[NameofInstitution],[PoliticalInvolvementinInstitution],[CreateBy],[CreateDate]" + ",[LastUpdateDate],[LastUpdateBy]) VALUES (@RefNo,@EducationalStatus,@NameofInstitution," + "@PoliticalInvolvementinInstitution,@CreateBy,@CreateDate,@LastUpdateDate, @LastUpdateBy)"; List<SqlParameter> parametersList = new List<SqlParameter>(); parametersList.Add(new SqlParameter("@RefNo", ceiObject.RefNo)); parametersList.Add(new SqlParameter("@EducationalStatus", ceiObject.EducationalStatus)); parametersList.Add(new SqlParameter("@NameofInstitution", ceiObject.NameofInstitution)); parametersList.Add(new SqlParameter("@PoliticalInvolvementinInstitution", ceiObject.PoliticalInvolvementinInstitution)); parametersList.Add(new SqlParameter("@CreateBy", ceiObject.CreateBy)); parametersList.Add(new SqlParameter("@CreateDate", ceiObject.CreateDate)); parametersList.Add(new SqlParameter("@LastUpdateDate", ceiObject.LastUpdateDate)); parametersList.Add(new SqlParameter("@LastUpdateBy", ceiObject.LastUpdateBy)); return baseObj.InsertData(sqlstring, parametersList); }