private void textBox_correo_buscar_TextChanged(object sender, EventArgs e)
{
if (textBox_correo_buscar.TextLength > 3)
{
//general = Persistencia.SentenciasSQL.select(SentenciasSQL.SQL[1]);
busqueda = general;
DataTable telefonos = Persistencia.SentenciasSQL.select("SELECT ctos_detemail.IdEntidad,ctos_detemail.Descripcion, ctos_detemail.Email FROM ctos_detemail WHERE (((ctos_detemail.Email) Like '%" + textBox_correo_buscar.Text + "%')) GROUP BY ctos_detemail.IdEntidad");
var query =
from tbl1 in busqueda.AsEnumerable()
join tbl2 in telefonos.AsEnumerable() on tbl1["IDEntidad"] equals tbl2["IdEntidad"]
group tbl1 by tbl1.Field <int>("IDEntidad") into IdGroup
let row = IdGroup.First()
select new
{
ID = IdGroup.Key,
Field1 = row["Entidad"],
Field2 = row["Email"],
Field3 = row["Telefono"]
};
DataTable newTable = new DataTable();
newTable.Columns.Add("IDEntidad", typeof(int));
newTable.Columns.Add("Entidad", typeof(string));
newTable.Columns.Add("Email", typeof(string));
newTable.Columns.Add("Telefono", typeof(string));
foreach (var rowInfo in query)
{
newTable.Rows.Add(rowInfo.ID, rowInfo.Field1, rowInfo.Field2, rowInfo.Field3);
}
dataGridView1.DataSource = newTable;
dataGridView1.Columns[0].Width = 50;
dataGridView1.Columns[1].Width = 400;
dataGridView1.Columns[2].Width = 250;
dataGridView1.Columns[3].Width = 100;
}
else
{
dataGridView1.DataSource = general;
dataGridView1.Columns[4].Visible = false;
dataGridView1.Columns[2].Visible = false;
dataGridView1.Columns[5].Visible = false;
//ajustarDatagrid();
}
}
private void textBox_telefono_buscar_KeyPress(object sender, KeyPressEventArgs e)
{
if (textBox_telefono_buscar.TextLength > 0)
{
busqueda = general;
DataTable telefonos = Persistencia.SentenciasSQL.select("SELECT ctos_dettelf.IdEntidad,ctos_dettelf.Telefono FROM ctos_dettelf WHERE (((ctos_dettelf.Telefono) Like '%" + textBox_telefono_buscar.Text + "%')) GROUP BY ctos_dettelf.IdEntidad;");
var query =
from tbl1 in busqueda.AsEnumerable()
join tbl2 in telefonos.AsEnumerable() on tbl1["IDEntidad"] equals tbl2["IdEntidad"]
group tbl1 by tbl1.Field <int>("IDEntidad") into IdGroup
let row = IdGroup.First()
select new
{
ID = IdGroup.Key,
Field1 = row["Entidad"],
Field2 = row["Email"],
Field3 = row["Telefono"]
};
DataTable newTable = new DataTable();
newTable.Columns.Add("ID", typeof(int));
newTable.Columns.Add("Entidad", typeof(string));
newTable.Columns.Add("Email", typeof(string));
newTable.Columns.Add("Telefono", typeof(string));
foreach (var rowInfo in query)
{
newTable.Rows.Add(rowInfo.ID, rowInfo.Field1, rowInfo.Field2, rowInfo.Field3);
}
dataGridView1.DataSource = newTable;
dataGridView1.Columns[0].Width = 50;
dataGridView1.Columns[1].Width = 400;
dataGridView1.Columns[2].Width = 250;
dataGridView1.Columns[3].Width = 100;
}
else
{
dataGridView1.DataSource = null;
}
}
public DataSet UpdateBatchImageOnImageServerDatabase(int BatchId, DataSet dsDocumentScans)
{
String _strImageDatabaseConnectionString = "";
SqlDataAdapter objSqlDataAdapterImages = null;
SqlCommandBuilder objSqlCommandBuilderImages = null;
SqlConnection sqlConnectionDxImages = null;
SqlCommand objSqlCommandImages = null;
SqlTransaction objSqlTransactionImages = null;
DataTable objectDataTable = null;
string _SqlQuery = "";
// DataSet dsDocumentScans = decom(data); //DecompressData(data);
//DataSet dsnew = decom(data);
try
{
//if (ImageRecordId != 0) //In Case ImageRecordId > 0 then its case of records Updation only
//{
_strImageDatabaseConnectionString = System.Configuration.ConfigurationManager.AppSettings.Get("ImageDatabaseConnectionString");
if (_strImageDatabaseConnectionString == "" || _strImageDatabaseConnectionString == null)
{
throw new Exception("Error opening connection for Image DatabaseConfigurationName");
}
sqlConnectionDxImages = new SqlConnection(_strImageDatabaseConnectionString);
// objSqlCommandImages.CommandTimeout = 1000;
sqlConnectionDxImages.Open();
objSqlTransactionImages = null;
objSqlTransactionImages = sqlConnectionDxImages.BeginTransaction();
var result = from r in dsDocumentScans.Tables["ImageRecordItems"].AsEnumerable()
group r by r.Field <int>("ImageRecordId") into IdGroup
let row = IdGroup.First()
select new
{
ImageRecordId = row.Field <int>("ImageRecordId"),
};
string imageId = string.Empty;
bool flag = true;
foreach (var r in result)
{
if (flag == true)
{
flag = false;
}
else
{
imageId += ",";
}
imageId += Convert.ToString(r.ImageRecordId);
}
string scannedtype = "S"; // Convert.ToString(dsDocumentScans.Tables["ImageRecords"].Rows[0]["ScannedOrUploaded"].ToString());
// _SqlQuery = "Select * from ImageRecordItems where ItemImage is not null";
_SqlQuery = "Select * from ImageRecordItems where ImageRecordId IN (" + imageId + ")";
objSqlCommandImages = new SqlCommand(_SqlQuery, sqlConnectionDxImages);
objSqlDataAdapterImages = new SqlDataAdapter(objSqlCommandImages);
objSqlDataAdapterImages.SelectCommand.Transaction = objSqlTransactionImages;
objSqlCommandBuilderImages = new SqlCommandBuilder(objSqlDataAdapterImages);
objSqlDataAdapterImages.InsertCommand = objSqlCommandBuilderImages.GetInsertCommand();
objSqlDataAdapterImages.InsertCommand.Transaction = objSqlTransactionImages;
objSqlDataAdapterImages.UpdateCommand = objSqlCommandBuilderImages.GetUpdateCommand();
objSqlDataAdapterImages.UpdateCommand.Transaction = objSqlTransactionImages;
objSqlDataAdapterImages.UpdateBatchSize = 20;
objSqlDataAdapterImages.Update(dsDocumentScans.Tables["ImageRecordItems"]);
objSqlTransactionImages.Commit();
sqlConnectionDxImages.Close();
objectDataTable = new DataTable();
objectDataTable = GetScannedBatchImagesfromDatabase(imageId);
// }
DataSet objDs = new DataSet();
objDs.Tables.Add(objectDataTable.Copy());
return(objDs);
}
catch (Exception ex)
{
objSqlTransaction.Rollback();
sqlConnectionDxImages.Close();
//if (_boolCommittedImagesTable == true)
// DeleteImages(_strImageDatabaseConnectionString, _dsOriginalDocumentScans);
return(null);
//throw (ex);
}
finally
{
if (objSqlDataAdapterImages != null)
{
objSqlDataAdapterImages.Dispose();
}
if (objSqlCommandBuilderImages != null)
{
objSqlCommandBuilderImages.Dispose();
}
if (sqlConnectionDxImages != null)
{
sqlConnectionDxImages.Dispose();
}
if (objSqlCommandImages != null)
{
objSqlCommandImages.Dispose();
}
_strImageDatabaseConnectionString = null;
}
}