protected void ImageButtonFieldAdd_Click(object sender, ImageClickEventArgs e) { if (!captcha.Decide()) { captcha.message = "پاسخ اشتباه است!"; } else { DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString); SqlDataAdapter sda = new SqlDataAdapter("sp_companyFieldAddCheckExists", sqlConn); sda.SelectCommand.CommandType = CommandType.StoredProcedure; sda.SelectCommand.Parameters.Add("@FieldId", SqlDbType.VarChar).Value = TextBoxFieldId.Text; sda.SelectCommand.Parameters.Add("@FieldName", SqlDbType.NVarChar).Value = TextBoxFieldName.Text; sda.Fill(ds); dt = ds.Tables[0]; if (dt.Rows.Count == 0) //user doesn't exist { SqlCommand sqlCmd = new SqlCommand("sp_companyFieldAdd", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@FieldId", SqlDbType.VarChar).Value = TextBoxFieldId.Text; sqlCmd.Parameters.Add("@FieldName", SqlDbType.NVarChar).Value = TextBoxFieldName.Text; sqlConn.Open(); sqlCmd.ExecuteNonQuery(); GridViewFields.DataBind(); sqlCmd.Dispose(); sqlConn.Dispose(); sda.Dispose(); LabelAddFieldMessage.Visible = true; LabelAddFieldMessage.Text = "زمینه با مشخصات وارد شده اضافه گردید."; LabelAddFieldMessage.CssClass = "SuccessMessage"; } else //user exists as an admin { LabelAddFieldMessage.Visible = true; LabelAddFieldMessage.Text = "زمینه با مشخصات وارد شده موجود می باشد."; LabelAddFieldMessage.CssClass = "ErrorMessage"; sda.Dispose(); sqlConn.Close(); } } }
protected void chkTodosCampos_CheckedChanged(object sender, EventArgs e) { if (Session[this.lblTableName.Text] != null) { DataTable oTable = (DataTable)Session[this.lblTableName.Text]; int columnas = this.GridViewFields.Columns.Count / 2; string colPrefixCheckCampo = "CheckCampoCol"; foreach (DataRow item in oTable.Rows) { for (int i = 1; i <= columnas; i++) { item[colPrefixCheckCampo + i] = this.chkTodosCampos.Checked; } } GridViewFields.DataSource = oTable; GridViewFields.DataBind(); Session[this.lblTableName.Text] = oTable; } }
private Boolean PoblarRejillaCampos() { Boolean Ok = false; try { DataTable oTable; oTable = this.CreaEstructuraCampos(); List <ModeloNegocios.CampoReporte> ListCamposReporte = null; int Fk_IdReporte = 1; GridViewFields.DataSource = null; GridViewFields.DataBind(); //ir a la BD por los datos ListCamposReporte = new NG_Catalogos().ObtenerCamposReporte(Fk_IdReporte); //si existe el objeto y tiene contenido if (ListCamposReporte != null) { if (ListCamposReporte.Count > 0) { //poblar la tabla int columnas = this.GridViewFields.Columns.Count / 2; string colPrefixNombreCampo = "NombreCampoCol"; string colPrefixDescripcionCampo = "DescripcionCampoCol"; string colPrefixCheckCampo = "CheckCampoCol"; string colPrefixVisibleCampo = "VisibleCampoCol"; bool dataRetrieved = false; int currentColumnNumber = 1; DataRow dr = oTable.NewRow(); foreach (CampoReporte item in ListCamposReporte) { dr[colPrefixNombreCampo + currentColumnNumber] = item.NombreCampoReporte; dr[colPrefixDescripcionCampo + currentColumnNumber] = item.DescripcionCampoReporte; dr[colPrefixCheckCampo + currentColumnNumber] = false; dr[colPrefixVisibleCampo + currentColumnNumber] = true; currentColumnNumber += 1; dataRetrieved = true; if (currentColumnNumber > columnas) { oTable.Rows.Add(dr); currentColumnNumber = 1; dr = oTable.NewRow(); } } if (dataRetrieved && dr.RowState == DataRowState.Detached) { for (int i = currentColumnNumber; i <= columnas; i++) { dr[colPrefixNombreCampo + i] = ""; dr[colPrefixDescripcionCampo + i] = ""; dr[colPrefixCheckCampo + i] = false; dr[colPrefixVisibleCampo + i] = false; } oTable.Rows.Add(dr); } GridViewFields.DataSource = oTable; GridViewFields.DataBind(); Session[this.lblTableName.Text] = oTable; Ok = true; } else { Msj = "No se encontraron campos para el reporte seleccionado"; this.LabelInfo.Text = "<div class='alert alert-warning'><strong> ¡Precaución! </strong> " + Msj + "</div>"; this.LabelInfoResult.Text = "<div class='alert alert-warning'><strong> ¡Precaución! </strong> " + Msj + "</div>"; MostrarMensajeJavaScript(Msj); Ok = true; } } else { Msj = "No se encontraron campos para el reporte seleccionado"; this.LabelInfo.Text = "<div class='alert alert-warning'><strong> ¡Precaución! </strong> " + Msj + "</div>"; this.LabelInfoResult.Text = "<div class='alert alert-warning'><strong> ¡Precaución! </strong> " + Msj + "</div>"; MostrarMensajeJavaScript(Msj); Ok = true; } } catch (Exception ex) { Msj = "Ha ocurrido un error al mostrar la lista de campos para el reporte. Contacta al área de sistemas."; this.LabelInfo.Text = "<div class='alert alert-danger'><strong> Error </strong>" + Msj + "</div>"; this.LabelInfoResult.Text = this.LabelInfo.Text; MostrarMensajeJavaScript(Msj); BitacoraExcepcion BitacoraExcepcionAplictivo = new BitacoraExcepcion { CadenaconexionBD = System.Configuration.ConfigurationManager.ConnectionStrings["cnArrendamientoInmueble"].ConnectionString, Aplicacion = "ContratosArrto", Modulo = MethodInfo.GetCurrentMethod().DeclaringType.ToString() + ".aspx", Funcion = MethodBase.GetCurrentMethod().Name + "()", DescExcepcion = ex.InnerException == null ? ex.Message : ex.InnerException.Message, Usr = ((SSO)Session["Contexto"]).UserName.ToString() }; BitacoraExcepcionAplictivo.RegistrarBitacoraExcepcion(); BitacoraExcepcionAplictivo = null; } return(Ok); }