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; } }
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; } }