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