예제 #1
0
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            try
            {
                string      strmsg;
                DataUtility data = null;

                if (Page.IsValid)
                {
                    btnSave.Visible = false;
                    //txtServicelineCode.ReadOnly = true;
                    string servicelinecode = Convert.ToString((sender as Button).CommandArgument);

                    SqlParameter[] param =
                    {
                        new SqlParameter("@ServiceLineCode", servicelinecode),
                        new SqlParameter("@Description",     txtDescription.Text.Trim()),
                        new SqlParameter("@Active",          rblActive.SelectedValue),
                        new SqlParameter("@IMS",             "1"),
                        new SqlParameter("@RFC",             "0"),
                        new SqlParameter("@UpdatedDate",     DateTime.Now.ToString()),
                        new SqlParameter("@UpdatedBy",       Session["username"]),
                        new SqlParameter("@Flag",                                     2),
                        //          new SqlParameter("@msg",DBNull.Value)
                    };
                    data = new DataUtility();

                    strmsg = data.ExecuteStoredProc("ServiceMasterInsert", param, 1);

                    Clear();


                    r_Error1.Visible   = true;
                    lblSuccessMsg.Text = "Updated Successfully.......";

                    FillGridView();
                }

                else
                {
                    r_Error1.Visible = true;
                    lblErrorMsg.Text = "Error Occured.......";
                }
            }

            catch { throw; }
        }
예제 #2
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                string      strmsg;
                DataUtility data = null;
                if (Page.IsValid)
                {
                    btnSave.Visible = true;
                    SqlParameter[] param =
                    {
                        new SqlParameter("@ServiceLineCode", txtServicelineCode.Text.Trim()),
                        new SqlParameter("@Description",     txtDescription.Text.Trim()),
                        new SqlParameter("@Active",          rblActive.SelectedValue),
                        new SqlParameter("@IMS",             "1"),
                        new SqlParameter("@RFC",             "0"),
                        new SqlParameter("@CreatedBy",       Session["username"]),
                        new SqlParameter("@CreatedDate",     DateTime.Now.ToString()),
                        new SqlParameter("@Flag", 1)
                        //new SqlParameter("@msg",SqlDbType.VarChar,100)
                    };
                    data = new DataUtility();

                    strmsg = data.ExecuteStoredProc("ServiceMasterInsert", param, 1);

                    Clear();

                    r_Error1.Visible = true;
                    if (strmsg == "1")
                    {
                        lblErrorMsg.Text = "Service Line Already Exists.......";
                    }
                    else
                    {
                        lblSuccessMsg.Text = "New Service Line Added.......";
                    }
                    FillGridView();
                }

                else
                {
                    r_Error1.Visible = true;
                    lblErrorMsg.Text = "Service Line Error Occured.......";
                }
            }
            catch { throw; }
        }