/*    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; }
        }
예제 #4
0
        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; }
        }