public override void LoadConteudoEEstrutura(DataSet currentDataSet, long CurrentFRDBaseID, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@CurrentFRDBaseID", CurrentFRDBaseID);
command.Parameters.AddWithValue("@IDTipoNoticiaAut5", 5);
command.Parameters.AddWithValue("@IDTipoNoticiaAut8", 8);
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["ControloAut"],
"INNER JOIN IndexFRDCA ON IndexFRDCA.IDControloAut = ControloAut.ID " +
"WHERE ControloAut.IDTipoNoticiaAut BETWEEN @IDTipoNoticiaAut5 AND @IDTipoNoticiaAut8 AND IndexFRDCA.IDFRDBase=@CurrentFRDBaseID");
da.Fill(currentDataSet, "ControloAut");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Dicionario"],
"INNER JOIN ControloAutDicionario ON ControloAutDicionario.IDDicionario = Dicionario.ID " +
"INNER JOIN ControloAut ON ControloAut.ID = ControloAutDicionario.IDControloAut " +
"INNER JOIN IndexFRDCA ON IndexFRDCA.IDControloAut = ControloAut.ID " +
"WHERE ControloAut.IDTipoNoticiaAut BETWEEN @IDTipoNoticiaAut5 AND @IDTipoNoticiaAut8 AND IDFRDBase=@CurrentFRDBaseID");
da.Fill(currentDataSet, "Dicionario");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["ControloAutDicionario"],
"INNER JOIN IndexFRDCA ON IndexFRDCA.IDControloAut = ControloAutDicionario.IDControloAut " +
"INNER JOIN ControloAut ON ControloAut.ID = ControloAutDicionario.IDControloAut " +
"WHERE ControloAut.IDTipoNoticiaAut BETWEEN @IDTipoNoticiaAut5 AND @IDTipoNoticiaAut8 AND IndexFRDCA.IDFRDBase=@CurrentFRDBaseID");
da.Fill(currentDataSet, "ControloAutDicionario");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["IndexFRDCA"],
"INNER JOIN ControloAut ON ControloAut.ID = IndexFRDCA.IDControloAut " +
"WHERE ControloAut.IDTipoNoticiaAut BETWEEN @IDTipoNoticiaAut5 AND @IDTipoNoticiaAut8 AND IndexFRDCA.IDFRDBase=@CurrentFRDBaseID");
da.Fill(currentDataSet, "IndexFRDCA");
}
}
/// <summary>
/// 返回数据集,要从外部进行数据集 ( ds = new dataset()) 的传递
/// </summary>
/// <param name="commandType"></param>
/// <param name="commandText"></param>
/// <param name="commandParameters"></param>
/// <param name="ds"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public override DataSet ExecuteDataset(CommandType commandType, string commandText,
QueryParameterCollection commandParameters, DataSet ds, string tableName)
{
try
{
var cmd = new SqlCommand();
PrepareCommand(cmd, commandType, commandText, commandParameters);
var adapter = new SqlDataAdapter(cmd);
if (Equals(tableName, null) || (tableName.Length < 1))
{
adapter.Fill(ds);
}
else
{
adapter.Fill(ds, tableName);
}
base.SyncParameter(commandParameters);
cmd.Parameters.Clear();
return ds;
}
catch
{
exceptioned = true;
throw;
}
finally
{
Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strConn = "Server=KHJ; database=PE0503; Integrated Security = true";
DataSet ds = new DataSet();
SqlConnection cn = new SqlConnection(strConn);
SqlCommand cmd = new SqlCommand("select * from AssetTypes order by AssetTypeName", cn);
SqlCommand cmd2 = new SqlCommand("select * from Companies order by companyName", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
DropDownList1.DataSource = ds.Tables[0];
DropDownList1.DataTextField = "AssetTypeName";
DropDownList1.DataValueField = "AssetTypeID";
DropDownList1.DataBind();
SqlDataAdapter da1 = new SqlDataAdapter(cmd2);
da.Fill(ds);
DropDownList2.DataSource = ds.Tables[0];
DropDownList2.DataTextField = "companyName";
DropDownList2.DataValueField = "companyID";
// DropDownList2.DataBind();
}
}
public override void LoadUFControloDescricaoData(DataSet currentDataSet, DataSet newDataSet, long CurrentFRDBaseID, IDbConnection conn)
{
string WhereQueryFilter = "WHERE IDFRDBase=@CurrentFRDBaseID";
string WhereUserQueryFilter = "WHERE ID IN " +
"(SELECT IDTrusteeOperator FROM FRDBaseDataDeDescricao " +
WhereQueryFilter + " UNION " +
"SELECT IDTrusteeAuthority FROM FRDBaseDataDeDescricao " +
WhereQueryFilter + ")";
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@CurrentFRDBaseID", CurrentFRDBaseID);
command.Parameters.AddWithValue("@IsAuthority", 1);
// Load Trustee.IsAuthority=1
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Trustee"], "WHERE ID IN (SELECT ID FROM TrusteeUser WHERE IsAuthority=@IsAuthority)");
da.Fill(currentDataSet, "Trustee");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TrusteeUser"], "WHERE IsAuthority=@IsAuthority");
da.Fill(currentDataSet, "TrusteeUser");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Trustee"], WhereUserQueryFilter);
da.Fill(currentDataSet, "Trustee");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["TrusteeUser"], WhereUserQueryFilter);
da.Fill(currentDataSet, "TrusteeUser");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["FRDBaseDataDeDescricao"], WhereQueryFilter);
da.Fill(currentDataSet, "FRDBaseDataDeDescricao");
}
}
public void GetData(int direction)
{
if ((direction==0 && !mainDS.Tables.Contains("yingshou")) || (direction==1 && !mainDS.Tables.Contains("yingshou")))
{
SqlConnection con = new SqlConnection(services.DBservice.strConn);
SqlDataAdapter sdr = new SqlDataAdapter("select Series 序号,Bill_Num 应收应付源,Sum1 金额,Processor 经办人 from dbo.tb_bills where Direction = @direction", con);
sdr.SelectCommand.Parameters.AddWithValue("@direction", direction);
if (direction == 0)
{
sdr.Fill(mainDS, "yingshou");
dataGridView1.DataMember = "yingshou";
}
else
{
sdr.Fill(mainDS, "yingfu");
dataGridView1.DataMember = "yingfu";
}
dataGridView1.DataSource = mainDS;
}
else if (direction == 0 && mainDS.Tables.Contains("yingshou"))
{
dataGridView1.DataSource = mainDS;
dataGridView1.DataMember = "yingshou";
}
else if (direction == 1 && mainDS.Tables.Contains("yingshou"))
{
dataGridView1.DataSource = mainDS;
dataGridView1.DataMember = "yingfu";
}
else
{
return;
}
}
public static DataSet ExecuteDataset(SqlConnection cn, SqlTransaction trans, string cmdText, string tableName, params SqlParameter[] sqlParams)
{
DataSet data = new DataSet();
try
{
SqlCommand cmd = new SqlCommand(cmdText, cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Transaction = trans;
if (sqlParams != null)
{
AttachParameters(cmd, sqlParams);
}
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
if (tableName != null && tableName != string.Empty)
{
adapter.Fill(data, tableName);
}
else
{
adapter.Fill(data);
}
adapter.Dispose();
cmd.Parameters.Clear();
cmd.Dispose();
}
catch (Exception err)
{
TScope.HandlError(err);
}
return data;
}
/// <summary>
/// Genera un DataAdapter segun un query dado - Solo para grilla paginada.
/// </summary>
public SqlDataAdapter executeQueryAdapter(String query, ref DataSet oDs, ref DataTable oDt,
String dataMember, int inicio, int tope)
{
SqlConnection conn = new SqlConnection(Singleton.ConnectionString);
SqlDataAdapter oAdapter = new SqlDataAdapter(query, conn);
try
{
conn.Open();
try
{
oAdapter.Fill(oDs, inicio, tope, dataMember);
oAdapter.Fill(oDt);
}
finally
{
conn.Close();
}
return oAdapter;
}
catch (Exception ex)
{
throw new Exception("Se detecto un error en executeQueryAdapter con el Query: " + query + System.Environment.NewLine + "Mensaje de Error: " + ex.Message);
}
}
public void readsequentialy()
{
int iter = 0;
int currentIndex = 0;
int pageSize = 3000;
string sql = ConfigurationManager.ConnectionStrings["t2"].ConnectionString;
string sqltest = ConfigurationManager.ConnectionStrings["test"].ConnectionString;
SqlConnection connection = new SqlConnection(sql);
string orderSQL = "SELECT * FROM [dbo].[TransactionHistory] order by [TransactionID]";
// Assumes that connection is a valid SqlConnection object.
SqlDataAdapter adapter = new SqlDataAdapter(orderSQL, connection);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, currentIndex, pageSize, "Orders");
DataTable dataTable = dataSet.Tables[0];
while (dataTable.Rows.Count > 0)
{
Console.WriteLine("iteration: " + iter++);
foreach (DataRow row in dataTable.Rows)
{
row.SetAdded();
}
//BultInsert(pageSize, sqltest, dataTable);
currentIndex += pageSize;
dataSet.Tables["Orders"].Rows.Clear();
adapter.Fill(dataSet, currentIndex, pageSize, "Orders");
dataTable = dataSet.Tables[0];
}
Console.WriteLine(String.Format("done rows: {0} with iteration: {1}", iter * pageSize, iter));
}
private void Frm_Main_Load(object sender, EventArgs e)
{
string ConnectionString = "server=(local); database=db_TomeTwo; uid=sa; pwd=6221131";//声明连接字符串
using (SqlConnection Conn = new SqlConnection(ConnectionString))//创建数据库连接对象
{
string sqlstr = "select * from tb_Register";//定义查询语句
SqlDataAdapter da = new SqlDataAdapter(sqlstr, Conn);//创建数据桥接器对象
DataSet ds = new DataSet();//创建数据对象
da.Fill(ds, "register");//填充第一个数据表数据到DataSet
sqlstr = "select * from tb_Sale";//定义查询语句
da.SelectCommand.CommandText = sqlstr;//指定第二条查询语句
da.Fill(ds, "sale");//填充第二个数据表数据到DataSet
//查询有销售记录的药品信息
var result = from r in ds.Tables["register"].AsEnumerable()
join s in ds.Tables["sale"].AsEnumerable()
on r.Field<string>("药品编号") equals s.Field<string>("药品编号")
select new
{
drug_name = r["药品名称"].ToString(),
drug_factory = r["生产厂家"].ToString(),
drug_sale = s["销售额"].ToString()
};
foreach (var item in result) //遍历输出查询结果
{
richTextBox1.Text += "药品名称：" + item.drug_name + "******生产厂家：" + item.drug_factory + "******销售额：" + item.drug_sale + "\n";
}
}
}
public static DataSet ExecuteDataset(SqlConnection cn, SqlTransaction trans, string cmdText, string tableName, params SqlParameter[] sqlParams)
{
DataSet data = new DataSet();
SqlCommand cmd = new SqlCommand(cmdText, cn);
cmd.CommandType = CommandType.Text;
cmd.Transaction = trans;
if (sqlParams != null)
{
AttachParameters(cmd, sqlParams);
}
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
if (tableName != null && tableName != string.Empty)
{
adapter.Fill(data, tableName);
}
else
{
adapter.Fill(data);
}
adapter.Dispose();
cmd.Parameters.Clear();
cmd.Dispose();
return data;
}
public override void LoadDataModuloPermissoes(DataSet CurrentDataSet, Int16 IDTipoFunctionGroup, Int16 IdxTipoFunction, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@IDTipoFunctionGroup", IDTipoFunctionGroup);
command.Parameters.AddWithValue("@IdxTipoFunction", IdxTipoFunction);
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["Trustee"]);
da.Fill(CurrentDataSet, "Trustee");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteeUser"]);
da.Fill(CurrentDataSet, "TrusteeUser");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteeGroup"]);
da.Fill(CurrentDataSet, "TrusteeGroup");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["UserGroups"]);
da.Fill(CurrentDataSet, "UserGroups");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(CurrentDataSet.Tables["TrusteePrivilege"],
" WHERE TrusteePrivilege.IDTipoFunctionGroup=@IDTipoFunctionGroup AND TrusteePrivilege.IdxTipoFunction=@IdxTipoFunction");
da.Fill(CurrentDataSet, "TrusteePrivilege");
}
}
private void buscarP_Click(object sender, EventArgs e)
{
if(producto.TextLength>0)
{
dtingresos.Clear();
dtsalidas.Clear();
using (SqlConnection con = new SqlConnection("Server=localhost; database=INVERSEC_3; integrated security=yes"))
{
try
{
SqlCommand comando = new SqlCommand("SELECT pro.nombre Proveedor,p.cod_pro Codigo,p.nombre Nombre,p.descripcion Descripcion,b.nombre Bodega, CONVERT(VARCHAR,f.fecha,105) Fecha, sum(fp.cantidad) Cantidad from PRODUCTO p join FACT_PRODUCTO fp on p.cod_pro=fp.cod_pro and p.nombre=@nombre join FACTURA f on f.num_fact=fp.num_fact join bodega b on p.cod_bodega=b.cod_bodega join PROVEEDOR pro on pro.rut_emp=f.rut_pro group by f.fecha,p.cod_pro,p.nombre,p.descripcion,b.nombre,pro.nombre", con);
comando.Parameters.AddWithValue("@nombre", producto.Text);
SqlDataAdapter da = new SqlDataAdapter(comando);
da.Fill(dtingresos);
dgvi.DataSource = dtingresos;
comando.CommandText = "SELECT cli.nombre Cliente,p.cod_pro Codigo,p.nombre Nombre,p.descripcion Descripcion,b.nombre Bodega, CONVERT(VARCHAR,f.fecha,105) Fecha, sum(fp.cantidad) Cantidad from PRODUCTO p join FACT_PRODUCTO fp on p.cod_pro=fp.cod_pro and p.nombre=@nombre join FACTURA f on f.num_fact=fp.num_fact join bodega b on p.cod_bodega=b.cod_bodega join Cliente cli on cli.rut_emp=f.rut_cli group by f.fecha,p.cod_pro,p.nombre,p.descripcion,b.nombre,cli.nombre ";
da.Fill(dtsalidas);
dgvs.DataSource = dtsalidas;
}
catch (Exception ev)
{
MessageBox.Show("Error al intentar consultar la base de datos: " + ev.ToString());
}
}
}
else
{
MessageBox.Show("Debe ingresar un nombre de prodcuto");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!(bool)Session["logedIn"])
{
Response.Redirect("Login.aspx");
}
lblKorisnik.Text = (string)Session["userName"];
lblGrupa.Text = (string)Session["userGroup"];
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MojaKonekcija"].ConnectionString);
var cmd = new SqlCommand("SELECT * FROM korisnici WHERE korisnicko_ime LIKE @username", con);
cmd.Parameters.Add("@username", SqlDbType.NVarChar).Value = lblKorisnik.Text;
SqlDataAdapter adptr = new SqlDataAdapter();
adptr.SelectCommand = cmd;
SqlCommandBuilder cmdBld = new SqlCommandBuilder(adptr);
DataTable mojDataTable = new DataTable();
DataSet mojDataSet = new DataSet();
adptr.Fill(mojDataSet);
adptr.Fill(mojDataTable);
var email= (string)mojDataTable.Rows[0]["email"];
txtMail.Text = email;
}
private void LoadPage()
{
string pageUrl = this.Page.RouteData.Values["PageUrl"].ToString();
string connString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
using (SqlConnection sqlConn = new SqlConnection(connString))
{
using (SqlCommand sqlCmd = new SqlCommand())
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
sqlCmd.Parameters.AddWithValue("@PageUrl", pageUrl);
sqlCmd.Connection = sqlConn;
sqlCmd.CommandText = "dbo.GetPageContent";
sqlCmd.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
sda.SelectCommand=sqlCmd;
sda.Fill(ds);
DataTable dt = ds.Tables[0];
sda.Fill(dt);
lblTitle.Text = dt.Rows[0]["Title"].ToString();
lblContent.Text = dt.Rows[0]["Content"].ToString();
}
}
}
}
public DataTable createChargeTable()
{
serviceChargeTable.Clear();
tablecharge.Clear();
tablecharge3.Clear();
DataTable tablecharge2 = new DataTable();
tablecharge2.Columns.Add("Kodu", typeof(Int32));
tablecharge2.Columns.Add("Adı", typeof(String));
tablecharge2.Columns.Add("Soyadı", typeof(String));
tablecharge2.Columns.Add("Toplam Alacak", typeof(Decimal));
tablecharge2.Columns.Add("Para Birimi", typeof(String));
createConnection();
SqlDataAdapter adapter = new SqlDataAdapter("Select * from chargeLastView", connection);
adapter.Fill(tablecharge);
SqlDataAdapter adapterService = new SqlDataAdapter("Select * from serviceChargeView", connection);
adapter.Fill(serviceChargeTable);
for (int i = 0; i < tablecharge.Rows.Count; i++)
{
if (Convert.ToDecimal(tablecharge.Rows[i][3])-Convert.ToDecimal(tablecharge.Rows[i][4])>0)
{
tablecharge2.Rows.Add(tablecharge.Rows[i][0], tablecharge.Rows[i][1], tablecharge.Rows[i][2], (Convert.ToDecimal(tablecharge.Rows[i][3]) - Convert.ToDecimal(tablecharge.Rows[i][4])), "TL");
}
}
tablecharge3 = tablecharge2;
return tablecharge2;
}
private void BindGrid()
{
string cmd = "SELECT username [UserName],hash [Password Hash], auth_level [Authentication Level] FROM LOGIN";
DataSet ds = new DataSet();
SqlConnection = new SqlConnection(ConfigurationManager.AppSettings["SQLAddress"]);
SqlConnection.Open();
SqlCommand = new SqlCommand(cmd, SqlConnection);
SqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter(SqlCommand);
SqlDataAdapter.Fill(ds, "tblMain");
int totRecs = ds.Tables["tblMain"].Rows.Count;
SqlDataAdapter.Fill(ds, startIndex, pageSize, "t1");
GridView1.DataSource = ds.Tables["t1"];
GridView1.DataBind();
SqlDataAdapter.Dispose();
SqlCommand.Dispose();
System.Text.StringBuilder sbPager = new System.Text.StringBuilder();
for (int i = 1; i <= totPages; i++)
{
sbPager.Append("<a href=\"About.aspx?pg=").Append(i.ToString()).Append("\">").Append(i.ToString()).Append("</a>");
sbPager.Append(" | ");
}
divPager.InnerHtml = sbPager.ToString();
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["Nash"].ConnectionString);
SqlCommand cmd = new SqlCommand("select * from Categories", con);
SqlCommand cmd1 = new SqlCommand("select * from Products", con);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
DataSet dataSet = new DataSet();
con.Open();
adapter.Fill(dataSet, "Categories");
adapter.SelectCommand = cmd1;
adapter.Fill(dataSet, "Products");
con.Close();
DataRelation relation = new DataRelation("primary", dataSet.Tables["Categories"].Columns["CategoryID"], dataSet.Tables["Products"].Columns["CategoryID"]);
dataSet.Relations.Add(relation);
DataColumn column1 = new DataColumn("no. of products", typeof(int), "Count(Child(primary).CategoryID)");
dataSet.Tables["Categories"].Columns.Add(column1);
GridView1.DataSource = dataSet;
GridView1.DataBind();
//DataView view = new DataView(dataSet.Tables["Categories"]);
//view.RowFilter = "Count(Child(primary).CategoryID) > 1";
//GridView1.DataSource = view;
//GridView1.DataBind();
//GridView1.DataSource = dataSet;
//GridView1.DataMember = "Categories";
//GridView1.DataBind();
}
private void AbmCliente_Load(object sender, EventArgs e)
{
SqlConnection dbcon = new SqlConnection(GrouponDesktop.Properties.Settings.Default["conStr"].ToString());
SqlCommand cmd = new SqlCommand(@"Select nombre, idCiudad
from LOSGROSOS_RELOADED.Ciudad", dbcon);
DataTable dt = new DataTable();
DataTable dt2 = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
dbcon.Open();
da.Fill(dt);
da.Fill(dt2);
}
catch (Exception ex)
{
Support.mostrarError(ex.Message);
}
dbcon.Close();
this.lstCiudadesElegidas.DataSource = dt;
this.lstCiudadesElegidas.DisplayMember = "nombre";
this.lstCiudadesElegidas.ValueMember = "idCiudad";
this.cmbCiudades.DataSource = dt2;
this.cmbCiudades.DisplayMember = "nombre";
this.cmbCiudades.ValueMember = "idCiudad";
DateTime fechaActual = Support.fechaConfig();
this.monthCalendar1.MaxDate = fechaActual;
this.monthCalendar1.TodayDate = fechaActual;
}
private void FillDefaultData()
{
AccTypesTbl = new DataTable("FalseX");
FinlAccTbl = new DataTable("FalseX");
SqlDataAdapter da = new SqlDataAdapter("",FXFW.SqlDB.SqlConStr);
try
{
//Load All Account Types
da.SelectCommand.CommandText = "SELECT AccNatueID, AccNatueName FROM CDAccountNature";
da.Fill(AccTypesTbl);
//Load All Finall Accounts
da.SelectCommand.CommandText = "SELECT KhtamiaccID, KhtamiaccName FROM CDKHTAMIACOUNT";
da.Fill(FinlAccTbl);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
LUEAccType.Properties.DataSource = AccTypesTbl;
LUEAccType.Properties.DisplayMember = "AccNatueName";
LUEAccType.Properties.ValueMember = "AccNatueID";
LUEAccEndCount.Properties.DataSource = FinlAccTbl;
LUEAccEndCount.Properties.DisplayMember = "KhtamiaccName";
LUEAccEndCount.Properties.ValueMember = "KhtamiaccID";
}
private void Form1_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand comm = new SqlCommand("select * from UserData",con);
DataTable master = new DataTable();
DataTable child = new DataTable();
// Fill Table 2 with Data
SqlDataAdapter da = new SqlDataAdapter(comm);
da.Fill(master);
// Fill Table1 with data
comm = new SqlCommand("select * from UserDetail",con);
da.Fill(child);
con.Close();
DataSet ds = new DataSet();
//Add two DataTables in Dataset
ds.Tables.Add(master);
ds.Tables.Add(child);
// Create a Relation in Memory
DataRelation relation = new DataRelation("",ds.Tables[0].Columns[0],ds.Tables[1].Columns[0],true);
ds.Relations.Add(relation);
dataGrid1.DataSource = ds.Tables[0];
}
public override void LoadSelectedData(DataSet currentDataSet, long IDNivel, long IDTipoFRDBase, IDbConnection conn)
{
using (SqlCommand command = SqlSyntax.CreateSelectCommandWithNoDeletedRowsParam((SqlConnection)conn))
using (SqlDataAdapter da = new SqlDataAdapter(command))
{
command.Parameters.AddWithValue("@IDNivel", IDNivel);
command.Parameters.AddWithValue("@IDTipoFRDBase", IDTipoFRDBase);
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["Nivel"],
"WHERE ID=@IDNivel");
da.Fill(currentDataSet, "Nivel");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["FRDBase"],
"WHERE IDNivel=@IDNivel AND IDTipoFRDBase=@IDTipoFRDBase");
da.Fill(currentDataSet, "FRDBase");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["ControloAut"],
"INNER JOIN NivelControloAut nca ON nca.IDControloAut = ControloAut.ID " +
"WHERE nca.ID=@IDNivel");
da.Fill(currentDataSet, "ControloAut");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["ControloAutDatasExistencia"],
"INNER JOIN NivelControloAut nca ON nca.IDControloAut = ControloAutDatasExistencia.IDControloAut " +
"WHERE nca.ID=@IDNivel");
da.Fill(currentDataSet, "ControloAutDatasExistencia");
da.SelectCommand.CommandText = SqlSyntax.CreateSelectCommandText(currentDataSet.Tables["NivelControloAut"],
"WHERE ID=@IDNivel");
da.Fill(currentDataSet, "NivelControloAut");
}
}
protected void cvTitle_ServerValidate(object source, ServerValidateEventArgs args)
{
SqlDataAdapter da = new SqlDataAdapter("", connection);
DataTable dt = new DataTable();
DataTable dl = new DataTable();
da.SelectCommand.CommandText = "SELECT * FROM Skills WHERE ID = @sxid";
da.SelectCommand.Parameters.AddWithValue("@sxid", Request.QueryString["Sid"]);
da.Fill(dl);
//Consept : Check if TextBox' value has changed or not
//If This part doesn't Exist -> the page won't be valid Because of the next part of Validation. WHY? ...
//if the title isn't changed the next part cause invalidation beacuse the Title has already Exist
if (dl.Rows[0]["Title"].ToString() != txtTitle.Text)
{
da.SelectCommand.CommandText = "SELECT * FROM Skills WHERE Title=@t AND Cat_ID=@scid";
da.SelectCommand.Parameters.AddWithValue("@t", txtTitle.Text);
da.SelectCommand.Parameters.AddWithValue("@scid", ddlSkillCat.SelectedValue);
da.Fill(dt);
//If the TextBox' Value has changed ...
//So , Now Check if The New Value has already Exist in Table or not
if (dt.Rows.Count == 0)
{
args.IsValid = true;
}
else
args.IsValid = false;
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
// Create the Connection, DataAdapter, and DataSet.
string connectionString = "Data Source=localhost;Initial Catalog=Northwind;" +
"Integrated Security=SSPI";
SqlConnection con = new SqlConnection(connectionString);
string sqlCat = "SELECT CategoryID, CategoryName FROM Categories";
string sqlProd = "SELECT ProductName, CategoryID FROM Products";
SqlDataAdapter da = new SqlDataAdapter(sqlCat, con);
DataSet ds = new DataSet();
try
{
con.Open();
// Fill the DataSet with the Categories table.
da.Fill(ds, "Categories");
// Change the command text and retrieve the Products table.
// You could also use another DataAdapter object for this task.
da.SelectCommand.CommandText = sqlProd;
da.Fill(ds, "Products");
}
finally
{
con.Close();
}
// Define the relationship between Categories and Products.
DataRelation relat = new DataRelation("CatProds",
ds.Tables["Categories"].Columns["CategoryID"],
ds.Tables["Products"].Columns["CategoryID"]);
// Add the relationship to the DataSet.
ds.Relations.Add(relat);
// Loop through the category records and build the HTML string.
StringBuilder htmlStr = new StringBuilder("");
foreach (DataRow row in ds.Tables["Categories"].Rows)
{
htmlStr.Append("<b>");
htmlStr.Append(row["CategoryName"].ToString());
htmlStr.Append("</b><ul>");
// Get the children (products) for this parent (category).
DataRow[] childRows = row.GetChildRows(relat);
// Loop through all the products in this category.
foreach (DataRow childRow in childRows)
{
htmlStr.Append("<li>");
htmlStr.Append(childRow["ProductName"].ToString());
htmlStr.Append("</li>");
}
htmlStr.Append("</ul>");
}
// Show the generated HTML code.
HtmlContent.Text = htmlStr.ToString();
}
public void GetData()
{
try
{
con = new SqlConnection(cs);
con.Open();
cmd = new SqlCommand("SELECT StockId as [Stock ID], (productName) as [Product Name],Features,sum(Quantity) as [Quantity],Price,sum(TotalPrice) as [Total Price] from Config,Stock where Config.ConfigID=Stock.ConfigID group by Stockid, productname,features,price having (sum(Quantity) > 0) order by Productname", con);
var myDA = new SqlDataAdapter(cmd);
var myDataSet = new DataSet();
myDA.Fill(myDataSet, "Stock");
myDA.Fill(myDataSet, "Config");
dataGridView1.DataSource = myDataSet.Tables["Stock"].DefaultView;
dataGridView1.DataSource = myDataSet.Tables["Config"].DefaultView;
con.Close();
var header = new string[]
{ "รหัส", "ชื่อสินค้า", "รายละเอียด", "จำนวน", "ราคา", "รวม"
};
for (var i = 0; i < header.Length; i++)
{
dataGridView1.Columns[i].HeaderText = header[i];
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public DataSet GetDataSet()
{
try
{
using (SqlConnection conn = new SqlConnection())
{
string connectionString = WebConfigurationManager.AppSettings["connectionString"];
conn.ConnectionString = connectionString;
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet ds = new DataSet();
adapter.SelectCommand = new SqlCommand("SELECT * FROM Student", conn);
adapter.Fill(ds, "Student");
adapter.SelectCommand = new SqlCommand("SELECT * FROM Course", conn);
adapter.Fill(ds, "Course");
adapter.SelectCommand = new SqlCommand("SELECT * FROM SC", conn);
adapter.Fill(ds, "SC");
return ds;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void LoadData()
{
//string mid = Session["Mid"].ToString();
string mid = "930251337";
SqlDataAdapter da = new SqlDataAdapter("", connection);
DataTable dt = new DataTable();
da.SelectCommand.CommandText = "SELECT * FROM MemberList WHERE Mid = @mid";
da.SelectCommand.Parameters.AddWithValue("@mid", mid);
da.Fill(dt);
if (dt.Rows[0]["ImageExtention"].ToString().Length != 0)
{
imgProfile.ImageUrl = dt.Rows[0]["Image"].ToString() + dt.Rows[0]["ImageExtention"].ToString();
}
lblFullNameUP.Text = dt.Rows[0]["FullName"].ToString();
lblMembershipStatusUP.Text = dt.Rows[0]["Status_ID"].ToString();
lblFieldUP.Text = dt.Rows[0]["Title"].ToString();
lblBioUP.Text = dt.Rows[0]["Bio"].ToString();
if (dt.Rows[0]["Github"].ToString().Length == 0)
github.Visible = false;
else
{
lblgithub.Text ='/' + dt.Rows[0]["Github"].ToString();
github.HRef = "https://github.com/" + dt.Rows[0]["Github"].ToString();
}
if (dt.Rows[0]["Linkedin"].ToString().Length == 0)
linkedin.Visible = false;
else
{
lblLinkedin.Text ='/' + dt.Rows[0]["Linkedin"].ToString();
//linkedin.HRef = "https://Linkedin.com/" + dt.Rows[0]["Linkedin"].ToString();
}
if (dt.Rows[0]["Twitter"].ToString().Length == 0)
twitter.Visible = false;
else
{
lblTwitter.Text ='/' + dt.Rows[0]["Twitter"].ToString();
//twitter.HRef = "https://Twitter.com/" + dt.Rows[0]["Twitter"].ToString();
}
lblFirstName.Text = dt.Rows[0]["FirstName"].ToString();
lblLastName.Text = dt.Rows[0]["LastName"].ToString();
lblField.Text = dt.Rows[0]["Title"].ToString();
lblPhone1.Text = dt.Rows[0]["PhoneNumber"].ToString();
lblPhone2.Text = dt.Rows[0]["AltPhoneNumber"].ToString();
lblEmail.Text = dt.Rows[0]["Email"].ToString();
lblNationalID.Text = dt.Rows[0]["NationalID"].ToString();
lblStudentID.Text = dt.Rows[0]["Mid"].ToString();
da.SelectCommand.Parameters.Clear();
dt.Clear();
da.SelectCommand.CommandText = "SELECT * FROM MemberSkillList WHERE Member_ID = @mid2";
da.SelectCommand.Parameters.AddWithValue("@mid2", mid);
da.Fill(dt);
dlSkills.DataSource = dt;
dlSkills.DataBind();
da.SelectCommand.Parameters.Clear();
dt.Clear();
}
/// <summary>
/// xử lý sự kiện khi ấn nút submit, bao gồm nhập dữ liệu cho 2 bảng là User và UserResult
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (txtName.Text != null)
{
/*--khai báo tất cả các component từ việc nạp dữ liệu--*/
//query cho bảng User dùng để add User
string queryForAddUser = "******";
//query cho bảng UserResult dùng để add UserResult
string queryForAddUserInUserResult = "select * from [PrePool].[dbo].[UserResult]";
SqlDataAdapter adapter1 = new SqlDataAdapter(queryForAddUser, conn);
SqlDataAdapter adapter2 = new SqlDataAdapter(queryForAddUserInUserResult, conn);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter1);
SqlCommandBuilder builder2 = new SqlCommandBuilder(adapter2);
adapter1.Fill(ds, "User");
adapter2.Fill(ds, "UserResult");
//khai báo 2 trường name và mail trong table User
string name = txtName.Text;
string mail = txtEmail.Text;
//add value cho bảng User
DataRow newAdmin = ds.Tables["User"].NewRow();
//add 2 collumn name va email (id tu tăng)
newAdmin["name"] = name;
newAdmin["email"] = mail;
ds.Tables["User"].Rows.Add(newAdmin);
adapter1.Update(ds.Tables["User"]);
/*-- xu ly để lấy userId và resultId --*/
//đổ lại vào table User
adapter1.Fill(ds, "User");
//lay vị trí của row vừa add
int count = ds.Tables["User"].Rows.Count - 1;
//xuat ra [id] cua row moi nhat - row vua add
string userIdStringType = ds.Tables["User"].Rows[count]["id"].ToString();
//userId
int userId = Int32.Parse(userIdStringType);
//resultId lấy từ text cua checkbox
int resultId;
//add value cho bang UserResult với từng chechbox được check
foreach (CheckBox cb in checkedList)
{
DataRow newUserResult = ds.Tables["UserResult"].NewRow();
resultId = Int32.Parse(cb.Text);
//add 2 collumn resultId va userId
newUserResult["resultId"] = resultId;
newUserResult["userId"] = userId;
ds.Tables["UserResult"].Rows.Add(newUserResult);
}
adapter2.Update(ds.Tables["UserResult"]);
//cảm ơn người dùng
MsgBox("ありがとうございます");
}
//refresh lại trang mới
checkedList.Clear();
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
protected void Page_Load(object sender, EventArgs e)
{
string v_term= "";
string cmdText_TermsSearchResult = "";
string cmdText_categoryBreadCrumb = "";
cmdText_TermsSearchResult = "SELECT Term_Key, Term_Name, Parent_Category, Short_Description,Long_Description,Status FROM Terms where term_name like @Term_Name and active='Y' order by Term_Name";
cmdText_categoryBreadCrumb = cmdText_categoryBreadCrumb + "WITH Hierarchy(Term_Key, Category_key, Category_Name, Parent_category, HLevel) AS ( ";
cmdText_categoryBreadCrumb = cmdText_categoryBreadCrumb + "select te.term_key, ca.category_key, ca.category_name, ca.parent_category, 0 as Hlevel ";
cmdText_categoryBreadCrumb = cmdText_categoryBreadCrumb + "from categories ca, (SELECT Term_Key, Term_Name, Parent_Category FROM Terms where term_name like @Term_Name and active='Y') te ";
cmdText_categoryBreadCrumb = cmdText_categoryBreadCrumb + "where (upper(te.parent_category) = upper(ca.parent_category+'>>'+ca.category_name) ";
cmdText_categoryBreadCrumb = cmdText_categoryBreadCrumb + "or upper(te.parent_category) = upper(ca.category_name) ) and ca.active='Y' ";
cmdText_categoryBreadCrumb = cmdText_categoryBreadCrumb + "UNION ALL ";
cmdText_categoryBreadCrumb = cmdText_categoryBreadCrumb + "SELECT child.term_key, parent.category_key, parent.category_name, parent.parent_category,HLevel + 1 ";
cmdText_categoryBreadCrumb = cmdText_categoryBreadCrumb + "FROM Categories parent ";
cmdText_categoryBreadCrumb = cmdText_categoryBreadCrumb + "INNER JOIN Hierarchy child ";
cmdText_categoryBreadCrumb = cmdText_categoryBreadCrumb + "ON upper(child.parent_category) = upper(case when isnull(parent.parent_category,'')='' then parent.category_name else parent.parent_category+'>>'+parent.category_name end) ) ";
cmdText_categoryBreadCrumb = cmdText_categoryBreadCrumb + "SELECT term_key, Category_key, Category_Name, Parent_category, HLevel FROM Hierarchy ";
cmdText_categoryBreadCrumb = cmdText_categoryBreadCrumb + "ORDER BY term_key, HLevel DESC ";
// cmdText_categoryBreadCrumb = cmdText_categoryBreadCrumb + "SELECT terms.term_key, Results.OrderOfOccurrence, Results.StringName, Category_key FROM categories, terms OUTER APPLY dbo.SplitString(terms.parent_category,'>>') AS Results WHERE term_name like @Term_Name and Results.StringName = categories.Category_name order by term_key, Results.OrderOfOccurrence ";
if (!string.IsNullOrEmpty(Request["query"]))
{
if (Request["hdnSearchType"] == "srchBox")
v_term = '%' + Request["query"] + '%';
else
v_term = Request["query"] + '%';
}
else
{
Response.Redirect("default.aspx");
}
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString);
SqlDataAdapter cmd = new SqlDataAdapter();
DataSet ds = new DataSet();
SqlCommand selectCMD = new SqlCommand();
selectCMD = new SqlCommand(cmdText_TermsSearchResult, conn);
selectCMD.Parameters.Add("@Term_Name", SqlDbType.NVarChar, 255).Value = v_term;
cmd.SelectCommand = selectCMD;
cmd.Fill(ds, "Terms");
selectCMD = new SqlCommand(cmdText_categoryBreadCrumb, conn);
selectCMD.Parameters.Add("@Term_Name", SqlDbType.NVarChar, 255).Value = v_term;
cmd.SelectCommand = selectCMD;
cmd.Fill(ds, "Category");
ds.Relations.Add("myrelation",
ds.Tables["Terms"].Columns["term_key"],
ds.Tables["Category"].Columns["term_key"]);
rptrSearchResult.DataSource = ds.Tables["Terms"];
Page.DataBind();
conn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
QAQuestions pitanje = new QAQuestions();
List<QAQuestions> Pitanja = new List<QAQuestions>();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataRow dr = null;
string Question = Request.QueryString["IdQuestion"];
SqlCommand cmd = new SqlCommand("SELECT dbo.QAPitanja.Id AS IdPitanje, dbo.QAPitanja.NaslovPitanja, dbo.QAPitanja.Pitanje FROM dbo.QAPitanja Where dbo.QAPitanja.Id=@IdPitanje", connection);
cmd.Parameters.AddWithValue("@IdPitanje", Question);
dt.Columns.Add("IdPitanje");
dt.Columns.Add("NaslovPitanja");
dt.Columns.Add("Pitanje");
connection.Open();
try
{
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds, "QAPitanja");
da.Fill(dt);
SqlDataReader reader = cmd.ExecuteReader();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dr = dt.NewRow();
dr["IdPitanje"] = ds.Tables[0].Rows[i]["IdPitanje"].ToString();
dr["NaslovPitanja"] = ds.Tables[0].Rows[i]["NaslovPitanja"].ToString();
dr["Pitanje"] = ds.Tables[0].Rows[i]["Pitanje"].ToString();
reader.Close();
connection.Close();
pitanje = new QAQuestions();
pitanje.Id = Convert.ToInt32(dr["IdPitanje"].ToString());
pitanje.NaslovPitanja = dr["NaslovPitanja"].ToString();
pitanje.Pitanje = dr["Pitanje"].ToString();
}
}
catch (Exception ex) { }
finally
{
connection.Close();
}
Pitanja.Add(pitanje);
Repeater1.DataSource = Pitanja;
Repeater1.DataBind();
if (!Page.IsPostBack)
{
txtPrijedlogNaslova.Text = pitanje.NaslovPitanja;
txtPrijedlogPitanja.Text = pitanje.Pitanje;
}
}
public void buscar(string sql)
{
cmd = new SqlCommand(sql, Conexion.conectar());
da = new SqlDataAdapter(cmd);
da.Fill(dt);
da.Fill(ds);
Conexion.desconectar();
}
public ActionResult Register(RegisterViewModal rg)
{
sayazilimEntities db = new sayazilimEntities();
try
{
var firmalarlist = db.Firmalar.Where(x => x.FirmaEMail == rg.Email).ToList();
if (firmalarlist.Count == 0)
{
Firmalar fr = new Firmalar();
fr.FirmaAdi = rg.FirmaIsmi;
string sifre = rg.Password;
fr.FirmaEMail = rg.Email;
fr.FirmaTel = rg.FirmaTel;
var firmalist = db.Firmalar.OrderByDescending(x => x.ID).FirstOrDefault();
if (firmalist != null)
{
int i = Convert.ToInt32(firmalist.FirmaID + 1);
fr.FirmaID = i;
}
else
{
fr.FirmaID = 2;
}
DateTime kayittarih = DateTime.Now;
kayittarih = kayittarih.AddDays(15);
fr.KayitTarih = kayittarih;
Personel pr = new Personel();
pr.Adi = "Admin";
pr.Soyadi = "";
pr.Pozisyonu = "Admin";
pr.PersonelGrubu = "Admin";
pr.FirmaID = Convert.ToInt16(fr.FirmaID);
pr.sCariID = -1;
pr.WebKA = rg.KullaniciAdi;
pr.WebSifre = GirisKontrol.hash(sifre, true);
fr.Demo = true;
db.Personel.Add(pr);
db.Firmalar.Add(fr);
db.SaveChanges();
#region YeniFirmaKontrol
int firmaid = Convert.ToInt16(pr.FirmaID);
var setting = db.Ayarlar.Where(x => x.FirmaID == firmaid).ToList();
if (setting.Count == 0)
{
DataRow dt = null;
using (SqlConnection con = new SqlConnection(AyarMetot.conString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlDataAdapter da =
new System.Data.SqlClient.SqlDataAdapter(
"select * from AYARLAR where ID='1'", con))
{
using (SqlCommandBuilder cb = new SqlCommandBuilder(da))
{
DataSet ds = new DataSet();
da.Fill(ds, "AYARLAR");
DataRow[] adf = ds.Tables["AYARLAR"].Select("ID='1'");
if (adf.Length != 0)
{
dt = adf[0];
}
}
}
}
using (SqlConnection con = new SqlConnection(AyarMetot.strcon))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("select Top 1 * from AYARLAR where FirmaID=" + firmaid.ToString(), con))
{
using (SqlCommandBuilder cb = new SqlCommandBuilder(da))
{
DataSet ds = new DataSet();
da.Fill(ds, "AYARLAR");
DataRow df = ds.Tables["AYARLAR"].NewRow();
df.ItemArray = dt.ItemArray.Clone() as object[];
df["FirmaID"] = fr.FirmaID;
df["Version"] = KODLA.Kapa(rg.Pakettipi, AyarMetot.ilhan_Control);
df["fMail"] = "";
df["fMailSifre"] = "";
df["fMailSender"] = "";
df["SMSUser"] = "";
df["SMSPass"] = "";
df["MesajSonu"] = "";
df["BorcMesajSonu"] = "";
df["SmsSender"] = "";
df["EFatGB"] = "";
df["EFatKA"] = "";
df["EFatSifre"] = "";
df["EIrsKA"] = "";
df["EIrsSF"] = "";
df["KurumKodu"] = "";
df["EIrsGB"] = "";
df["Entegrator"] = "";
df["PostaSunucu"] = "";
df["ServisBorclandirsin"] = 1;
string company_code = "SA01" + fr.FirmaID.ToString().PadLeft(3, '0');
df["Company_Code"] = company_code;
ds.Tables["AYARLAR"].Rows.Add(df);
da.Update(ds, "AYARLAR");
}
}
}
}
var compony = db.COMPANY_DETAIL.Where(x => x.FirmaID == firmaid).ToList();
if (compony.Count == 0)
{
DataRow dt = null;
using (SqlConnection con = new SqlConnection(AyarMetot.conString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlDataAdapter da =
new System.Data.SqlClient.SqlDataAdapter(
"select * from COMPANY_DETAIL where ID='1'", con))
{
using (SqlCommandBuilder cb = new SqlCommandBuilder(da))
{
DataSet ds = new DataSet();
da.Fill(ds, "COMPANY_DETAIL");
DataRow[] adf = ds.Tables["COMPANY_DETAIL"].Select("ID='1'");
if (adf.Length != 0)
{
dt = adf[0];
}
}
}
}
using (SqlConnection con = new SqlConnection(AyarMetot.strcon))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("select Top 1 * from COMPANY_DETAIL", con))
{
using (SqlCommandBuilder cb = new SqlCommandBuilder(da))
{
DataSet ds = new DataSet();
da.Fill(ds, "COMPANY_DETAIL");
DataRow df = ds.Tables["COMPANY_DETAIL"].NewRow();
df.ItemArray = dt.ItemArray.Clone() as object[];
Firmalar frm = db.Firmalar.Where(x => x.FirmaID == firmaid).FirstOrDefault();
df["FirmaAdi"] = frm.FirmaAdi;
string company_code = "SA01" + fr.FirmaID.ToString().PadLeft(3, '0');
df["Company_Code"] = company_code;
Personel pb = db.Personel.OrderByDescending(x => x.ID).FirstOrDefault();
df["IlgiliKisi"] = (pb.Adi + pb.Soyadi).TrimEnd();
Firmalar dr = db.Firmalar.Where(x => x.FirmaID == firmaid).FirstOrDefault();
df["Telefon"] = dr.FirmaTel;
df["Faks"] = "";
df["ePosta"] = dr.FirmaEMail;
df["WebSite"] = "";
df["VergiDairesi"] = "";
df["VergiNo"] = "";
df["Ulke"] = "";
df["Sehir"] = "";
df["PostaKodu"] = "";
df["Adres"] = "";
df["TicaretSicilNo"] = "";
df["MersisNo"] = "";
df["Ilce"] = "";
df["FirmaID"] = fr.FirmaID;
ds.Tables["COMPANY_DETAIL"].Rows.Add(df);
da.Update(ds, "COMPANY_DETAIL");
}
}
}
}
var stk_ktg = db.STK_KATEGORI.Where(x => x.FirmaID == firmaid).ToList();
if (stk_ktg.Count == 0)
{
int i = 7;
for (int j = 1; j < i; j++)
{
STK_KATEGORI stk = new STK_KATEGORI();
stk.FirmaID = fr.FirmaID;
stk.Name = "Stok Kategori " + j;
string company_code = "SA01" + fr.FirmaID.ToString().PadLeft(3, '0');
stk.Company_Code = company_code;
db.STK_KATEGORI.Add(stk);
db.SaveChanges();
}
}
var special = db.SPECIAL_TECH.Where(x => x.FirmaID == firmaid).ToList();
if (special.Count == 0)
{
int i = 11;
for (int j = 1; j < i; j++)
{
SPECIAL_TECH stk = new SPECIAL_TECH();
stk.FirmaID = Convert.ToInt16(fr.FirmaID);
stk.Name = "Özel Alan " + j;
string company_code = "SA01" + fr.FirmaID.ToString().PadLeft(3, '0');
stk.Company_Code = company_code;
db.SPECIAL_TECH.Add(stk);
db.SaveChanges();
}
}
var carikategori = db.CARI_KATEGORI.Where(x => x.FirmaID == firmaid).ToList();
if (carikategori.Count == 0)
{
int i = 7;
for (int j = 1; j < i; j++)
{
CARI_KATEGORI stk = new CARI_KATEGORI();
stk.FirmaID = firmaid;
stk.Name = "Cari Kategori " + j;
string company_code = "SA01" + fr.FirmaID.ToString().PadLeft(3, '0');
stk.Company_Code = company_code;
db.CARI_KATEGORI.Add(stk);
db.SaveChanges();
}
}
var faturaekbilgi = db.INVOICE_OZEL.Where(x => x.FirmaID == firmaid).ToList();
if (carikategori.Count == 0)
{
int i = 9;
for (int j = 1; j < i; j++)
{
INVOICE_OZEL stk = new INVOICE_OZEL();
stk.FirmaID = firmaid;
stk.Name = "Fature Ek Bilgi " + j;
stk.EfaturadaGonder = false;
string company_code = "SA01" + fr.FirmaID.ToString().PadLeft(3, '0');
stk.Company_Code = company_code;
db.INVOICE_OZEL.Add(stk);
db.SaveChanges();
}
}
#endregion
Session["FirmaAdi"] = fr.FirmaAdi;
MailOkey(rg);
return(RedirectToAction("Login", "Login"));
}
else
{
return(View());
}
}
catch (Exception e)
{
return(View());
}
}
public System.Data.DataTable getprec()
{
DateTime strFechaInicial = Convert.ToDateTime(dtinicial.SelectedDate);
DateTime strFechaFinal = Convert.ToDateTime(dtfinal.SelectedDate);
string conect = GetOrigen(intEMPRESAID);
System.Data.DataTable Tabla = new System.Data.DataTable();
//string strFuncion = "Select Codigo_De_Articulo AS codigo, Descripcion AS Descripcion, Importe_Total AS Total,Fecha_Y_Hora_De_Ultima_Actualizacion as Fecha " +
// "FROM Facturas_Y_Devoluciones_Detalle INNER JOIN Facturas_Y_Devoluciones ON Facturas_Y_Devoluciones_Detalle.Numero_De_Documento = Facturas_Y_Devoluciones.Numero_De_Documento" +
// " WHERE(Codigo_De_Empleado = '"+noemployed+ "') AND Facturas_Y_Devoluciones.Fecha_Y_Hora_De_Ultima_Actualizacion BETWEEN '" + strFechaInicial + "' AND '" + strFechaFinal + "'";
string strFuncion = "SELECT * from dbo.fncoperarios(@FechaInicial,@FechaFinal,@noempleado);";
try
{
using (System.Data.SqlClient.SqlConnection Cnn = new System.Data.SqlClient.SqlConnection(conect))
{
//Cnn.ConnectionTimeout = 500;
using (System.Data.SqlClient.SqlCommand Cmd = new System.Data.SqlClient.SqlCommand(strFuncion, Cnn))
{
try
{
//
Cmd.CommandType = CommandType.Text;
Cmd.CommandTimeout = 360;
Cmd.Parameters.Add("@FechaInicial", SqlDbType.SmallDateTime).Value = strFechaInicial;
Cmd.Parameters.Add("@FechaFinal", SqlDbType.SmallDateTime).Value = strFechaFinal;
Cmd.Parameters.Add("@noempleado", SqlDbType.SmallInt).Value = Convert.ToInt32(noemployed);
System.Data.SqlClient.SqlDataAdapter Datos = new System.Data.SqlClient.SqlDataAdapter(Cmd);
Cnn.Open();
Datos.Fill(Tabla);
return(Tabla);
}
catch (Exception ex)
{
throw new Exception("Error de acceso a datos, Error: " + ex.ToString());
}
finally
{
if (Cnn.State == ConnectionState.Open)
{
Cnn.Close();
}
}
}
}
}
catch (Exception z)
{
RadWindow radWindow = new RadWindow();
RadWindow.Alert(new DialogParameters()
{
Content = "Error al acceso de datos .",
Header = "BIG",
DialogStartupLocation = WindowStartupLocation.CenterOwner
// IconContent = "";
});
return(Tabla);
}
}
///// <summary>
///// 初始化界面网格控件
///// </summary>
///// <param name="Grid">DataGridView 控件</param>
//public virtual void InitColumns(DataGridView Grid)
//{
//}
#endregion
#region 加载数据（返回DataTable）
/// <summary>
/// 加载数据（返回DataTable）
/// </summary>
/// <param name="ConnStr">连接字符串</param>
/// <param name="strSQL">SQL语句</param>
/// <param name="strTableName">DataTable表名</param>
/// <param name="isTable">是否对应有物理表，需要有更新、保存等命令</param>
public static SD.DataTable GetData(string ConnStr, string strSQL, string strTableName, bool isTable)
{
SD.DataTable dt = new SD.DataTable(strTableName);
try
{
using (sqlconn = new SDC.SqlConnection(ConnStr))
{
//sqlconn.Open();
using (sqlcmd = new SDC.SqlCommand(strSQL, sqlconn))
{
//if (sqlcmd == null)
//{
// using (dt = new SD.DataTable(strTableName))
// {
// return dt;
// }
//}
using (sqladp = new SDC.SqlDataAdapter(sqlcmd))
{
if (isTable)
{
using (sqlcmdbd = new SDC.SqlCommandBuilder(sqladp))
{
sqlcmdbd.ConflictOption = SD.ConflictOption.CompareAllSearchableValues;
sqladp.InsertCommand = sqlcmdbd.GetInsertCommand();
sqladp.UpdateCommand = sqlcmdbd.GetUpdateCommand();
sqladp.DeleteCommand = sqlcmdbd.GetDeleteCommand();
sqladp.Fill(dt);
return(dt);
}
}
else
{
sqladp.Fill(dt);
return(dt);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sqlconn != null)
{
if (sqlconn.State != SD.ConnectionState.Closed)
{
sqlconn.Close();
}
sqlconn.Dispose();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
System.IO.MemoryStream stream1 = new System.IO.MemoryStream();
string path = "";
string LinkId = "";
String StudentID = Request.QueryString["studid"];
DataSet ds = new DataSet();
System.Data.SqlClient.SqlDataAdapter da = default(System.Data.SqlClient.SqlDataAdapter);
string strSQL = null;
dynamic SQLcon = new SqlConnection(ConfigurationManager.ConnectionStrings["SkylineUniversityConnPortal"].ToString());
try
{
strSQL = "exec SHP_ApplicationForm '" + StudentID + "'";
// strSQL = "SELECT staffdetails.Empid, staffdetails.empname, staffdetails.empdesignation, staffdetails.empdepartment, staffdetails.etype, staffdetails.priority, staffdetails.phoneno, staffdetails.emailid, staffdetails.epassword, staffdetails.eAddress, staffdetails.qulification, staffdetails.imagedata, staffdetails.imgetype, staffdetails.imagelength, staffdetails.extno, tb_advising.f_id, tb_advising.stud_id, tb_advising.sap_status, tb_advising.Conditionaladmission, tb_advising.repeatingcourse, tb_advising.toc_Course, EMPMASTER.OFFICEEXT FROM staffdetails INNER JOIN tb_advising ON staffdetails.Empid = tb_advising.f_id INNER JOIN EMPMASTER ON staffdetails.Empid = EMPMASTER.EMPID where tb_advising.stud_id='" & Session["StudentID"] & "'"
da = new System.Data.SqlClient.SqlDataAdapter(strSQL, SQLcon);
da.Fill(ds);
}
catch
{
}
try
{
LinkId = Session["LinkId"].ToString();
}
catch
{
LinkId = ds.Tables[0].Rows[0]["LinkID"].ToString();
}
string UName = Request.QueryString["UName"].ToString();
if (UName.Contains(".pdf"))
{
}
else
{
if (UName == "FS")
{
}
else if (UName == "FW")
{
}
// PLEASE CHECK IT
else if (UName == "FO")
{
}
else if (UName == "MQP")
{
}
else if (UName == "MC")
{
}
else
{
string RegNo = ds.Tables[0].Rows[0]["RegistrationNo_CDB"].ToString();
path = "~/" + UName + ".rpt";
path = Server.MapPath(path);
rptStudent.Load(path);
if ((UName == "ENROLLMENTFORM") || (UName.Contains("hostel_application")) || (UName == "local_guardian_visa_application") || (UName == "Student_Visa_Processing_request_Form") || (UName == "Student_personal_details_visa_applcation"))
{
rptStudent.SetParameterValue("@LinkId", LinkId);
}
else if ((UName == "CpdEventsReportMain"))
{
}
else if ((UName == "RPT_INSTRUCTION"))
{
}
else if ((UName == "RefundPolicy"))
{
}
else if ((UName == "MktCheckListReport"))
{
}
else if ((UName == "RefundPolicy - MQP"))
{
}
else
{
rptStudent.SetParameterValue("@registerid", LinkId);
}
}
rptStudent.SetDatabaseLogon("software", "DelFirMENA$idea");
CrystalReportViewer1.Visible = false;
CrystalReportViewer1.ReportSource = rptStudent;
CrystalReportViewer1.DataBind();
CrystalReportViewer1.HasCrystalLogo = false;
CrystalReportViewer1.HasDrilldownTabs = false;
CrystalReportViewer1.HasDrillUpButton = false;
CrystalReportViewer1.HasGotoPageButton = true;
CrystalReportViewer1.HasPageNavigationButtons = true;
CrystalReportViewer1.HasRefreshButton = false;
CrystalReportViewer1.HasSearchButton = false;
CrystalReportViewer1.HasToggleGroupTreeButton = false;
CrystalReportViewer1.HasToggleParameterPanelButton = false;
CrystalReportViewer1.BackColor = System.Drawing.Color.White;
System.IO.Stream oStream = null;
byte[] byteArray = null;
oStream = rptStudent.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byteArray = new byte[oStream.Length];
oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1));
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.BinaryWrite(byteArray);
Response.Flush();
Response.Close();
rptStudent.Close();
rptStudent.Dispose();
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
void AttachedMCGrid()
{
string str = "SELECT imcid as iMissionClearanceId FROM tblDocSend where iDocSendID = " + iDocSendID + "";
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter ad = new System.Data.SqlClient.SqlDataAdapter(str, cn);
DataSet ds1 = new DataSet();
ad.Fill(ds1);
int viemcid = 0;
if (ds1.Tables[0].Rows[0]["iMissionClearanceId"].ToString() == "")
{
viemcid = 0;
}
else
{
viemcid = Convert.ToInt32(ds1.Tables[0].Rows[0]["iMissionClearanceId"]);
}
if (viemcid > 0)
{
//SqlConnection cn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
//cn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
// string strgetuser = "******" + hdnmcid.Value;
string strgetuser = "******" + ds1.Tables[0].Rows[0]["iMissionClearanceId"];
SqlDataAdapter adUSer = new System.Data.SqlClient.SqlDataAdapter(strgetuser, cn);
DataSet dsUser = new DataSet();
adUSer.Fill(dsUser);
if (ds1.Tables[0].Rows.Count > 0)
{
dtAttached.Columns.Add("url");
//string[] str = Directory.GetFiles(Server.MapPath(@"/writereaddata/"), MCID + "*.pdf", SearchOption.AllDirectories);
string[] str1 = null;
if (Directory.Exists(Server.MapPath(@"/writereaddata/" + MCID)))
{
str1 = Directory.GetFiles(Server.MapPath(@"/writereaddata/" + ds1.Tables[0].Rows[0]["iMissionClearanceId"].ToString() + "/"), "*", SearchOption.TopDirectoryOnly);
}
hdnMCID.Value = ds1.Tables[0].Rows[0]["iMissionClearanceId"].ToString();
if (str1.Length > 0)
{
str1 = Directory.GetFiles(Server.MapPath(@"/writereaddata/" + ds1.Tables[0].Rows[0]["iMissionClearanceId"].ToString() + "/"), "*", SearchOption.TopDirectoryOnly);
hdnMCID.Value = ds1.Tables[0].Rows[0]["iMissionClearanceId"].ToString();
if (str1.Length > 0)
{
for (int i = 0; i < str1.Length; i++)
{
DataRow dr = dtAttached.NewRow();
dr[0] = Path.GetFileName(str1[i]);
dtAttached.Rows.Add(dr);
}
}
}
Visibles(false, true, false);
btnReply.Visible = true; //Modified for reply enable while view in mission docs.
}
// Visible(false, true, false);
gvmcatt.DataSource = dtAttached;
gvmcatt.DataBind();
string sql = "Select * from tblmc where iMissionClearanceId=" + hdnMCID.Value;
// SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter ad1 = new System.Data.SqlClient.SqlDataAdapter(sql, cn);
DataSet ds11 = new DataSet();
ad1.Fill(ds11);
if ((((UserDetails)Session[clsConstant.TOKEN]).AgencyID.ToString() == "7") && (ds11.Tables[0].Rows[0]["bMissionApproved"].ToString() == "no" || ds11.Tables[0].Rows[0]["bMissionApproved"].ToString() == "PC"))
// if ((((UserDetails)Session[clsConstant.TOKEN]).AgencyID.ToString() == "7"))
{
hlink.Visible = true;
}
else
{
hlink.Visible = false;
}
}
}
public DataTable GetDataSet(string sqlstr, CommandType CmdType)
{
string msg = "";
bool chk = false;
if (DirtyWords.Length > 0)
{
foreach (String s in DirtyWords)
{
if (sqlstr.ToUpper().IndexOf(s.ToUpper()) > -1)
{
chk = true;
}
}
}
DataTable DS = new DataTable();
if (chk)
{
WriteLog("[" + DateTime.Now.ToLongTimeString() + "][Main.GetDataSet.Error]:Here is Somthing Wrong!!\n\r" + sqlstr);
return(DS);
}
try
{
CMD.Connection = CONN;
CMD.CommandText = sqlstr;
CMD.CommandType = CmdType;
ADP = new SqlDataAdapter(CMD);
ADP.Fill(DS);
}
catch (Exception ex)
{
msg = ex.Message;
}
finally
{
if (CONN.State == ConnectionState.Open)
{
CONN.Close();
}
}
try //log用另外的try防止檔案被咬
{
if (msg != "")
{
WriteCMD();
WriteLog("[" + DateTime.Now.ToLongTimeString() + "][Main.GetDataSet.Error]:" + msg + sqlstr);
}
else
{
if (LogStat >= 1)
{
WriteCMD();
}
WriteLogselect(sqlstr);
}
}
catch { }
return(DS);
}
protected void Page_Load(object sender, EventArgs e)
{
// try{
string mac;
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["mayeDb"].ConnectionString;
NetworkInterface[] nics = NetworkInterface.GetAllNetworkInterfaces();
mac = nics[0].GetPhysicalAddress().ToString();
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("select count(id) from customer where mac_address like '" + mac + "'", con);
int count = Convert.ToInt16(cmd.ExecuteScalar());
macadd.Value = mac.ToString();
if (count > 0)
{
SqlCommand cmd1 = new SqlCommand("select top 1 concat(fname,' ',lname) from customer where mac_address like '" + mac + "' order by last_login desc", con);
SqlCommand cmd2 = new SqlCommand("select top 1 id from customer where mac_address like '" + mac + "' order by last_login desc", con);
String nameLog = cmd1.ExecuteScalar().ToString();
custId.Value = cmd2.ExecuteScalar().ToString();
name1.Value = nameLog.ToString();
SqlCommand cmd5 = new SqlCommand("select count(custId) from cart where custId like '" + custId.Value + "'", con);
int countId = Convert.ToInt16(cmd5.ExecuteScalar());
if (countId == 0)
{
SqlCommand cmd4 = new SqlCommand("insert into cart (custId, mac , prodQty,price) values ('" + custId.Value + "', '" + mac + "', 0,0)", con);
cmd4.ExecuteScalar();
}
}
else
{
name1.Value = "Guest User";
SqlCommand cmd3 = new SqlCommand("insert into customer (fname, mac_address, last_login) values ('Guest User', '" + mac + "', CURRENT_TIMESTAMP)", con);
SqlCommand cmd2 = new SqlCommand("select top 1 id from customer where mac_address like '" + mac + "' order by last_login desc", con);
cmd3.ExecuteNonQuery();
custId.Value = cmd2.ExecuteScalar().ToString();
SqlCommand cmd5 = new SqlCommand("select count(Id) from customer where Id like '" + custId.Value + "'", con);
int countId = Convert.ToInt16(cmd5.ExecuteScalar());
if (countId == 1)
{
SqlCommand cmd4 = new SqlCommand("insert into cart (custId, mac, prodQty,price) values ('" + custId.Value + "', '" + mac + "', 0,0)", con);
cmd4.ExecuteScalar();
}
}
int cust = Convert.ToInt16(custId.Value);
SqlCommand cmd6 = new SqlCommand("select sum(prodQty) from cart where custId like '" + custId.Value + "'", con);
int prodQty = Convert.ToInt16(cmd6.ExecuteScalar());
SqlCommand cmd7 = new SqlCommand("select sum(prodQty*price) from cart where custId like '" + custId.Value + "'", con);
double amtDue = Convert.ToDouble(cmd7.ExecuteScalar());
itemCount.Text = prodQty.ToString();
amt.Text = amtDue.ToString();
con.Close();
var queryStrings = HttpUtility.UrlDecode(Request.QueryString.ToString());
var arrQueryStrings = queryStrings.Split('=');
id = Convert.ToString(arrQueryStrings[1]);
con = new System.Data.SqlClient.SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["mayeDb"].ConnectionString;
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd8 = new SqlCommand("select nameFrn, price, descFrn, sizes from products where Id like '" + id + "'", con);
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter();
da.SelectCommand = cmd8;
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
StringBuilder cstext2 = new StringBuilder();
cstext2.Clear();
cstext2.Append("<script type='text/javascript'> var newInput; window.onload=function OnLoad() {");
foreach (System.Data.DataRow dr in ds.Tables[0].Rows)
{
cstext2.Append("document.getElementById('name').innerHTML='" + dr[0].ToString() + "';");
cstext2.Append("document.getElementById('price').innerHTML+='" + dr[1].ToString() + "';");
cstext2.Append("document.getElementById('description').innerHTML='" + dr[2].ToString() + "';");
cstext2.Append("document.getElementById('button').innerHTML='<a onclick=\\'cart(\"" + id + "\", " + dr[1].ToString() + ", " + qty.Text + ")\\' style=\\'height:53px; font-weight:bolder; border-style:groove; width:502px; text-align:center\\' class=\\'add-cart item_add\\'><br />AJOUTER AU PANIER</a>';");
string size = dr[3].ToString();
var sizeString = size.Split(',');
for (int i = 0; i < sizeString.Length; i++)
{
cstext2.Append("document.getElementById('size').innerHTML+='<option>" + sizeString[i].ToString() + "</option>';");
}
cstext2.Append("document.getElementById('description2').innerHTML='" + dr[2].ToString() + "';");
SqlCommand cmd1 = new SqlCommand("select image1 from products where Id like '" + id + "'", con);
SqlCommand cmd2 = new SqlCommand("select image2 from products where Id like '" + id + "'", con);
SqlCommand cmd3 = new SqlCommand("select image3 from products where Id like '" + id + "'", con);
SqlCommand cmd4 = new SqlCommand("select image4 from products where Id like '" + id + "'", con);
string image1 = cmd1.ExecuteScalar().ToString();
string image2 = cmd2.ExecuteScalar().ToString();
string image3 = cmd3.ExecuteScalar().ToString();
string image4 = cmd4.ExecuteScalar().ToString();
if (!image1.Equals(""))
{
cstext2.Append("document.getElementById('slideshow').innerHTML=\"<li style='height:600px' data-thumb='" + image1 + "'><img style='height:600px' src='" + image1 + "' ></li>\";");
}
if (!image2.Equals(""))
{
cstext2.Append("document.getElementById('slideshow').innerHTML+=\"<li style='height:600px' data-thumb='" + image2 + "'><img style='height:600px' src='" + image2 + "' ></li>\";");
}
if (!image3.Equals(""))
{
cstext2.Append("document.getElementById('slideshow').innerHTML+=\"<li style='height:600px' data-thumb='" + image3 + "'><img style='height:600px' src='" + image3 + "' ></li>\";");
}
if (!image4.Equals(""))
{
cstext2.Append("document.getElementById('slideshow').innerHTML+=\"<li style='height:600px' data-thumb='" + image4 + "'><img style='height:600px' src='" + image4 + "' ></li>\";");
}
}
SqlCommand cmd12 = new SqlCommand("select top 3 id, nameFrn, ctgEng, price, image1 from products where id not like " + id + " order by newid()", con);
System.Data.SqlClient.SqlDataAdapter da5 = new System.Data.SqlClient.SqlDataAdapter();
da5.SelectCommand = cmd12;
System.Data.DataSet ds3 = new System.Data.DataSet();
da5.Fill(ds3);
cstext2.Append("document.getElementById('suggestions').innerHTML='");
foreach (System.Data.DataRow dr in ds3.Tables[0].Rows)
{
cstext2.Append("<div class=\"col-md-4 bottom-cd simpleCart_shelfItem\">");
cstext2.Append("<div class=\"product-at \"><center>");
cstext2.Append("<a href=\"single.aspx?id=" + dr[0] + "\"><img class=\"img-responsive\" style=\"width:254.984px; height:403.453px\" src=\"" + dr[4].ToString() + "\" alt=\"\">");
cstext2.Append("<div class=\"pro-grid\" style=\"margin-top:70px\">");
cstext2.Append("<span href=\"single.aspx?id=" + dr[0] + "\" class=\"buy-in\">Buy Now</span>");
cstext2.Append("</div>");
cstext2.Append("</a></center>");
cstext2.Append("</div>");
cstext2.Append("<p style=\"height:71px\" class=\"tun\">" + dr[1].ToString() + "</p>");
cstext2.Append("<a href=\"single.aspx?id=" + dr[0] + "\" class=\"item_add\"><p class=\"number item_price\"><i> </i>€" + dr[3].ToString() + "</p></a> ");
cstext2.Append("</div>");
}
cstext2.Append("';");
//color
SqlCommand cmd120 = new SqlCommand("select color from products where id like '" + id + "'", con);
string color = cmd120.ExecuteScalar().ToString();
var id1 = id.Split('-');
if (!color.Equals("0"))
{
// cstext2.Append("document.getElementById('color').innerHTML+=\"<li class='size-in' id='colorDrop'>Color<select id='color'>\";");
var colorString = color.Split(',');
for (int z = 0; z < colorString.Length; z++)
{
cstext2.Append("document.getElementById('color').innerHTML+='<option value=\\'single.aspx?id=" + id1[0] + "-" + (z + 1) + "\\'>" + colorString[z].ToString() + "</option>';");
}
cstext2.Append("document.getElementById('color').innerHTML+=\"</select></li>\";");
}
else
{
cstext2.Append("document.getElementById('colorDrop').style.display = 'none';");
}
//color
SqlCommand cmd15 = new SqlCommand("select custName, review, date from review where productId like '" + id + "'", con);
System.Data.SqlClient.SqlDataAdapter da1 = new System.Data.SqlClient.SqlDataAdapter();
da1.SelectCommand = cmd15;
System.Data.DataSet ds1 = new System.Data.DataSet();
da1.Fill(ds1);
cstext2.Append("document.getElementById('reviewpanel').innerHTML='");
foreach (System.Data.DataRow dr in ds1.Tables[0].Rows)
{
cstext2.Append("<div class=\"top-comment-left\">");
cstext2.Append("<img class=\"img-responsive\" src=\"images/co.png\" >");
cstext2.Append("</div>");
cstext2.Append("<div class=\"top-comment-right\">");
cstext2.Append("<h6><a >" + dr[0].ToString() + "</a> - " + dr[2].ToString() + "</h6>");
cstext2.Append("<p>" + dr[1].ToString() + "</p>");
cstext2.Append("</div>");
cstext2.Append("<div class=\"clearfix\"> </div>");
}
cstext2.Append("';}</script>");
Response.Write(cstext2.ToString());
con.Close();
// }
//catch (Exception a) { Response.Redirect("index.aspx"); }
}
private void button1_Click(object sender, EventArgs e)
{
try
{
sqlBağlanti kullanici = new sqlBağlanti();
kullanici.Mail = textBox1.Text;
baglanti.Open();
string sorgu = "SELECT * FROM tbl_kullaniciKayit WHERE MAİL='" + textBox1.Text + "'";
SqlCommand komut = new System.Data.SqlClient.SqlCommand(sorgu, baglanti);
komut.ExecuteNonQuery();
DataTable tablo = new DataTable();
SqlDataAdapter adaptor = new System.Data.SqlClient.SqlDataAdapter(komut);
adaptor.Fill(tablo);
aktKod = rnd.Next(10000000, 99999999).ToString();
if (tablo.Rows.Count > 0)
{
textBox1.Text = tablo.Rows[0]["MAİL"].ToString();
if (kullanici.Mail == textBox1.Text)
{
MailMessage message = new MailMessage();
SmtpClient istemci = new SmtpClient();
istemci.Credentials = new NetworkCredential("*****@*****.**", "iksvESTP34");
istemci.Port = 587;
istemci.Host = "smtp.gmail.com";
istemci.EnableSsl = true;
message.To.Add(textBox1.Text);
message.From = new MailAddress(textBox1.Text);
message.Subject = "Aktivasyon Kodu";
message.Body = "Aktivasyon kodunuz artık yeni şifreniz oldu : " + aktKod;
istemci.Send(message);
MessageBox.Show("Aktivasyon kodu mail adresine gönderildi. Yönlendiriliyorsunuz ... Daha sonra şifrenizi güncellemeyi unutmayınız ...", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
//textBox1.Text = " ";
//baglanti.Open();
//string sorgu2 = "UPDATE tbl_KullaniciKayit SET Sifre='" + aktKod + "' WHERE Email='" + kullanici.Mail + "'";
//SqlCommand cmd = new SqlCommand(sorgu2, baglanti);
//cmd.ExecuteNonQuery();
//baglanti.Close();
//KullanıcıGirişForm formLogin = new KullanıcıGirişForm();
//this.Hide();
//formLogin.Show();
}
else
{
label2.Visible = true;
label2.Text = "Kayıtlı Email adresi bulunamadı";
}
}
else
{
label2.Visible = true;
label2.Text = "Kayıtlı Email adresi bulunamadı";
}
baglanti.Close();
baglanti.Dispose();
}
catch (Exception hata)
{
label2.Visible = true;
label2.Text = "Hata kodu : " + hata.Message;
}
}
private void LoadData()
{
sqlDataAdapter1.Fill(dataSet11);
DataGrid1.DataSource = dataSet11.Tables[0];
}
protected void dxcbpodfiles_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
try
{
string _folderpath = "";
//int _orderno = 0;
int _ordernocount = 0;
Int32 _folderid = 0;
bool _uploaded = false; //flagged if uploaded completed ok
_folderpath = return_selected_folder();
_folderid = return_selected_folderid(_folderpath);
_uploaded = this.dxhfmanager.Contains("upld") ? (bool)this.dxhfmanager.Get("upld") : false;
//09012011 stored in ilist to save casting datatable for IN query
//05012011 multiple order no's are stored in data table
//_ordernocount = _ol.Rows.Count;
//_orderno = wwi_func.vint(this.dxlblorderno1.Text.ToString()); //this.dxhfmanager.Contains("ord") ? wwi_func.vint(wwi_security.DecryptString(this.dxhfmanager.Get("ord").ToString(), "publiship")) : 0;
//DataTable _ol = (DataTable)Session["orderlist"];
IList <Int32> _ol = (IList <Int32>)Session["orderlist"];
_ordernocount = _ol.Count;
if (_uploaded & _folderid > 0 && _ordernocount > 0)
//if (_uploaded & _folderid > 0 && _orderno > 0)
{
//copy files from temporary folder
//string _uid = wwi_security.DecryptString(this.dxhfmanager.Get("uid").ToString(), "publiship");
string _uid = ((UserClass)HttpContext.Current.Session["user"]).UserId.ToString();
string _tempdir = DateTime.Now.ToShortDateString().Replace("/", "") + _uid;
string _sourcepath = System.IO.Path.Combine("~\\documents\\not found", _tempdir);
int _copies = file_transfer(_sourcepath, _folderpath, true);
if (_copies > 0)
{
//update order table
//save quote id to order table
//if (_ordernocount == 1)
//{
// //(DataRow)_ol.Rows[0][0]
// SubSonic.Update upd2 = new SubSonic.Update(DAL.Logistics.Schemas.OrderTable);
// recordsaffected = upd2.Set("document_folder").EqualTo(_folderid)
// .Where("OrderNumber").IsEqualTo(_ol[0])
// .Execute();
//}
//else
//{
//string _csv = wwi_func.datatable_to_string(_ol, ",");
string _csv = string.Join(",", _ol.Select(i => i.ToString()).ToArray());
//establish connection
ConnectionStringSettings _cs = ConfigurationManager.ConnectionStrings["PublishipSQLConnectionString"];
SqlConnection _cn = new SqlConnection(_cs.ConnectionString);
//create a sql data adapter
System.Data.SqlClient.SqlDataAdapter _adapter = new System.Data.SqlClient.SqlDataAdapter();
//instantiate event handler
_adapter.RowUpdated += new SqlRowUpdatedEventHandler(adapter_RowUpdated);
_adapter.SelectCommand = new SqlCommand("SELECT [document_folder], [orderNumber] FROM OrderTable WHERE [OrderNumber] IN (" + _csv + ")", _cn);
//populate datatable using selected order numbers
DataTable _dt = new DataTable();
_adapter.Fill(_dt);
//update document folder for each order number in _dt
for (int ix = 0; ix < _dt.Rows.Count; ix++)
{
_dt.Rows[ix]["document_folder"] = _folderid;
}
//update command
_adapter.UpdateCommand = new SqlCommand("UPDATE OrderTable SET [document_folder] = @document_folder WHERE [OrderNumber] = @OrderNumber;", _cn);
_adapter.UpdateCommand.Parameters.Add("@OrderNumber", SqlDbType.Int).SourceColumn = "OrderNumber";
_adapter.UpdateCommand.Parameters.Add("@document_folder", SqlDbType.Int).SourceColumn = "document_folder";
_adapter.UpdateBatchSize = 5; //_ordernocount;
_adapter.UpdateCommand.UpdatedRowSource = UpdateRowSource.None;
_adapter.Update(_dt);
_adapter.Dispose();
_cn.Close();
//}
if (_countUpdated > 0) //countupdated will return the number of batches sent NOT the number of records updated
{
//disable session expiration which occurs when a directory is deleted
//uses System.Reflection
PropertyInfo p = typeof(System.Web.HttpRuntime).GetProperty("FileChangesMonitor", BindingFlags.NonPublic | BindingFlags.Public | BindingFlags.Static);
object o = p.GetValue(null, null);
FieldInfo f = o.GetType().GetField("_dirMonSubdirs", BindingFlags.Instance | BindingFlags.NonPublic | BindingFlags.IgnoreCase);
object monitor = f.GetValue(o);
MethodInfo m = monitor.GetType().GetMethod("StopMonitoring", BindingFlags.Instance | BindingFlags.NonPublic);
m.Invoke(monitor, new object[] { });
//kill temp folder
System.IO.Directory.Delete(Server.MapPath(_sourcepath), true);
this.dxlblinfo2.Text += _copies + " files have been uploaded to folder " + _folderid + " and linked to order numbers(s) " + _csv;
this.dxpnlinfo.Visible = true;
}
else
{
this.dxlblerr.Text = "We have not been able to link order number(s) to online folder " + _folderid + " please refer to Publiship I.T.";
this.dxpnlerr.Visible = true;
}
//end check records affected
}
}
//end update order table
}
catch (Exception ex)
{
this.dxlblerr.Text = ex.Message.ToString();
this.dxpnlerr.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
con.ConnectionString = ConfigurationManager.ConnectionStrings["mayeDb"].ConnectionString;
NetworkInterface[] nics = NetworkInterface.GetAllNetworkInterfaces();
mac = nics[0].GetPhysicalAddress().ToString();
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("select count(id) from customer where mac_address like '" + mac + "'", con);
int count = Convert.ToInt16(cmd.ExecuteScalar());
macadd.Value = mac.ToString();
if (count > 0)
{
SqlCommand cmd1 = new SqlCommand("select top 1 concat(fname,' ',lname) from customer where mac_address like '" + mac + "' order by last_login desc", con);
SqlCommand cmd2 = new SqlCommand("select top 1 id from customer where mac_address like '" + mac + "' order by last_login desc", con);
String nameLog = cmd1.ExecuteScalar().ToString();
custId.Value = cmd2.ExecuteScalar().ToString();
name.Value = nameLog.ToString();
SqlCommand cmd5 = new SqlCommand("select count(custId) from cart where custId like '" + custId.Value + "'", con);
int countId = Convert.ToInt16(cmd5.ExecuteScalar());
if (countId == 0)
{
SqlCommand cmd4 = new SqlCommand("insert into cart (custId, mac , prodQty,price) values ('" + custId.Value + "', '" + mac + "', 0,0)", con);
cmd4.ExecuteScalar();
}
}
else
{
name.Value = "Guest User";
SqlCommand cmd3 = new SqlCommand("insert into customer (fname, mac_address, last_login) values ('Guest User', '" + mac + "', CURRENT_TIMESTAMP)", con);
SqlCommand cmd2 = new SqlCommand("select top 1 id from customer where mac_address like '" + mac + "' order by last_login desc", con);
cmd3.ExecuteNonQuery();
custId.Value = cmd2.ExecuteScalar().ToString();
SqlCommand cmd5 = new SqlCommand("select count(Id) from customer where Id like '" + custId.Value + "'", con);
int countId = Convert.ToInt16(cmd5.ExecuteScalar());
if (countId == 1)
{
SqlCommand cmd4 = new SqlCommand("insert into cart (custId, mac, prodQty,price) values ('" + custId.Value + "', '" + mac + "', 0,0)", con);
cmd4.ExecuteScalar();
}
}
cust = Convert.ToInt16(custId.Value);
SqlCommand cmd6 = new SqlCommand("select sum(prodQty) from cart where custId like '" + custId.Value + "'", con);
int prodQty = Convert.ToInt16(cmd6.ExecuteScalar());
SqlCommand cmd7 = new SqlCommand("select sum(prodQty*price) from cart where custId like '" + custId.Value + "'", con);
double amtDue = Convert.ToDouble(cmd7.ExecuteScalar());
itemCount.Text = prodQty.ToString();
amt.Text = amtDue.ToString();
con.Close();
var cat = "";
var page = "";
try
{
con = new System.Data.SqlClient.SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["mayeDb"].ConnectionString;
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
StringBuilder cstext2 = new StringBuilder();
cstext2.Clear();
cstext2.Append("<script type='text/javascript'> var newInput; window.onload=function OnLoad() {");
cstext2.Append("document.getElementById('products').innerHTML ='';");
System.Data.SqlClient.SqlCommand cmd8 = new System.Data.SqlClient.SqlCommand(";with A aS(SELECT id, nameFrn, ctgEng, descEng, price, image1 isAvlbl, sizes,ROW_NUMBER() OVER (ORDER BY Id) AS 'RN' from products where isFeatured =1 ) select * from A order by newid()", con);
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter();
da.SelectCommand = cmd8;
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
int x = 0;
cstext2.Append("newInput=\"");
foreach (System.Data.DataRow dr in ds.Tables[0].Rows)
{
//product
if (x % 3 == 0)
{
cstext2.Append("<div class=' bottom-product'>");
}
cstext2.Append("<div class='col-md-4 bottom-cd simpleCart_shelfItem'>");
cstext2.Append("<div class='product-at '>");
cstext2.Append("<a href='single.aspx?id=" + dr[0].ToString() + "'><img class='img-responsive' style='width:254.984px; height:403.453px' src='" + dr[5].ToString() + "'>");
cstext2.Append("<div class='pro-grid' style='margin-top:70px'>");
cstext2.Append("<span class='buy-in' href='single.aspx?id=" + dr[0].ToString() + "'>Acheter Maintenant</span>");
cstext2.Append("</div>");
cstext2.Append("</a> ");
cstext2.Append("</div>");
cstext2.Append("<p style='height:71px' class='tun'>" + dr[1].ToString() + "</p>");
cstext2.Append("<a href='single.aspx?id=" + dr[0].ToString() + "' class='item_add'><p class='number item_price'><i> </i>€" + dr[4].ToString() + "</p></a> ");
cstext2.Append("<br><br></div>");
if ((x + 1) % 3 == 0)
{
cstext2.Append("<div>");
}
x++;
//productEnd
}
cstext2.Append("\";");
cstext2.Append(" document.getElementById('products').innerHTML += newInput;");
cstext2.Append("var newInput1=\"<div class='of-left-in'><h3 class='best'>Best Sellers</h3></div>");
System.Data.SqlClient.SqlCommand cmd9 = new System.Data.SqlClient.SqlCommand("select top 2 id, nameFrn, price, image1 from products order by newid() ", con);
System.Data.SqlClient.SqlDataAdapter da1 = new System.Data.SqlClient.SqlDataAdapter();
da1.SelectCommand = cmd9;
System.Data.DataSet ds1 = new System.Data.DataSet();
da1.Fill(ds1);
foreach (System.Data.DataRow dr in ds1.Tables[0].Rows)
{
cstext2.Append("<div class='product-go'><div class=' fashion-grid'><a href='single.aspx?id=" + dr[0] + "'><img class='img-responsive' src='" + dr[3].ToString() + "' ></a></div>");
cstext2.Append("<div class='fashion-grid1'><h6 class='best2'><a href='single.aspx?id=" + dr[0] + "' >" + dr[1].ToString() + "</a></h6>");
cstext2.Append("<span class=' price-in1'> €" + dr[2] + "</span></div><div class='clearfix'> </div></div>");
}
cstext2.Append("\";");
cstext2.Append(" document.getElementById('ticker').innerHTML = newInput1;");
cstext2.Append("}<");
cstext2.Append("/script>");
Response.Write(cstext2.ToString());
}
catch (Exception a) { }
}
catch (Exception a)
{ Response.Redirect("index.aspx"); }
}
protected void Page_Load(object sender, EventArgs e)
{
id_loai_san_pham = 0;
connect = new connect();
mH = new WebApplication2.QuanTri.maHoa();
try
{
if (Request.QueryString["id_loai_san_pham"] != null && Request.QueryString["id_loai_san_pham"] != "")
{
id_loai_san_pham = int.Parse(Request.QueryString["id_loai_san_pham"]);
}
}
catch (Exception a) { }
if (id_loai_san_pham == 0)
{
Response.Redirect("danhsachloaisanpham.aspx");
}
System.Data.DataTable ds = new System.Data.DataTable();
{
string sql = "select id_loai_san_pham, ten_loai_san_pham, anh_loai_san_pham, bieu_tuong_loai_san_pham, cap_do_loai_san_pham, id_cha_loai_san_pham from loai_san_pham where id_loai_san_pham=" + id_loai_san_pham;
WebApplication2.YNNSHOP56131778.CONGFIG.connect cnt = new WebApplication2.YNNSHOP56131778.CONGFIG.connect();
System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect());
System.Data.SqlClient.SqlCommand lenh = new System.Data.SqlClient.SqlCommand(sql, ketnoi);
ketnoi.Open();
System.Data.SqlClient.SqlDataAdapter data = new System.Data.SqlClient.SqlDataAdapter(lenh);
data.Fill(ds);
ketnoi.Close();
id_cha = ds.Rows[0][5].ToString();
if (!IsPostBack)
{
TextBox1.Text = mH.Base64Decode(ds.Rows[0][1].ToString());
TextBox4.Text = ds.Rows[0][4].ToString();
}
//TextBox4.Text = ds.Rows[0][4].ToString();
}
System.Data.DataTable lsp = new System.Data.DataTable();
{
string sql = "select id_loai_san_pham, ten_loai_san_pham from loai_san_pham where cap_do_loai_san_pham = " + (int.Parse(TextBox4.Text) - 1);
WebApplication2.YNNSHOP56131778.CONGFIG.connect cnt = new WebApplication2.YNNSHOP56131778.CONGFIG.connect();
System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect());
System.Data.SqlClient.SqlCommand lenh = new System.Data.SqlClient.SqlCommand(sql, ketnoi);
ketnoi.Open();
System.Data.SqlClient.SqlDataAdapter data = new System.Data.SqlClient.SqlDataAdapter(lenh);
data.Fill(lsp);
ketnoi.Close();
for (int i = 0; i < lsp.Rows.Count; i++)
{
lsp.Rows[i][1] = mH.Base64Decode(lsp.Rows[i][1].ToString());
}
if ((int.Parse(TextBox4.Text)) == 0)
{
System.Data.DataRow row;
row = lsp.NewRow();
row[0] = 0;
row[1] = "cao nhất";
lsp.Rows.Add(row);
}
DropDownList1.DataSource = lsp;
DropDownList1.DataTextField = "ten_loai_san_pham";
DropDownList1.DataValueField = "id_loai_san_pham";
DropDownList1.DataBind();
try { DropDownList1.Items.FindByValue(id_cha + "").Selected = true; }catch (Exception a) { }
}
}
private void btnVistaPrevia_Click(object sender, System.EventArgs e)
{
cryRepResumen1.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape;
cryRepResumen1.SetDataSource(dsResumen1);
decimal [] tot = new decimal[8];
for (int i = 0; i < 8; i++)
{
tot[i] = 0;
}
crvResumen.Visible = true;
dsResumen1.Clear();
try
{
sqlDAConcepto.Fill(dsResumen1, "Concepto");
}
catch (Exception ex)
{
ex.ToString();
}
dsResumen1.Clear();
sqlDAConcepto.Fill(dsResumen1, "Concepto");
if (ckbAdicional1.Checked || ckbAdicional2.Checked || ckbAdicional3.Checked || ckbAdicional4.Checked)
{
sqlDASumaResumen.SelectCommand.Parameters["@IdObra"].Value = txtIdobra.Text.Trim() + (cbkPrefijo.Checked ? "" : "%");
sqlDASumaResumen.SelectCommand.Parameters["@IdObr1"].Value = (ckbAdicional1.Checked ? (cmbIdObr1.SelectedValue.ToString() + (cbkPrefijo.Checked ? "" : "%")) : "");
sqlDASumaResumen.SelectCommand.Parameters["@IdObr2"].Value = (ckbAdicional2.Checked ? (cmbIdObr2.SelectedValue.ToString() + (cbkPrefijo.Checked ? "" : "%")) : "");
sqlDASumaResumen.SelectCommand.Parameters["@IdObr3"].Value = (ckbAdicional3.Checked ? (cmbIdObr3.SelectedValue.ToString() + (cbkPrefijo.Checked ? "" : "%")) : "");
sqlDASumaResumen.SelectCommand.Parameters["@IdObr4"].Value = (ckbAdicional4.Checked ? (cmbIdObr4.SelectedValue.ToString() + (cbkPrefijo.Checked ? "" : "%")) : "");
sqlDASumaResumen.SelectCommand.Parameters["@FIni"].Value = dtpIni.Text;
sqlDASumaResumen.SelectCommand.Parameters["@FFin"].Value = dtpFin.Text;
sqlDASumaResumen.SelectCommand.Parameters["@FIni1"].Value = dtpIni1.Text;
sqlDASumaResumen.SelectCommand.Parameters["@FFin1"].Value = dtpFin1.Text;
sqlDASumaResumen.SelectCommand.Parameters["@FIni2"].Value = dtpIni2.Text;
sqlDASumaResumen.SelectCommand.Parameters["@FFin2"].Value = dtpFin2.Text;
sqlDASumaResumen.SelectCommand.Parameters["@FHoy"].Value = DateTime.Today;
sqlDASumaResumen.Fill(dsResumen1, "ResumenTrabajos");
}
else
{
sqlDAResumen.SelectCommand.Parameters["@IdObra"].Value = txtIdobra.Text.Trim() + (cbkPrefijo.Checked ? "" : "%");
sqlDAResumen.SelectCommand.Parameters["@FIni"].Value = dtpIni.Text;
sqlDAResumen.SelectCommand.Parameters["@FFin"].Value = dtpFin.Text;
sqlDAResumen.SelectCommand.Parameters["@FIni1"].Value = dtpIni1.Text;
sqlDAResumen.SelectCommand.Parameters["@FFin1"].Value = dtpFin1.Text;
sqlDAResumen.SelectCommand.Parameters["@FIni2"].Value = dtpIni2.Text;
sqlDAResumen.SelectCommand.Parameters["@FFin2"].Value = dtpFin2.Text;
sqlDAResumen.SelectCommand.Parameters["@FHoy"].Value = DateTime.Today;
sqlDAResumen.Fill(dsResumen1, "ResumenTrabajos");
}
foreach (DataRow dr in dsResumen1.Tables["ResumenTrabajos"].Rows)
{
tot[0] += decimal.Parse(dr["Pres"].ToString()) * decimal.Parse(dr["Preuni"].ToString());
tot[1] += decimal.Parse(dr["Parc1"].ToString()) * decimal.Parse(dr["Preuni"].ToString());
tot[2] += decimal.Parse(dr["Parc2"].ToString()) * decimal.Parse(dr["Preuni"].ToString());
tot[3] += decimal.Parse(dr["Parc3"].ToString()) * decimal.Parse(dr["Preuni"].ToString());
tot[4] += decimal.Parse(dr["Total"].ToString()) * decimal.Parse(dr["Preuni"].ToString());
if (dr["IdConcepto"].ToString() != "14" && dr["IdConcepto"].ToString() != "16" && dr["IdConcepto"].ToString() != "17" && dr["IdConcepto"].ToString() != "18" && dr["IdConcepto"].ToString() != "19" && dr["IdConcepto"].ToString() != "20")
{
tot[5] += decimal.Parse(dr["Total"].ToString()) * decimal.Parse(dr["Prelis"].ToString()); //14, 16, 17, 18, 19, 20
}
if (dr["IdConcepto"].ToString() != "10" && dr["IdConcepto"].ToString() != "18" && dr["IdConcepto"].ToString() != "19" && dr["IdConcepto"].ToString() != "20")
{
tot[6] += decimal.Parse(dr["Total"].ToString()) * decimal.Parse(dr["Prelis"].ToString());
}
if (dr["IdConcepto"].ToString() != "10" && dr["IdConcepto"].ToString() != "14" && dr["IdConcepto"].ToString() != "16" && dr["IdConcepto"].ToString() != "17" && dr["IdConcepto"].ToString() != "30")
{
tot[7] += decimal.Parse(dr["Total"].ToString()) * decimal.Parse(dr["Prelis"].ToString());
}
}
dsResumen1.Tables["Concepto"].Rows[0]["Tot1"] = tot[0];
dsResumen1.Tables["Concepto"].Rows[0]["Tot2"] = tot[1];
dsResumen1.Tables["Concepto"].Rows[0]["Tot3"] = tot[2];
dsResumen1.Tables["Concepto"].Rows[0]["Tot4"] = tot[3];
dsResumen1.Tables["Concepto"].Rows[0]["Tot5"] = tot[4];
dsResumen1.Tables["Concepto"].Rows[0]["Tot6"] = tot[5];
dsResumen1.Tables["Concepto"].Rows[0]["Tot7"] = tot[6];
dsResumen1.Tables["Concepto"].Rows[0]["Tot8"] = tot[7];
string obras = "";
if (ckbAdicional1.Checked || ckbAdicional2.Checked || ckbAdicional3.Checked || ckbAdicional4.Checked)
{
obras = (ckbAdicional1.Checked ? (cmbIdObr1.SelectedValue.ToString() + (cbkPrefijo.Checked ? "" : "%") + " ") : "");
obras += (ckbAdicional2.Checked ? (cmbIdObr2.SelectedValue.ToString() + (cbkPrefijo.Checked ? "" : "%") + " ") : "");
obras += (ckbAdicional3.Checked ? (cmbIdObr3.SelectedValue.ToString() + (cbkPrefijo.Checked ? "" : "%") + " ") : "");
obras += (ckbAdicional4.Checked ? (cmbIdObr4.SelectedValue.ToString() + (cbkPrefijo.Checked ? "" : "%") + " ") : "");
}
cryRepResumen1.SetParameterValue("@Cons", dsDGObra1.Tables[0].Rows[cmbIdObra.SelectedIndex][3].ToString());
cryRepResumen1.SetParameterValue("@Ubica", dsDGObra1.Tables[0].Rows[cmbIdObra.SelectedIndex][1].ToString());
cryRepResumen1.SetParameterValue("@Col", dsDGObra1.Tables[0].Rows[cmbIdObra.SelectedIndex][4].ToString());
cryRepResumen1.SetParameterValue("@Zona", dsDGObra1.Tables[0].Rows[cmbIdObra.SelectedIndex][5].ToString());
cryRepResumen1.SetParameterValue("@Fi", dtpIni.Value);
cryRepResumen1.SetParameterValue("@Ff", dtpFin.Value);
cryRepResumen1.SetParameterValue("@Fi1", dtpIni1.Value);
cryRepResumen1.SetParameterValue("@Ff1", dtpFin1.Value);
cryRepResumen1.SetParameterValue("@Fi2", dtpIni2.Value);
cryRepResumen1.SetParameterValue("@Ff2", dtpFin2.Value);
cryRepResumen1.SetParameterValue("@Total", cbkTotal.Checked);
cryRepResumen1.SetParameterValue("@Obras", obras);
crvResumen.ReportSource = cryRepResumen1;
//crvResumen.RefreshReport();
}
public void SaveComment(string _Type, string _iDocsendDetailsID, string _sDocumentName, string refno)
{
SendRecDoc objDoc = new SendRecDoc();
string PuserID = ((UserDetails)Session[clsConstant.TOKEN]).UserID.ToString();
string sqlto = "select tblUserMaster.iUserID from tblUserMaster ";
sqlto = sqlto + " join tblDocSendDetail on tblDocSendDetail.iUserID=tblUserMaster.iUserID ";
sqlto = sqlto + " where iDocSendID =" + _iDocsendDetailsID + " and bTOCC=1 ";
SqlConnection cntouser = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter adtouser = new System.Data.SqlClient.SqlDataAdapter(sqlto, cntouser);
DataSet dstouser = new DataSet();
adtouser.Fill(dstouser);
DataSet dsuser = objDoc.getUsersforrejectApprove(int.Parse(_iDocsendDetailsID));
string userto = dsuser.Tables[0].Rows[0]["selectusr"].ToString();
string sqlmcid = " select imcid from tblDocSend where iDocSendID=" + _iDocsendDetailsID;
SqlConnection mcidcon = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter mciad = new System.Data.SqlClient.SqlDataAdapter(sqlmcid, mcidcon);
DataSet dsmcid = new DataSet();
mciad.Fill(dsmcid);
if (dsmcid.Tables[0].Rows.Count > 0)
{
string SqlUpdate = "update tblmc set bMissionApproved='PC' where iMissionClearanceId=" + dsmcid.Tables[0].Rows[0][0].ToString() + "";
mcidcon.Close();
mcidcon.Open();
SqlCommand cmd = new SqlCommand(SqlUpdate, mcidcon);
cmd.ExecuteNonQuery();
}
string emailAlert = string.Empty;
DataSet dsuserEmail = new DataSet();
dsuserEmail = objDoc.getmailforrejectApprove(int.Parse(dsmcid.Tables[0].Rows[0]["imcid"].ToString()));
emailAlert += GetFromID(int.Parse(dsmcid.Tables[0].Rows[0]["imcid"].ToString())) + ';';
emailAlert += dsuserEmail.Tables[0].Rows[0]["selectusr"].ToString() + ';';
emailAlert = FindEmailID(emailAlert, ((UserDetails)(Session[clsConstant.TOKEN])).EmailID) + ';';
if (emailAlert.Contains("*****@*****.**"))
{
emailAlert += "*****@*****.**" + ';';
}
Session["userEmail"] = emailAlert;
if (objDoc.saveALLComment(dsmcid.Tables[0].Rows[0]["imcid"].ToString(), _iDocsendDetailsID, "R", _sDocumentName, refno, DateTime.Now, int.Parse(PuserID), userto, "") > 0)
{
Utility objUtl = new Utility();
try
{
string nameOfSender = ((UserDetails)Session[clsConstant.TOKEN]).FirstName.ToString() + ' ' + ((UserDetails)Session[clsConstant.TOKEN]).LastName.ToString();
// For NIC
objUtl.SendAlertEmail_MC_NIC_NotAttachment(Session["userEmail"].ToString(), "Replied - " + refno
, nameOfSender, null, null,
((UserDetails)Session[clsConstant.TOKEN]).Designation,
((UserDetails)Session[clsConstant.TOKEN]).Agency
);
}
catch (Exception ex)
{
throw ex;
}
}
}
private void LlenaZona()
{
sqlDAZona.Fill(dsZona1, "Zona");
}
private void LlenaConcretera()
{
sqlDAConcretera.Fill(dsConcretera1, "Concretera");
}
protected void Page_Load(object sender, System.EventArgs e)
{
//string connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//CommonFunctions.Connection.ConnectionString = connectionstring;
//if (CommonFunctions.Connection.State == System.Data.ConnectionState.Closed)
//CommonFunctions.Connection.Open ();
//lock (CommonFunctions.Connection)
PropertiesAdapter.Fill(PropertiesFullSet);
//lock (CommonFunctions.Connection)
RegionsAdapter.Fill(RegionsSet);
//lock (CommonFunctions.Connection)
CountriesAdapter.Fill(CountriesSet);
//lock (CommonFunctions.Connection)
StateProvincesAdapter.Fill(StateProvincesSet);
//lock (CommonFunctions.Connection)
CitiesAdapter.Fill(CitiesSet);
//lock (CommonFunctions.Connection)
AmenitiesAdapter.Fill(AmenitiesSet);
//lock (CommonFunctions.Connection)
AttractionsAdapter.Fill(AttractionsSet);
//if (Master.FindControl ("BodyTag") is HtmlGenericControl)
//{
// HtmlGenericControl body = (HtmlGenericControl)Master.FindControl ("BodyTag");
// body.Attributes["onload"] = "InitializeDropdowns ();";
//}
string temp = "Vacation rentals at ";
((System.Web.UI.WebControls.Image)Master.FindControl("Logo")).AlternateText = temp + "Vacations-Abroad.com";
//((System.Web.UI.WebControls.Image)Master.FindControl ("MainLogo")).AlternateText = temp + "@ Vacations-Abroad.com";
foreach (DataRow datarow in RegionsSet.Tables["Regions"].Rows)
{
if (datarow["Region"] is string)
{
regions += " " + (string)datarow["Region"];
}
}
HtmlHead head = Page.Header;
//Page.ClientScript.RegisterClientScriptInclude("aKeyToIdentifyIt", "/scripts/countryStateCity.js");
HtmlMeta keywords = new HtmlMeta();
keywords.Name = "keywords";
if (PropertiesFullSet.Tables["Properties"].Rows.Count < 1)
{
keywords.Content = "View property";
}
else
{
keywords.Content = Keywords.Text.Replace("%regions%", regions.Trim());
}
head.Controls.Add(keywords);
HtmlMeta description = new HtmlMeta();
description.Name = "description";
if (PropertiesFullSet.Tables["Properties"].Rows.Count < 1)
{
description.Content = "View property";
}
else
{
description.Content = Description.Text.Replace("%regions%", regions.Trim());
}
head.Controls.Add(description);
if (!IsPostBack)
{
DataBind();
//Page.Header.Controls.Add(new LiteralControl("<link href='http://vacations-abroad.com/css/StyleSheet.css' rel='stylesheet' type='text/css'></script>"));
Page.Header.Controls.Add(new LiteralControl("<link href='http://vacations-abroad.com/css/StyleSheet.css' rel='stylesheet' type='text/css' />"));
}
DataSet ds = Utility.dsGrab("RegionTextList");
ltlAfrica.Text = ds.Tables[0].Rows[0]["RegionTextValue"].ToString();
ltlAsia.Text = ds.Tables[0].Rows[1]["RegionTextValue"].ToString();
ltlEurope.Text = ds.Tables[0].Rows[2]["RegionTextValue"].ToString();
ltlNorthAmerica.Text = ds.Tables[0].Rows[3]["RegionTextValue"].ToString();
ltlSouthAmerica.Text = ds.Tables[0].Rows[4]["RegionTextValue"].ToString();
ltlOceania.Text = ds.Tables[0].Rows[5]["RegionTextValue"].ToString();
ltlAfricaList.Text = GenerateCountryLinks("1");
ltlAsiaList.Text = GenerateCountryLinks("2");
ltlOceaniaList.Text = GenerateCountryLinks("3");
ltlSouthAmericaList.Text = GenerateCountryLinks("9");
ltlEuropeList.Text = GenerateCountryLinks("6");
ltlNorthAmericaList.Text = GenerateCountryLinks("8");
}
protected void Page_Load(object sender, System.EventArgs e)
{
//footerPropDescContainer.Visible = false;
//string connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//CommonFunctions.Connection.ConnectionString = connectionstring;
//if (CommonFunctions.Connection.State == System.Data.ConnectionState.Closed)
//CommonFunctions.Connection.Open ();
//lock (CommonFunctions.Connection)
PropertiesAdapter.Fill(PropertiesFullSet);
//lock (CommonFunctions.Connection)
RegionsAdapter.Fill(RegionsSet);
//lock (CommonFunctions.Connection)
CountriesAdapter.Fill(CountriesSet);
//lock (CommonFunctions.Connection)
StateProvincesAdapter.Fill(StateProvincesSet);
//lock (CommonFunctions.Connection)
CitiesAdapter.Fill(CitiesSet);
//lock (CommonFunctions.Connection)
AmenitiesAdapter.Fill(AmenitiesSet);
//lock (CommonFunctions.Connection)
AttractionsAdapter.Fill(AttractionsSet);
//if (Master.FindControl ("BodyTag") is HtmlGenericControl)
//{
// HtmlGenericControl body = (HtmlGenericControl)Master.FindControl ("BodyTag");
// body.Attributes["onload"] = "InitializeDropdowns ();";
//}
string temp = "Vacation rentals at ";
// ((System.Web.UI.WebControls.Image)Master.FindControl("Logo")).AlternateText = temp + "Vacations-Abroad.com";
//((System.Web.UI.WebControls.Image)Master.FindControl ("MainLogo")).AlternateText = temp + "@ Vacations-Abroad.com";
foreach (DataRow datarow in RegionsSet.Tables["Regions"].Rows)
{
if (datarow["Region"] is string)
{
regions += " " + (string)datarow["Region"];
}
}
HtmlHead head = Page.Header;
//Page.ClientScript.RegisterClientScriptInclude("aKeyToIdentifyIt", "/scripts/countryStateCity.js");
string Keywords = "Africa Vacation Rentals, Africa Safari Lodges, Africa Beach Resorts, Africa Vacations";
HtmlMeta keywords = new HtmlMeta();
keywords.Name = "keywords";
if (PropertiesFullSet.Tables["Properties"].Rows.Count < 1)
{
keywords.Content = "View property";
}
else
{
keywords.Content = Keywords.Replace("%regions%", regions.Trim());
}
head.Controls.Add(keywords);
string Description = "Explore Africa while staying in our boutique hotels or vacation rentals.";
HtmlMeta description = new HtmlMeta();
description.Name = "description";
if (PropertiesFullSet.Tables["Properties"].Rows.Count < 1)
{
description.Content = "View property";
}
else
{
description.Content = Description.Replace("%regions%", regions.Trim());
}
head.Controls.Add(description);
if (!IsPostBack)
{
DataBind();
// Page.Header.Controls.Add(new LiteralControl("<link href='http://vacations-abroad.com/css/StyleSheet.css' rel='stylesheet' type='text/css' />"));
}
DataSet ds = Utility.dsGrab("RegionTextList");
}
void Message()
{
StringBuilder sb = new StringBuilder();
string[] Msg = null;
if (Request.QueryString["MCID"] != null)
{
Session["MCID"] = Request.QueryString["MCID"].ToString();
}
else if (hdnMCID.Value != string.Empty)
{
Session["MCID"] = hdnMCID.Value;
}
if (Session["MCID"].ToString() != null && Session["MCID"].ToString() != "0")
{
string sql = " SELECT dbo.tblMC.vsMissionClearnceName, dbo.tblMC.CreateDate, dbo.tblMC.bMissionApproved,";
sql = sql + " fromtblUserMaster.vsFirstName as FromFirstName, fromtblUserMaster.vsLastName as FromLastName,";
sql = sql + " fromtblDesignationMaster.vsDesignationName as FromDesignation, TotblUserMaster.vsFirstName AS ToFirstName, TotblUserMaster.vsLastName AS ToLastName,TotblDesignationMaster.vsDesignationName AS ToDesignation";
sql = sql + " FROM dbo.tblMC INNER JOIN ";
sql = sql + " dbo.tblUserMaster fromtblUserMaster ON dbo.tblMC.iFromUser = fromtblUserMaster.iUserID INNER JOIN ";
sql = sql + " dbo.tblDesignationMaster fromtblDesignationMaster ON ";
sql = sql + " fromtblUserMaster.iDesignationID = fromtblDesignationMaster.iDesignationID INNER JOIN ";
sql = sql + " dbo.tblUserMaster AS TotblUserMaster ON dbo.tblMC.iToUser = TotblUserMaster.iUserID ";
sql = sql + " INNER JOIN ";
sql = sql + " dbo.tblDesignationMaster AS TotblDesignationMaster ON TotblUserMaster.iDesignationID = TotblDesignationMaster.iDesignationID ";
sql = sql + " where iMissionClearanceId=" + Session["MCID"].ToString();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter ad = new System.Data.SqlClient.SqlDataAdapter(sql, cn);
DataSet ds1 = new DataSet();
ad.Fill(ds1);
string dtcreate = Convert.ToDateTime(ds1.Tables[0].Rows[0]["CreateDate"].ToString()).ToString("dd MMM yyyy");
if (Request.QueryString["Reject_approved"] != null)
{
if (Request.QueryString["Reject_approved"].ToString() == "Approved")
{
//string fileName = Server.MapPath(@"~/writereaddata/CAAA Letter.pdf")
Msg = File.ReadAllLines(Server.MapPath(@"~/writereaddata/RequestAproval.txt"));
for (int i = 0; i < Msg.Length; i++)
{
Msg[i] = Msg[i].Replace("<user name>", ds1.Tables[0].Rows[0]["FromFirstName"].ToString() + " " + ds1.Tables[0].Rows[0]["FromLastName"].ToString());// (((UserDetails)Session[clsConstant.TOKEN]).userNm).ToString());
Msg[i] = Msg[i].Replace("<Mission clearance reference No>", Session["MCID"].ToString());
Msg[i] = Msg[i].Replace("<Mission clearance reference Description>", ds1.Tables[0].Rows[0]["vsMissionClearnceName"].ToString());
Msg[i] = Msg[i].Replace("<Mission clearance request submission date>", dtcreate.ToString());
Msg[i] = Msg[i].Replace("<sender first name>", ds1.Tables[0].Rows[0]["ToFirstName"].ToString());
Msg[i] = Msg[i].Replace("<sender last name>", ds1.Tables[0].Rows[0]["ToLastName"].ToString());
Msg[i] = Msg[i].Replace("<Designation>", ds1.Tables[0].Rows[0]["ToDesignation"].ToString());
Msg[i] = Msg[i].Replace("<Department of External Affairs>", (((UserDetails)Session[clsConstant.TOKEN]).AgencyName).ToString());
Msg[i] = Msg[i].Replace("<cc list of all original CC list>", "");
}
}
}
else
{
string sqlmsg = " SELECT top 1 REPLACE(convert(varchar(2000),memosendMessage),'<br>','\n') AS memosendMessage FROM tblDocSend";
sqlmsg = sqlmsg + " where imcid=" + Session["MCID"].ToString();
sqlmsg = sqlmsg + " order by idocsendid desc";
SqlConnection cnmsg = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter admsg = new System.Data.SqlClient.SqlDataAdapter(sqlmsg, cnmsg);
DataSet dsmsg = new DataSet();
admsg.Fill(dsmsg);
try
{
Msg = new string[1];
sb.Append(dsmsg.Tables[0].Rows[0]["memoSendMessage"].ToString());
Msg[0] = sb.ToString();
}
catch { }
}
if (Msg != null)
{
for (int i = 0; i < Msg.Length; i++)
{
txtMessage.Text += Msg[i] + "\n";
}
}
Session["Reject_aprovedMessage"] = Msg;
}
}
private void ViewDemoForm_Load(object sender, System.EventArgs e)
{
myAdapter.Fill(myDS);
}
public static void GenerateStandardTableDependencyQueries(string connectionStringTxt, string dest, bool seperateFiles, bool removeFilesOnNewSqlGeneration)
{
if (removeFilesOnNewSqlGeneration)
{
try
{
DirectoryInfo di = new DirectoryInfo(dest);
foreach (FileInfo file in di.GetFiles())
{
file.Delete();
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
if (string.IsNullOrEmpty(connectionStringTxt))
{
throw new Exception("Missing connection settings");
}
string connString = connectionStringTxt;
SqlConnection conn = new SqlConnection(connString);
var cmd = new SqlCommand(query, conn);
conn.Open();
// create data adapter
var da = new System.Data.SqlClient.SqlDataAdapter(cmd);
// this will query your database and return the result to your datatable
_dataTable = new DataTable();
da.Fill(_dataTable);
conn.Close();
da.Dispose();
_sqlBuilder.Length = 0;
_sqlBuilder.Capacity = 0;
foreach (DataRow item in _dataTable.Rows)
{
// 0 1 2 3 4 5
//SchemaName | TableName | ColumnName | ReferenceSchemaName | ReferenceTableName | ReferenceColumnName
//if (!sqlBuilder.ToString().Contains("SELECT * FROM " + item["SchemaName"] + "." + item["TableName"] +
// " AS " + item["TableName"] + "_" + item["TableName"]))
//{
// sqlBuilder.AppendLine("SELECT * FROM " + item["SchemaName"] + "." + item["TableName"] + " AS " +
// item["TableName"] + "_" + item["TableName"]);
//}
if (!_sqlBuilder.ToString().Contains("SELECT * FROM [" + item["TableName"] +
"] AS " + item["TableName"] + "_" + item["TableName"]))
{
_sqlBuilder.AppendLine("SELECT * FROM [" + item["TableName"] + "] AS " +
item["TableName"] + "_" + item["TableName"]);
}
string sql = SqlJoinMakerRecursive(item, item["TableName"] + "_" + item["TableName"]);
_sqlBuilder.AppendLine();
count = 0;
if (seperateFiles)
{
string sqlOutPut = sql.Replace("{", string.Empty).Replace("}", string.Empty).ToString();
Util.SaveOutput(item["TableName"].ToString() + "Query", dest, sqlOutPut);
_sqlBuilder.Clear();
}
}
if (!seperateFiles)
{
string sqlOutPut = _sqlBuilder.Replace("{", string.Empty).Replace("}", string.Empty).ToString();
Util.SaveOutput(conn.Database, dest, sqlOutPut);
_sqlBuilder.Clear();
}
}
public SqlGTResults Execute(SqlConnection connection,
string procedureName)
{
SqlGTResults results = new SqlGTResults();
// Configure the SqlCommand and SqlParameter.
SqlCommand insertCommand = new SqlCommand(procedureName, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
foreach (object p in this.InputParameters.Keys)
{
insertCommand.Parameters.AddWithValue("@" + p, this.InputParameters[p]);
}
foreach (object p in this.InputList.Keys)
{
SqlParameter tvpParam = insertCommand.Parameters.AddWithValue("@" + p,
SqlGTUtil.ConvertToDataTable((List <object>)InputList[p]));
tvpParam.SqlDbType = SqlDbType.Structured;
}
//caso tenha sessao aqui
//e não tenha informado forçar
if (!insertCommand.Parameters.Contains("SESSION_ID") &&
this.session != null)
{
insertCommand.Parameters.AddWithValue("@SESSION_ID", this.session.Id);
}
//executar / pegar resultados
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter(insertCommand);
DataSet ds = new DataSet();
adapter.Fill(ds);
//pegar as tabelas de retorno
foreach (DataTable dt in ds.Tables)
{
if (dt.Rows.Count == 0)
{
continue;
}
//table name
dt.TableName = (string)dt.Rows[0]["OPTION_OUTPUT_TABLE"];
//tabela especial de resultados
if ((string)dt.Rows[0]["OPTION_OUTPUT_TABLE"] == "RESULT")
{
results.ResultCode = (string)dt.Rows[0]["CODIGO"];
results.ResultType = (string)dt.Rows[0]["TIPO"];
results.ResultMessage = (string)dt.Rows[0]["MENSAGEM"];
results.ResultException = (string)dt.Rows[0]["EXCEPTION"];
}
//para cada datable remove coluna de apoio
dt.Columns.Remove("OPTION_OUTPUT_TABLE");
//adiciona
results.Tables.Add(dt);
}
if (results.ResultCode == null)
{
throw new Exception("SqlGT: resposta invalida de procedure não contém dados de controle.");
}
if (!ds.Tables.Contains("DEFAULT"))
{
throw new Exception("SqlGT: resposta invalida de procedure não contém dados padrao de retorno.");
}
return(results);
}
static void Main(string[] args)
{
Console.WriteLine("Input command (/y /d /YM /Missing (Year/Day/YearMonth))");
string command = Console.ReadLine();
string day = "";
int year = 2018;
int month = 1;
int daysback = 31;
string mode = "day";
switch (command)
{
case "/y":
Console.WriteLine("Input year to import: ");
year = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Importing " + year);
mode = "year";
break;
case "/d":
Console.WriteLine("Input day to import(yyyy-DD-mm): ");
day = Console.ReadLine();
Console.WriteLine("Importing " + day);
mode = "Day";
break;
case "/YM":
Console.WriteLine("Input year: ");
year = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Input month: ");
month = Convert.ToInt32(Console.ReadLine());
mode = "YM";
break;
case "/Missing":
Console.WriteLine("Type how many days back to check: ");
daysback = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Importing data from " + daysback + " days back");
mode = "Missing";
break;
default:
break;
}
if (mode == "YM")
{
GetDatesMonth(year, month);
}
if (mode == "Day")
{
FetchData(day);
}
if (mode == "year")
{
GetDatesYear(year);
}
if (mode == "Missing")
{
Console.WriteLine("Got into Missing mode");
//Get missing dates from sql proc
var connection = System.Configuration.ConfigurationManager.ConnectionStrings["PostListe"].ConnectionString;
using (SqlConnection db = new SqlConnection(connection))
{
db.Open();
SqlCommand GetMissingDates = new SqlCommand(@"[PostListe].[dbo].[GetMissingDays]", db);
Console.WriteLine(GetMissingDates);
GetMissingDates.Parameters.AddWithValue("@DaysBack", daysback);
GetMissingDates.CommandType = CommandType.StoredProcedure;
SqlDataAdapter MissingDatesResult = new System.Data.SqlClient.SqlDataAdapter(GetMissingDates);
DataSet ds = new DataSet();
MissingDatesResult.Fill(ds);
Console.WriteLine(ds.Tables[0].DefaultView);
foreach (DataTable table in ds.Tables)
{
foreach (DataRow dr in table.Rows)
{
Console.WriteLine(dr["DateLookup"].ToString());
string CleanDate = dr["DateLookup"].ToString().Replace(" 00.00.00", "");
FetchData(CleanDate);
}
}
db.Close();
}
}
Console.ReadKey();
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (propertyid == -1)
{
Response.Redirect(backlinkurl);
}
//string connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
//CommonFunctions.Connection.ConnectionString = connectionstring;
//if (CommonFunctions.Connection.State == System.Data.ConnectionState.Closed)
//CommonFunctions.Connection.Open ();
object retval = null;
using (SqlConnection connection = CommonFunctions.GetConnection()) {
connection.Open();
SqlCommand checkuserid = new SqlCommand("SELECT UserID FROM Properties WHERE ID=@PropertyID", connection);
checkuserid.Parameters.Add("@PropertyID", SqlDbType.Int, 4, "PropertyID");
checkuserid.Parameters["@PropertyID"].Value = propertyid;
retval = checkuserid.ExecuteScalar();
connection.Close();
}
if (!(retval is int))
{
Response.Redirect(backlinkurl);
}
if (((int)retval != userid) && !AuthenticationManager.IfAdmin)
{
Response.Redirect(CommonFunctions.PrepareURL("Login.aspx?BackLink=" + HttpUtility.UrlEncode(Request.Url.ToString())));
}
object retval2 = null;
using (SqlConnection connection = CommonFunctions.GetConnection()) {
connection.Open();
SqlCommand checkauction = new SqlCommand("SELECT COUNT(*) " +
"FROM Auctions WHERE (Auctions.PropertyID = @PropertyID)", connection);
checkauction.Parameters.Add("@PropertyID", SqlDbType.Int, 4, "PropertyID");
checkauction.Parameters["@PropertyID"].Value = propertyid;
retval2 = checkauction.ExecuteScalar();
connection.Close();
}
ifauction = (retval2 is int) && ((int)retval2 > 0);
if (ifauction)
{
object retval3 = null;
using (SqlConnection connection = CommonFunctions.GetConnection()) {
connection.Open();
SqlCommand checkpaid = new SqlCommand("SELECT COUNT(*) " +
"FROM Transactions INNER JOIN Auctions ON Transactions.AuctionID = Auctions.ID " +
"WHERE (Auctions.PropertyID = @PropertyID) AND (Transactions.IfListingFee = 1)" +
" AND (Transactions.PaymentAmount >= Transactions.InvoiceAmount) AND (AuctionEnd < GETDATE())", connection);
checkpaid.Parameters.Add("@PropertyID", SqlDbType.Int, 4, "PropertyID");
checkpaid.Parameters["@PropertyID"].Value = propertyid;
retval3 = checkpaid.ExecuteScalar();
connection.Close();
}
ifallow = (retval3 is int) && ((int)retval3 > 0);
AllowedWarning.Text = "You can review emails only for finished and paid auctions.";
}
else
{
using (SqlConnection connection = CommonFunctions.GetConnection()) {
connection.Open();
SqlCommand checkpaid = new SqlCommand("SELECT COUNT(*) FROM Invoices WHERE (Invoices.PropertyID =" +
" @PropertyID) AND (PaymentAmount >= InvoiceAmount) AND (GETDATE() <= RenewalDate)", connection);
checkpaid.Parameters.Add("@PropertyID", SqlDbType.Int, 4, "PropertyID");
checkpaid.Parameters["@PropertyID"].Value = propertyid;
object retval3 = checkpaid.ExecuteScalar();
SqlCommand getstartdate = new SqlCommand("SELECT DateStartViewed FROM Properties WHERE ID = @PropertyID",
connection);
getstartdate.Parameters.Add("@PropertyID", SqlDbType.Int, 4, "PropertyID");
getstartdate.Parameters["@PropertyID"].Value = propertyid;
object retval4 = getstartdate.ExecuteScalar();
ifallow = ((retval3 is int) && ((int)retval3 > 0)) || ((retval4 is DateTime) &&
((DateTime.Now - (DateTime)retval4).TotalDays <= 60));
connection.Close();
}
AllowedWarning.Text = "You can review emails only for paid properties.";
}
if (AuthenticationManager.IfAuthenticated && AuthenticationManager.IfAdmin)
{
ifallow = true;
}
AllowedWarning.Visible = !ifallow;
EmailsAdapter.SelectCommand.Parameters["@PropertyID"].Value = propertyid;
//lock (CommonFunctions.Connection)
EmailsAdapter.Fill(EmailsSet);
if (!IsPostBack)
{
DataBind();
}
}
private void btnExecute_Click(object sender, EventArgs e)
{
DataSet MyDataSet = new DataSet();
System.Data.SqlClient.SqlDataAdapter DataAdapter = new System.Data.SqlClient.SqlDataAdapter();
System.Data.SqlClient.SqlConnection myConnection = GetCnn();// new System.Data.SqlClient.SqlConnection(DBConnStr);
if (myConnection.State != ConnectionState.Open)
{
myConnection.Open();
}
System.Data.SqlClient.SqlCommand myCommand = new System.Data.SqlClient.SqlCommand(); //("select 1", myConnection);
myCommand.Connection = myConnection;
myCommand.CommandType = CommandType.Text; // StoredProcedure;
this.prgExec.Maximum = Procs.Count;
prgExec.Value = 0;
this.Text = string.Empty;
string folder = txtDB.Text + (chkNew.Checked == true ? "AfterMove" : string.Empty);
if (!Directory.Exists(folder))
{
Directory.CreateDirectory(folder);
}
foreach (var proc in Procs)
{
txtProcs.Clear();
txtProcs.AppendText(proc.Cmd);
Application.DoEvents();
myCommand.CommandText = proc.Cmd;
DataAdapter.SelectCommand = myCommand;
DataAdapter.Fill(MyDataSet, "table");
DataTable tb = MyDataSet.Tables[0].DefaultView.ToTable(true, proc.Columns.ToArray());
tb.WriteXml(
string.Format("{0}\\{1}.xml",
folder
, proc.FileName
), true);
prgExec.Value += 1;
MyDataSet.Clear();
}
dataGridView1.DataSource = MyDataSet.Tables[0];
this.Text = "success";
if (myConnection.State == ConnectionState.Open)
{
myConnection.Close();
}
}
public void Ejecutar_Consulta(string strSQL)
{
_da = new System.Data.SqlClient.SqlDataAdapter(strSQL, _cn);
_da.Fill(_ds);
_tabla = _ds.Tables[0];
}
//-----------------------------------------------------------------------------
//Funcion: EjecucionConsulta
//Parámetro: bTiparDataset (System.Boolean)
//Retorno: (System.Data.DataSet)
//Descripcion: Ejecuta la consulta a partir de la consultaSQL , cadena de conexión que se le haya pasado.
// Si se le pone bTiparDataset, el dataset resultante tiene información del Esquema
//-----------------------------------------------------------------------------
//public System.Data.DataSet EjecucionConsulta(bool bTiparDataset)
//{
// DataSet dsActual = new DataSet();
// this.EjecucionConsulta(ref dsActual, bTiparDataset, String.Empty, null);
// return dsActual;
//}
//-----------------------------------------------------------------------------
//Funcion: EjecucionConsulta
//Parámetro: dsActual (System.Data.DataSet)
//Parámetro: bTiparDataset (System.Boolean)
//Descripcion: Ejecuta la consulta a partir de la consultaSQL , cadena de conexión que se le haya pasado.
// Si se le pone bTiparDataset, el dataset resultante tiene información del Esquema
// Rellena los datos resultantes en el dataset pasado
//-----------------------------------------------------------------------------
//public void EjecucionConsulta(ref DataSet dsActual, bool bTiparDataset)
//{
// this._EjecucionConsulta(ref dsActual, bTiparDataset, String.Empty, null, CommandType.Text);
//}
//-----------------------------------------------------------------------------
//Funcion: EjecucionConsulta
//Parámetro: dsActual (System.Data.DataSet)
//Parámetro: bTiparDataset (System.Boolean)
//Parámetro: NombreTablaDestino (System.String)
//Descripcion: Ejecuta la consulta a partir de la consultaSQL , cadena de conexión que se le haya pasado.
// Si se le pone bTiparDataset, el dataset resultante tiene información del Esquema
// Rellena los datos resultantes en el dataset pasado
// Asigna al dataset pasado el nombre de tabla tambien pasado
//-----------------------------------------------------------------------------
//public void EjecucionConsulta(ref DataSet dsActual, bool bTiparDataset, string NombreTablaDestino)
//{
// this._EjecucionConsulta(ref dsActual, bTiparDataset, NombreTablaDestino, null, CommandType.Text);
//}
//-----------------------------------------------------------------------------
//Funcion: EjecucionConsulta
//Parámetro: dsActual (System.Data.DataSet)
//Parámetro: bTiparDataset (System.Boolean)
//Parámetro: NombreTablaDestino (System.String)
//Parámetro: oTransaccion (System.Data.IDbTransaction)
//Descripcion: Ejecuta la consulta a partir de la consultaSQL , cadena de conexión que se le haya pasado.
// Si se le pone bTiparDataset, el dataset resultante tiene información del Esquema
// Rellena los datos resultantes en el dataset pasado
// Asigna al dataset pasado el nombre de tabla tambien pasado
// Si se le pasa la transacción, se obtiene la conexion del otransaccion
//-----------------------------------------------------------------------------
//public void EjecucionConsulta(ref DataSet dsActual, bool bTiparDataset, string NombreTablaDestino, System.Data.IDbTransaction oTransaccion)
//{
// this._EjecucionConsulta(ref dsActual, bTiparDataset, NombreTablaDestino, oTransaccion, CommandType.Text);
//}
//-----------------------------------------------------------------------------
//Funcion: EjecucionConsulta
//Parámetro: dsActual (System.Data.DataSet)
//Parámetro: bTiparDataset (System.Boolean)
//Parámetro: NombreTablaDestino (System.String)
//Parámetro: oTransaccion (System.Data.IDbTransaction)
//Descripcion: Ejecuta la consulta a partir de la consultaSQL , cadena de conexión que se le haya pasado.
// Si se le pone bTiparDataset, el dataset resultante tiene información del Esquema
// Rellena los datos resultantes en el dataset pasado
// Asigna al dataset pasado el nombre de tabla tambien pasado
// Si se le pasa la transacción, se obtiene la conexion del otransaccion
//-----------------------------------------------------------------------------
//private void _EjecucionConsulta(ref DataSet dsActual, bool bTiparDataset, string NombreTablaDestino, System.Data.IDbTransaction oTransaccion, System.Data.CommandType Tipoconsulta)
//{
// System.Data.SqlClient.SqlConnection oSqlConnection;
// System.Data.SqlClient.SqlDataAdapter oSqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter();
// System.Data.SqlClient.SqlCommand oSqlCommand = new System.Data.SqlClient.SqlCommand();
// bool bTransaccionCreadaEnLaFuncion = true;
// // si se le pasa una transaccion, le asignamos la conexion
// if (oTransaccion != null)
// {
// bTransaccionCreadaEnLaFuncion = false;
// oSqlConnection = ((System.Data.SqlClient.SqlConnection)oTransaccion.Connection);
// }
// else
// {
// oSqlConnection = new System.Data.SqlClient.SqlConnection();
// }
// try
// {
// // Si de antemano, sabemos que no es posible la ejecución lanzamos el error.
// if (this.CadenaConexion == String.Empty)
// {
// throw new Exception("Falta establecer la cadena de conexión");
// }
// if (this.ConsultaSQL == String.Empty)
// {
// throw new Exception("Falta establecer la cadena de consulta");
// }
// oSqlCommand.Connection = oSqlConnection;
// oSqlCommand.CommandType = Tipoconsulta;
// oSqlCommand.CommandText = this.ConsultaSQL;
// if (this.nTiempoEjecucionConsulta != -1)
// {
// oSqlCommand.CommandTimeout = nTiempoEjecucionConsulta;
// }
// for (int nInd = 0; nInd < this._NombreParametros.Count; nInd++)
// {
// // oSqlCommand.Parameters.Add("@" + Convert.ToString(_NombreParametros(nInd)), Convert.ToString(_ValorParametros(nInd)));
// oSqlCommand.Parameters.AddWithValue("@" + Convert.ToString(_NombreParametros[nInd]), Convert.ToString(_ValorParametros[nInd]));
// }
// // si no tiene transaccion, asignamos la cadena de conexion y la abrimos
// if (oTransaccion == null)
// {
// oSqlConnection.ConnectionString = this.CadenaConexion;
// oSqlConnection.Open();
// oTransaccion = oSqlConnection.BeginTransaction(IsolationLevel.ReadUncommitted);
// oSqlCommand.Transaction = ((System.Data.SqlClient.SqlTransaction)oTransaccion);
// }
// else
// {
// oSqlCommand.Transaction = ((System.Data.SqlClient.SqlTransaction)oTransaccion);
// }
// oSqlDataAdapter.SelectCommand = oSqlCommand;
// if ((NombreTablaDestino != null && NombreTablaDestino != String.Empty))
// {
// if (NombreTablaDestino.IndexOf(";") > -1)
// { //si hay mas de una tabla, hay que hacer un mapeo de ellas
// string[] tablas;
// tablas = Split(NombreTablaDestino, ";");
// int i = 0;
// oSqlDataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping() { new System.Data.Common.DataTableMapping("Table", dsActual.Tables[0].TableName, new System.Data.Common.DataColumnMapping(-1) { }) });
// for (i = 1; i < tablas.Length; i++)
// {
// oSqlCommand.Parameters.AddWithValue("@" + Convert.ToString(_NombreParametros[nInd]), Convert.ToString(_ValorParametros[nInd]));
// }
// oSqlDataAdapter.Fill(dsActual);
// }
// else
// {
// oSqlDataAdapter.Fill(dsActual, NombreTablaDestino);
// }
// }
// else
// {
// oSqlDataAdapter.Fill(dsActual);
// }
// if (bTiparDataset)
// {
// oSqlDataAdapter.FillSchema(dsActual, SchemaType.Mapped);
// }
// }
// catch (Exception ex)
// {
// if (bTransaccionCreadaEnLaFuncion)
// {
// oTransaccion.Rollback();
// }
// }
// finally
// {
// // si la transaccion es nula, se cierra la conexion
// if (oTransaccion == null || bTransaccionCreadaEnLaFuncion)
// {
// if (oSqlConnection != null)
// {
// if (oTransaccion != null && oTransaccion.Connection !== null)
// {
// oTransaccion.Commit();
// oTransaccion.Dispose();
// }
// if (oSqlConnection.State != ConnectionState.Closed)
// {
// oSqlConnection.Close();
// }
// oSqlConnection.Dispose();
// }
// }
// }
//}
#endregion
// TODO: saber donde se utiliza!
//public System.Data.DataSet EjecucionConsulta(bool bTiparDataset, int filaOrigen, int nLineas, string nombreTabla)
public System.Data.DataSet EjecucionConsulta(bool bTiparDataset, string nombreTabla)
{
System.Data.SqlClient.SqlConnection oSqlConnection = new System.Data.SqlClient.SqlConnection();
System.Data.SqlClient.SqlDataAdapter oSqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter();
System.Data.SqlClient.SqlCommand oSqlCommand = new System.Data.SqlClient.SqlCommand();
System.Data.DataSet oDataset = new System.Data.DataSet();
int nInd; //Contador para bucle insercion parametros
try
{
//Si de antemano, sabemos que no es posible la ejecución lanzamos el error.
if (this.CadenaConexion == String.Empty)
{
throw new Exception("Falta establecer la cadena de conexión");
}
if (this.ConsultaSQL == String.Empty)
{
throw new Exception("Falta establecer la cadena de consulta");
}
oSqlCommand.Connection = oSqlConnection;
oSqlCommand.CommandType = CommandType.Text;
oSqlCommand.CommandText = this.ConsultaSQL;
if (this.nTiempoEjecucionConsulta != -1)
{
oSqlCommand.CommandTimeout = nTiempoEjecucionConsulta;
}
for (nInd = 0; nInd < this._NombreParametros.Count; nInd++)
{
// oSqlCommand.Parameters.Add("@" + Convert.ToString(_NombreParametros(nInd)), Convert.ToString(_ValorParametros(nInd)));
oSqlCommand.Parameters.AddWithValue("@" + Convert.ToString(_NombreParametros[nInd]), Convert.ToString(_ValorParametros[nInd]));
}
oSqlConnection.ConnectionString = this.CadenaConexion;
oSqlConnection.Open();
oSqlDataAdapter.SelectCommand = oSqlCommand;
//oSqlDataAdapter.Fill(oDataset, filaOrigen, nLineas, nombreTabla);
oSqlDataAdapter.Fill(oDataset, nombreTabla);
if (bTiparDataset)
{
oSqlDataAdapter.FillSchema(oDataset, SchemaType.Mapped);
}
return(oDataset);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (oSqlConnection != null)
{
if (oSqlConnection.State != ConnectionState.Closed)
{
oSqlConnection.Close();
}
oSqlConnection.Dispose();
}
}
}
private void LlenaNivel()
{
sqlDANivel.Fill(dsNivel1, "Nivel");
}
string Message(string _Type, string MCID, string Description, out string refno)
{
StringBuilder sb = new StringBuilder();
sb.Append("");
string _message = string.Empty;
string _finalMessage = string.Empty;
string[] Msg = null;
refno = string.Empty;
if (MCID != null)
{
string sql = " SELECT dbo.tblMC.vsMissionClearnceName, dbo.tblMC.CreateDate, dbo.tblMC.bMissionApproved, fromtblUserMaster.vsFirstName AS FromFirstName, ";
sql = sql + " fromtblUserMaster.vsLastName AS FromLastName, fromtblDesignationMaster.vsDesignationName AS FromDesignation, ";
sql = sql + " TotblUserMaster.vsFirstName AS ToFirstName, TotblUserMaster.vsLastName AS ToLastName, TotblDesignationMaster.vsDesignationName AS ToDesignation, ";
sql = sql + " fromtblUserMaster.iAgencyID, tblAgency_1.vsAgencyName AS FrmAgency, dbo.tblAgency.vsAgencyName AS ToAgency ";
sql = sql + " FROM dbo.tblMC INNER JOIN ";
sql = sql + " dbo.tblUserMaster AS fromtblUserMaster ON dbo.tblMC.iFromUser = fromtblUserMaster.iUserID INNER JOIN ";
sql = sql + " dbo.tblDesignationMaster AS fromtblDesignationMaster ON fromtblUserMaster.iDesignationID = fromtblDesignationMaster.iDesignationID INNER JOIN ";
sql = sql + " dbo.tblUserMaster AS TotblUserMaster ON dbo.tblMC.iToUser = TotblUserMaster.iUserID INNER JOIN ";
sql = sql + " dbo.tblDesignationMaster AS TotblDesignationMaster ON TotblUserMaster.iDesignationID = TotblDesignationMaster.iDesignationID INNER JOIN";
sql = sql + " dbo.tblAgency AS tblAgency_1 ON fromtblUserMaster.iAgencyID = tblAgency_1.iAgencyID INNER JOIN ";
sql = sql + " dbo.tblAgency ON TotblUserMaster.iAgencyID = dbo.tblAgency.iAgencyID";
sql = sql + " WHERE dbo.tblMC.iMissionClearanceId =" + MCID;
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter ad = new System.Data.SqlClient.SqlDataAdapter(sql, cn);
DataSet ds1 = new DataSet();
ad.Fill(ds1);
string dtcreate = Convert.ToDateTime(ds1.Tables[0].Rows[0]["CreateDate"].ToString()).ToString("dd MMM yyyy");
refno = ds1.Tables[0].Rows[0]["vsMissionClearnceName"].ToString();
if (_Type.ToString() == "Approved")
{
Msg = File.ReadAllLines(Server.MapPath(@"~/writereaddata/RequestAproval.txt"));
for (int i = 0; i < Msg.Length; i++)
{
Msg[i] = Msg[i].Replace("<user name>", ds1.Tables[0].Rows[0]["FromFirstName"].ToString() + " " + ds1.Tables[0].Rows[0]["FromLastName"].ToString());// (((UserDetails)Session[clsConstant.TOKEN]).userNm).ToString());
Msg[i] = Msg[i].Replace("<Mission clearance reference No>", Request.QueryString["MCID"].ToString());
Msg[i] = Msg[i].Replace("<Mission clearance reference Description>", ds1.Tables[0].Rows[0]["vsMissionClearnceName"].ToString());
Msg[i] = Msg[i].Replace("<Mission clearance request submission date>", dtcreate.ToString());
Msg[i] = Msg[i].Replace("<sender first name>", ds1.Tables[0].Rows[0]["ToFirstName"].ToString());
Msg[i] = Msg[i].Replace("<sender last name>", ds1.Tables[0].Rows[0]["ToLastName"].ToString());
Msg[i] = Msg[i].Replace("<Designation>", ds1.Tables[0].Rows[0]["ToDesignation"].ToString());
Msg[i] = Msg[i].Replace("<Department of External Affairs>", (((UserDetails)Session[clsConstant.TOKEN]).AgencyName).ToString());
Msg[i] = Msg[i].Replace("<cc list of all original CC list>", "");
}
for (int i = 0; i < Msg.Length; i++)
{
_finalMessage += Msg[i] + "\n";
}
sb.Append("");
sb.Append("");
sb.Append("------------------ Message ----------------\n");
string sqlmsg = " SELECT top 1 REPLACE(convert(varchar(2000),memosendMessage),'<br>','\n') AS memosendMessage FROM tblDocSend";
sqlmsg = sqlmsg + " where imcid=" + MCID;
sqlmsg = sqlmsg + " order by idocsendid desc";
SqlConnection cnmsg = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter admsg = new System.Data.SqlClient.SqlDataAdapter(sqlmsg, cnmsg);
DataSet dsmsg = new DataSet();
admsg.Fill(dsmsg);
try
{
_message = _finalMessage + sb.ToString() + dsmsg.Tables[0].Rows[0]["memoSendMessage"].ToString();
}
catch { }
}
else if (_Type.ToString() == "Rejected")
{
Msg = File.ReadAllLines(Server.MapPath(@"~/writereaddata/RequestRejection.txt"));
for (int i = 0; i < Msg.Length; i++)
{
Msg[i] = Msg[i].Replace("<user name>", ds1.Tables[0].Rows[0]["FromFirstName"].ToString() + " " + ds1.Tables[0].Rows[0]["FromLastName"].ToString());// (((UserDetails)Session[clsConstant.TOKEN]).userNm).ToString());
Msg[i] = Msg[i].Replace("<Mission clearance reference No>", MCID);
Msg[i] = Msg[i].Replace("<Mission clearance reference Description>", ds1.Tables[0].Rows[0]["vsMissionClearnceName"].ToString());
Msg[i] = Msg[i].Replace("<Mission clearance request submission date>", dtcreate.ToString());
Msg[i] = Msg[i].Replace("<Reasons>", Description);
Msg[i] = Msg[i].Replace("<sender first name>", (((UserDetails)Session[clsConstant.TOKEN]).FirstName).ToString());
Msg[i] = Msg[i].Replace("<sender last name>", (((UserDetails)Session[clsConstant.TOKEN]).LastName).ToString());
Msg[i] = Msg[i].Replace("<Designation>", (((UserDetails)Session[clsConstant.TOKEN]).Designation).ToString());
Msg[i] = Msg[i].Replace("<Department of External Affairs>", (((UserDetails)Session[clsConstant.TOKEN]).AgencyName).ToString());
Msg[i] = Msg[i].Replace("<cc list of all original CC list>", "");
}
for (int i = 0; i < Msg.Length; i++)
{
_message += Msg[i] + "\n";
}
sb.Append("");
sb.Append("");
sb.Append("------------------ Message ----------------\n");
string sqlmsg = " SELECT top 1 REPLACE(convert(varchar(2000),memosendMessage),'<br>','\n') AS memosendMessage FROM tblDocSend";
sqlmsg = sqlmsg + " where imcid=" + MCID;
sqlmsg = sqlmsg + " order by idocsendid desc";
SqlConnection cnmsg = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter admsg = new System.Data.SqlClient.SqlDataAdapter(sqlmsg, cnmsg);
DataSet dsmsg = new DataSet();
admsg.Fill(dsmsg);
try
{
_message = _message + sb.ToString() + dsmsg.Tables[0].Rows[0]["memoSendMessage"].ToString();
}
catch { }
_finalMessage = _message;
}
else if (_Type.ToString() == "Clarification")
{
sb.Append("\n");
sb.Append(File.ReadAllText(Server.MapPath(@"~/writereaddata/Clarification.txt")));
sb.Replace("<Mission clearance reference No>", MCID.ToString());
sb.Replace("<Mission clearance reference Description>", ds1.Tables[0].Rows[0]["vsMissionClearnceName"].ToString());
sb.Replace("The following clarifications are needed :", "The following clarifications are needed :\n" + Description);
sb.Append("");
sb.Append("------------------ Message ----------------\n");
string sqlmsg = " SELECT top 1 REPLACE(convert(varchar(2000),memosendMessage),'<br>','\n') AS memosendMessage FROM tblDocSend";
sqlmsg = sqlmsg + " where imcid=" + MCID;
sqlmsg = sqlmsg + " order by idocsendid desc";
SqlConnection cnmsg = new SqlConnection(ConfigurationManager.ConnectionStrings["TA7511DBConnString"].ConnectionString);
SqlDataAdapter admsg = new System.Data.SqlClient.SqlDataAdapter(sqlmsg, cnmsg);
DataSet dsmsg = new DataSet();
admsg.Fill(dsmsg);
try
{
_message = dsmsg.Tables[0].Rows[0]["memoSendMessage"].ToString();
}
catch { }
_finalMessage = sb.ToString() + _message;
}
}
return(_finalMessage);
}
private void LlenasSqlDA()
{
sqlDAConcentra.SelectCommand.Parameters["@IdObra"].Value = cmbIdObra.SelectedValue.ToString();
sqlDAConcentra.Fill(dsConcentra1, "Concentra");
}
