/* protected void btnsave_Click(object sender, EventArgs e) * { * try * { * DataUtility data = null; * string YrStr = ""; * * if (Page.IsValid) * { * * for (int i = 0; i < CheckBoxList1.Items.Count; i++) * { * if (CheckBoxList1.Items[i].Selected) * { * YrStr = CheckBoxList1.Items[i].Text; * * SqlParameter[] sqlParam = { * new SqlParameter("@Company_Id",1000), * new SqlParameter("@Service_Line_Code",ddlservicelinecode.SelectedValue), * new SqlParameter("@Module_Code",ddlmodulecode.SelectedValue), * * new SqlParameter("@complaint_code",YrStr), * new SqlParameter("@CreatedBy",Session["UserName"]), * new SqlParameter("@CreatedDate", DateTime.Now) * }; * * * data = new DataUtility(); * * data.ExecuteProc("insertComplaintMapping", sqlParam); * * * } * * } * ClearData(); * * FillGrid(); * * r_Error1.Visible = true; * * lblinsert.Text = "New Solution Added"; * ClientScript.RegisterStartupScript(this.GetType(), "alert", "HideinsertLabel();", true); * * } * } * catch * { * throw; * } * * * }*/ protected void btnsave_Click(object sender, EventArgs e) { try { DataUtility data = null; if (Page.IsValid) { foreach (GridViewRow gvrow in popupgv.Rows) { if (gvrow.RowType == DataControlRowType.DataRow) { //var checkbox = gvrow.FindControl("chkpopup") as CheckBox; CheckBox chkRow = (gvrow.Cells[0].FindControl("chkpopup") as CheckBox); if (chkRow.Checked) { string code = gvrow.Cells[2].Text; SqlParameter[] sqlParam = { new SqlParameter("@Company_Id", 1000), new SqlParameter("@Service_Line_Code", ddlservicelinecode.SelectedValue), new SqlParameter("@Module_Code", ddlmodulecode.SelectedValue), new SqlParameter("@complaint_code", code), new SqlParameter("@CreatedBy", Session["UserName"]), new SqlParameter("@CreatedDate", DateTime.Now) }; data = new DataUtility(); data.ExecuteProc("insertComplaintMapping", sqlParam); } } } ClearData(); FillGrid(); r_Error1.Visible = true; lblinsert.Text = "New Solution Added"; ClientScript.RegisterStartupScript(this.GetType(), "alert", "HideinsertLabel();", true); } } catch { throw; } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { DataUtility data = null; string modulecode = Convert.ToString((sender as Button).CommandArgument); if (Page.IsValid) { btnUpdate.Visible = true; btnSave.Visible = false; lblErrorMsg.Text = lblSuccessMsg.Text = ""; SqlParameter[] param = { new SqlParameter("@ServiceLineCode", ddlServiceLineCode.SelectedValue), new SqlParameter("@ModuleCode", modulecode), new SqlParameter("@ModuleDescription", txtModuleDescription.Text.Trim()), new SqlParameter("@Active", rblActive.SelectedValue), new SqlParameter("@UpdatedDate", DateTime.Now.ToString()), new SqlParameter("@UpdatedBy", Session["username"]) }; data = new DataUtility(); data.ExecuteProc("ServiceLineModuleInsert", param); Clear(); FillGridView(); r_Error1.Visible = true; lblSuccessMsg.Text = "Updated Successfully........"; } else { r_Error1.Visible = true; lblErrorMsg.Text = "error occured....."; } } catch { throw; } }
protected void btnSave_Click(object sender, EventArgs e) { DataUtility data = null; try { if (Page.IsValid) { btnUpdate.Visible = false; SqlParameter[] param = { new SqlParameter("@ServiceLineCode", ddlServiceLineCode.SelectedValue), new SqlParameter("@ModuleDescription", txtModuleDescription.Text.Trim()), new SqlParameter("@Active", rblActive.SelectedValue), new SqlParameter("@CompanyId", 1000), new SqlParameter("@CreatedDate", DateTime.Now.ToString()), new SqlParameter("@CreatedBy", Session["username"]) }; data = new DataUtility(); data.ExecuteProc("ServiceLineModuleInsert", param); Clear(); DropDownList(); r_Error1.Visible = true; lblSuccessMsg.Text = "Saved Successfully......"; FillGridView(); } else { r_Error1.Visible = true; lblErrorMsg.Text = "Error occured......."; } } catch { throw; } }
protected void btnSave_Click(object sender, EventArgs e) { try { DataUtility data = null; if (Page.IsValid) { btnUpdate.Visible = false; SqlParameter[] param = { new SqlParameter("@ComplaintDescription", txtDescription.Text.Trim()), new SqlParameter("@ComplaintSeverity", ddlSeverity.SelectedValue), new SqlParameter("@StatusActive", rblActive.SelectedValue), new SqlParameter("@CreatedDate", DateTime.Now.ToString()), new SqlParameter("@CreatedBy", Session["username"]) }; data = new DataUtility(); data.ExecuteProc("ComplaintInsert", param); Clear(); Severity(); r_Error1.Visible = true; lblSuccessMsg.Text = "Saved Successfully......."; FillGridView(); } else { r_Error1.Visible = true; lblErrorMsg.Text = "Error Occured......."; } } catch { throw; } }