private void BindData()
{
recruiter.OrganisationName = Request["OrgName"].ToString();
DetailsView1.DataSource = recruiter.ShowOrganizationDetailByOrg();
DetailsView1.DataBind();
}
private void atualizarGrid()
{
GridView1.DataBind();
DetailsView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DetailsView1.DataSource = PerformanceAnalyzer2.BusinessLogicLayer.StudentLogic.getStudentProfileData(Session["userID"]);
DetailsView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
DetailsView1.Visible = true;
DetailsView1.DataBind();
Button1.Visible = false;
}
public void bind()
{
DetailsView1.DataSource = bs.bs_bind();
DetailsView1.DataBind();
}
private void UpdateDetailsView()
{
DetailsView1.DataSource = DataAccess.selectQuery("Select * from Orders where ID=" + id);
DetailsView1.DataBind();
}
public void bindGrid()
{
DetailsView1.DataSource = objStudent_BLL.GetAllData();
DetailsView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
MySqlConnection con = new MySqlConnection("server=46.105.105.77;user id=nscommun_taha;password=timein;database=nscommun_BugTrackingSystem;persistsecurityinfo=True");
//TextBox4.Text = Session["Edit4"].ToString();
// TextBox5.Text = Session["Edit5"].ToString();
//TextBox6.Text = Session["Edit6"].ToString();
MySqlCommand com2 = new MySqlCommand("select Bug_Report.*,Status.Status from Bug_Report,Status where Status.BugId = Bug_Report.BugId and Bug_Report.BugId = '" + Session["BugIdReference"].ToString() + "' ", con);
//MySqlCommand com3 = new MySqlCommand("select Status.Status from Status inner join Bug_Report on Status.BugId = Bug_Report.BugId and Bug_Report.Title = '" + Session["BugIdReference2"].ToString() + "' ", con2);
MySqlDataAdapter sda = new MySqlDataAdapter(com2);
DataTable dt2 = new DataTable();
sda.Fill(dt2);
con.Open();
DetailsView1.DataSource = dt2;
DetailsView1.DataBind();
con.Close();
/* reader = com2.ExecuteReader();
* // reader2 = com3.ExecuteReader();
*
* while (reader.Read()&&reader2.Read())
* {
* Label2.Text = reader["Title"].ToString();
* TextBox1.Text = reader["Title"].ToString();
* TextBox2.Text = reader["Detail"].ToString();
* TextBox3.Text = reader["Severity"].ToString();
* TextBox4.Text = reader["Priority"].ToString();
* TextBox5.Text = reader["ProjectFile"].ToString();
* TextBox6.Text = reader2["Status"].ToString();
*
* }
*
*
*
* DataTable dt = new DataTable();
* dt.Columns.Add("BugId");
* dt.Columns.Add("Title");
* dt.Columns.Add("Serverity");
* dt.Columns.Add("Priority");
* dt.Columns.Add("Status");
*
*
* while (reader.Read() && reader2.Read())
* {
* DataRow row = dt.NewRow();
* row["BugId"] = reader["BugId"];
* row["Title"] = reader["Title"];
* row["Serverity"] = reader["Severity"];
* row["Priority"] = reader["Priority"];
* row["Status"] = reader2["Status"];
*
*
*
* dt.Rows.Add(row);
* }
*
* // DetailsView1.DataSource = dt;
* // DetailsView1.DataBind();
*
*/
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
InmueblesBLL bllInmuebles = new InmueblesBLL();
dt = bllInmuebles.SeleccionaInmueblesPorID(Convert.ToInt32(Session["IdInmueble"].ToString()));
if (dt.Rows.Count != 0)
{
Session["grd_ItemList2"] = dt;
LlenarDetailsView();
DetailsView1.DataSource = dt;
DetailsView1.DataBind();
DetailsView2.DataSource = dt;
DetailsView2.DataBind();
GoogleMarker marker = new GoogleMarker(dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString() + "," + dt.Rows[0]["NombreLocalidad"].ToString() + "," + dt.Rows[0]["NombreProvincia"].ToString());
GoogleMap1.Markers.Add(marker);
Coordinate coordinate = Geocode.GetCoordinates(dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString() + "," + dt.Rows[0]["NombreLocalidad"].ToString() + "," + dt.Rows[0]["NombreProvincia"].ToString());
decimal latitude = coordinate.Latitude;
decimal longitude = coordinate.Longitude;
GoogleMap1.Latitude = convert(latitude); //-32.9400639;
GoogleMap1.Longitude = convert(longitude); //-60.6600255;
marker.Text = dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString() + "," + dt.Rows[0]["NombreLocalidad"].ToString() + "," + dt.Rows[0]["NombreProvincia"].ToString();
string g = marker.ToJsonString();
string strRutaFoto = Server.MapPath("~\\Image_Upload\\" + Session["IdInmueble"].ToString() + "-" + "01" + "_thumb.jpg");
Boolean strFoto = (System.IO.File.Exists(strRutaFoto));
if (strFoto)
{
Image1.Visible = true;
Image1.ImageUrl = this.Page.ResolveClientUrl("~\\Image_Upload\\" + Session["IdInmueble"].ToString() + "-" + "01" + "_thumb.jpg");
}
else
{
Image1.Visible = false;
}
//Googleimagen.ImageUrl = this.Page.ResolveUrl("http://maps.google.com/staticmap?zoom=15&size=320x342&markers=" + longitude + "," + latitude + "&key=ABQIAAAApU_iFCnQtFqCJz_RVHKf6hSIMON3V3yf7e-rtPXBV5YPjpYuCRQqSKQQMFkEFT-8V8ujIAr2-XcoIQ");
Googleimagen.ImageUrl = "http://maps.google.com/staticmap?zoom=15&size=259x250&markers=" + GoogleMap1.Latitude.ToString().Replace(",", ".") + "," + GoogleMap1.Longitude.ToString().Replace(",", ".") + "&key=ABQIAAAApU_iFCnQtFqCJz_RVHKf6hSIMON3V3yf7e-rtPXBV5YPjpYuCRQqSKQQMFkEFT-8V8ujIAr2-XcoIQ";
}
else if (dt.Rows.Count == 0)
{
}
HiddenFielddireccion.Value = dt.Rows[0]["Calle"].ToString() + " " + dt.Rows[0]["Numero"].ToString();
HiddenFieldzona.Value = dt.Rows[0]["Zona"].ToString();
HiddenFieldtipoinmueble.Value = dt.Rows[0]["TipoDeInmueble"].ToString();
HiddenFieldestadoinmueble.Value = dt.Rows[0]["Estado"].ToString();
HiddenFieldprovincia.Value = dt.Rows[0]["NombreProvincia"].ToString();
HiddenFieldlocalidad.Value = dt.Rows[0]["NombreLocalidad"].ToString();
HiddenFieldpiso.Value = dt.Rows[0]["Piso"].ToString();
HiddenFielddepartamento.Value = dt.Rows[0]["Departamento"].ToString();
HiddenFieldentrecalle.Value = dt.Rows[0]["Calle1"].ToString();
HiddenFieldycalle.Value = dt.Rows[0]["Calle2"].ToString();
HiddenFieldmetroscuadcubiertos.Value = dt.Rows[0]["MetroCuadrados"].ToString();
HiddenFieldmetroscuadsemicubiertos.Value = dt.Rows[0]["MetrosCuadradosSemiCub"].ToString();
HiddenFieldposicion.Value = dt.Rows[0]["Frente"].ToString();
HiddenFieldcochera.Value = dt.Rows[0]["Fondo"].ToString();
HiddenFieldposicion.Value = dt.Rows[0]["Posicion"].ToString();
HiddenFieldcochera.Value = dt.Rows[0]["Cocheras"].ToString();
HiddenFieldAntiguedad.Value = dt.Rows[0]["Antiguedad"].ToString();
HiddenFieldAntiguedadA.Value = dt.Rows[0]["AntiguedadA"].ToString();
HiddenFieldOperacion.Value = dt.Rows[0]["Operacion"].ToString();
HiddenFieldPrecioVenta.Value = dt.Rows[0]["PrecioVenta"].ToString();
HiddenFieldPrecioAlquiler.Value = dt.Rows[0]["PrecioAlquiler"].ToString();
HiddenFieldComision.Value = dt.Rows[0]["Comision"].ToString();
HiddenFieldFechaAlta.Value = dt.Rows[0]["FechaAlta"].ToString();
HiddenFieldFechaActualiza.Value = dt.Rows[0]["FechaActualiza"].ToString();
HiddenFieldMailUsuario.Value = dt.Rows[0]["MailUsuario"].ToString();
HiddenFieldObservaciones.Value = dt.Rows[0]["Observaciones"].ToString();
HiddenFieldimagen.Value = this.Page.ResolveClientUrl(Session["IdInmueble"].ToString() + "-" + "01" + "_thumb.jpg");
HiddenFieldgooglemapsimage.Value = "http://maps.googleapis.com/maps/api/staticmap?markers=" + GoogleMap1.Latitude.ToString().Replace(",", ".") + "," + GoogleMap1.Longitude.ToString().Replace(",", ".") + "&zoom=15&size=260x194&sensor=false";
}
catch
{
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
DetailsView1.PageIndex = GridView1.SelectedIndex;
DetailsView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
String jsonString = new WebClient().DownloadString("http://api.myapifilms.com/trailerAddict/taapi?idIMDB=" + Request.QueryString["ID"] + "&width=270&token=244f0fe9-66e4-41f4-8d7c-f4b1dcf8b39d&featured=&count=1&credit=&format=json");;
JObject hh = JObject.Parse(jsonString);
string name = (string)hh["data"]["trailer"][0]["embed"];
trailer.InnerHtml = name;
}
catch { }
string url = Request.QueryString["ID"];
Button1.PostBackUrl = "~/Personal/ConfirmPurchases?ID=" + url;
string apiLink = "http://www.omdbapi.com/?i=" + url + "&plot=full&r=xml";
if (url == null)
{
apiLink = "http://www.omdbapi.com/?i=tt0111161&plot=full&r=xml";
}
XmlReader reader = XmlReader.Create(apiLink);
XmlDocument doc = new XmlDocument();
doc.Load(reader);
reader.Close();
XmlDataSource1.Data = doc.OuterXml;
XmlDataSource1.DataBind();
XmlDataSource1.XPath = "/root/movie";
DetailsView1.DataBind();
XmlDocument xdoc1 = XmlDataSource1.GetXmlDocument();
XmlNode info = xdoc1.SelectSingleNode("/root/movie");
DetailsView1.DataBind();
String pattern = "_V1.*";
String replacement = "jpg";
Regex rgx;
rgx = new Regex(pattern);
String poster = rgx.Replace(info.Attributes["poster"].Value, replacement);
image.InnerHtml = "<img width=\"300px\" border=\"0\" alt=\"" + info.Attributes["title"].Value + "\" src=\"" + poster + "\">";
movieName.InnerHtml = "<i class=\"fa fa-video-camera\"></i> " + info.Attributes["title"].Value;
try
{
String sql = "SELECT id, email, commentDate, comment FROM dbo.Comments WHERE id = '" + Request.QueryString["ID"] + "'";
SqlConnection connection = new SqlConnection("Data Source=localhost\\SQLEXPRESS;Initial Catalog=MoviesBS;Integrated Security=True;Pooling=False");
SqlCommand command = new SqlCommand(sql, connection);
DataTable table = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(table);
connection.Open();
foreach (DataRow row in table.Rows)
{
sortable.InnerHtml += "<hr/>" +
"<strong class=\"pull-left primary-font\">" + row["email"].ToString().Substring(0, row["email"].ToString().IndexOf('@')) + "</strong>" +
"<small class=\"pull-right text-muted\">" +
"<span class=\"glyphicon glyphicon-time\"></span>" + " " + row["commentDate"].ToString() + "</small>" +
"</br>" +
"<li class=\"ui-state-default\">" + row["comment"].ToString() + "</li>";
}
connection.Close();
}
catch { }
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
DetailsView1.DataSource = admin.memDetaile(GridView1.SelectedValue.ToString());
DetailsView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
MultiView1.ActiveViewIndex = 1;
DetailsView1.DataBind();
}
protected void Button3_Command(object sender, CommandEventArgs e)
{
GridView1.DataBind();
MultiView1.ActiveViewIndex = 1;
DetailsView1.DataBind();
}
protected void DetailsView1_ItemUpdated(object sender, DetailsViewUpdatedEventArgs e)
{
DetailsView1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
con.Open();
SqlDataAdapter cmd5 = new SqlDataAdapter("select tsize,ttcost from tbltheatre where tname='" + Session["tname"].ToString() + "'", con);
DataSet ds1 = new DataSet();
cmd5.Fill(ds1);
tsize = Convert.ToInt16(ds1.Tables[0].Rows[0]["tsize"].ToString());
//tcost = Convert.ToInt16(ds1.Tables[0].Rows[0]["ttcost"].ToString());
s = tsize / 5;
int ss = 0;
string sno = "";
//int s = 100 / 5;
int b, c, d, f, z, y;
for (z = 1; z <= s; z++)
{
CheckBox lc = (CheckBox)PlaceHolder1.FindControl(z.ToString());
if (lc.Checked == true)
{
ss++;
if (ss <= 5)
{
sno = lc.Text + "," + sno;
}
}
if (ss > 5)
{
lc.Checked = false;
}
}
for (b = z; b <= s + s; b++)
{
CheckBox lc1 = (CheckBox)PlaceHolder2.FindControl(b.ToString());
if (lc1.Checked == true)
{
ss++;
if (ss <= 5)
{
sno = sno + "," + lc1.Text;
}
}
if (ss > 5)
{
lc1.Checked = false;
}
}
for (c = b; c <= s + s + s; c++)
{
CheckBox lc2 = (CheckBox)PlaceHolder3.FindControl(c.ToString());
if (lc2.Checked == true)
{
ss++;
if (ss <= 5)
{
sno = sno + "," + lc2.Text;
}
}
if (ss > 5)
{
lc2.Checked = false;
}
}
for (d = c; d <= s + s + s + s; d++)
{
CheckBox lc3 = (CheckBox)PlaceHolder4.FindControl(d.ToString());
if (lc3.Checked == true)
{
ss++;
if (ss <= 5)
{
sno = sno + "," + lc3.Text;
}
}
if (ss > 5)
{
lc3.Checked = false;
}
}
for (f = d; f <= s + s + s + s + s; f++)
{
CheckBox lc4 = (CheckBox)PlaceHolder5.FindControl(f.ToString());
if (lc4.Checked == true)
{
ss++;
if (ss <= 5)
{
sno = sno + "," + lc4.Text;
}
}
if (ss > 5)
{
lc4.Checked = false;
}
}
if (ss > 5 || ss == 0)
{
Response.Write("<script>alert('Select less than or Equal to 5 seats')</script>");
}
if (ss <= 5 && ss > 0)
{
tcst = ss * Convert.ToInt16(ds1.Tables[0].Rows[0]["ttcost"].ToString());
string id = Session["uname"].ToString() + DateTime.Now;
string bookid;
bookid = id.Replace(":", "a");
bookid = bookid.Replace("-", "b");
bookid = bookid.Replace(" ", "c");
SqlCommand cmd = new SqlCommand("insert into tblbooking values('" + Session["uname"].ToString() + "','" + Session["tname"].ToString() + "','" + Request.QueryString["mname"].ToString() + "','" + Session["bdate"].ToString() + "','" + Session["stime"].ToString() + "'," + ss + ",'" + sno + "'," + tcst + ",'" + bookid + "')", con);
if (cmd.ExecuteNonQuery() > 0)
{
//SqlDataAdapter da4 = new SqlDataAdapter("select * from tblbooking where bookid =(select max(bookid) from tblbooking)", con);
SqlDataAdapter da4 = new SqlDataAdapter("select * from tblbooking where bookid ='" + bookid + "'", con);
DataSet ds4 = new DataSet();
da4.Fill(ds4);
DetailsView1.DataSource = ds4;
DetailsView1.DataBind();
Response.Write("<script>alert('Booking Successfull ')</script>");
ImageButton1.Visible = true;
}
else
{
Response.Write("<script>alert('Error')</script>");
}
}
con.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
DetailsView1.DataSource = SqlDataSource1;
DetailsView1.DataBind();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
DetailsView1.Visible = true;
//DetailsView1.Style.Add("display", "block");
string envID = (GridView1.SelectedRow.FindControl("lblEnvID") as Label).Text;
string clientName = (GridView1.SelectedRow.FindControl("lblClientName") as Label).Text;
string productName = (GridView1.SelectedRow.FindControl("lblProductName") as Label).Text;
string AppServerEnvType = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerEnvType") as Label).Text;
string DBServerEnvType = (GridView1.SelectedRow.FindControl("lblEnvironmentDBServerEnvType") as Label).Text;
string AppServerName = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerName") as Label).Text;
string AppServerOS = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerOS") as Label).Text;
string AppServerOSBuild = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerOSBuild") as Label).Text;
string AppServerIsX86Version = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerIsX86Version") as Label).Text;
string AppServerIsVirtual = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerIsVirtual") as Label).Text;
string AppServerProcessor = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerProcessor") as Label).Text;
string AppServerMemory = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerMemory") as Label).Text;
string AppServerWebBrowser = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerWebBrowser") as Label).Text;
string AppServerWebBrowserVersion = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerWebBrowserVersion") as Label).Text;
string AppServerWorkingDirectoryLocation = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerWorkingDirectoryLocation") as Label).Text;
string AppHyperLink = (GridView1.SelectedRow.FindControl("lblEnvironmentAppHyperLink") as Label).Text;
string AppServerIP = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerIP") as Label).Text;
string AppServerPort = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerPort") as Label).Text;
string AppServerDependency = (GridView1.SelectedRow.FindControl("lblEnvironmentAppServerDependency") as Label).Text;
//-----------------------------------------------------------------------------------------------
string DBServerName = (GridView1.SelectedRow.FindControl("lblEnvironmentDBServerName") as Label).Text;
string DBServerIsX86Version = (GridView1.SelectedRow.FindControl("lblEnvironmentDBServerIsX86Version") as Label).Text;
string DBServerIsVirtual = (GridView1.SelectedRow.FindControl("lblEnvironmentDBServerIsVirtual") as Label).Text;
string DBServerMemory = (GridView1.SelectedRow.FindControl("lblEnvironmentDBServerMemory") as Label).Text;
string DBServerProcessor = (GridView1.SelectedRow.FindControl("lblEnvironmentDBServerProcessor") as Label).Text;
string DBServerOS = (GridView1.SelectedRow.FindControl("lblEnvironmentDBServerOS") as Label).Text;
string DBServerOSBuild = (GridView1.SelectedRow.FindControl("lblEnvironmentDBServerOSBuild") as Label).Text;
string DBServerDirectoryLocation = (GridView1.SelectedRow.FindControl("lblEnvironmentDBServerDirectoryLocation") as Label).Text;
string DBMDFFileLocation = (GridView1.SelectedRow.FindControl("lblEnvironmentDBMDFFileLocation") as Label).Text;
string DBMDFFileSize = (GridView1.SelectedRow.FindControl("lblEnvironmentDBMDFFileSize") as Label).Text;
string DBLDFFileLocation = (GridView1.SelectedRow.FindControl("lblEnvironmentDBLDFFileLocation") as Label).Text;
string DBLDFFileSize = (GridView1.SelectedRow.FindControl("lblEnvironmentDBLDFFileSize") as Label).Text;
string DBServerIP = (GridView1.SelectedRow.FindControl("lblEnvironmentEnvDBServerIP") as Label).Text;
string DBServerPort = (GridView1.SelectedRow.FindControl("lblEnvironmentDBServerPort") as Label).Text;
string DBServerDependency = (GridView1.SelectedRow.FindControl("lblEnvironmentDBServerDependency") as Label).Text;
Debug.WriteLine(GridView1.SelectedRow.Cells[0].Text);
Debug.WriteLine(GridView1.SelectedRow.Cells[1].Text);
Debug.WriteLine(GridView1.SelectedRow.Cells[2].Text);
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[34] {
new DataColumn("EnvironmentID", typeof(string)),
new DataColumn("ClientName", typeof(string)),
new DataColumn("ProductName", typeof(string)),
new DataColumn("AppServerEnvType", typeof(string)),
new DataColumn("DBServerEnvType", typeof(string)),
new DataColumn("AppServerName", typeof(string)),
new DataColumn("AppServerOS", typeof(string)),
new DataColumn("AppServerOSBuild", typeof(string)),
new DataColumn("AppServerIsX86Version", typeof(string)),
new DataColumn("AppServerIsVirtual", typeof(string)),
new DataColumn("AppServerProcessor", typeof(string)),
new DataColumn("AppServerMemory", typeof(string)),
new DataColumn("AppServerWebBrowser", typeof(string)),
new DataColumn("AppServerWebBrowserVersion", typeof(string)),
new DataColumn("AppServerWorkingDirectoryLocation", typeof(string)),
new DataColumn("AppHyperLink", typeof(string)),
new DataColumn("AppServerIP", typeof(string)),
new DataColumn("AppServerPort", typeof(string)),
new DataColumn("AppServerDependency", typeof(string)),
new DataColumn("DBServerName", typeof(string)),
new DataColumn("DBServerIsX86Version", typeof(string)),
new DataColumn("DBServerIsVirtual", typeof(string)),
new DataColumn("DBServerMemory", typeof(string)),
new DataColumn("DBServerProcessor", typeof(string)),
new DataColumn("DBServerOS", typeof(string)),
new DataColumn("DBServerOSBuild", typeof(string)),
new DataColumn("DBServerDirectoryLocation", typeof(string)),
new DataColumn("DBMDFFileLocation", typeof(string)),
new DataColumn("DBMDFFileSize", typeof(string)),
new DataColumn("DBLDFFileLocation", typeof(string)),
new DataColumn("DBLDFFileSize", typeof(string)),
new DataColumn("DBServerIP", typeof(string)),
new DataColumn("DBServerPort", typeof(string)),
new DataColumn("DBServerDependency", typeof(string))
});
dt.Rows.Add(envID, clientName, productName, AppServerEnvType, DBServerEnvType, AppServerName, AppServerOS, AppServerOSBuild, AppServerIsX86Version, AppServerIsVirtual, AppServerProcessor, AppServerMemory, AppServerWebBrowser, AppServerWebBrowserVersion, AppServerWorkingDirectoryLocation, AppHyperLink, AppServerIP, AppServerPort, AppServerDependency, DBServerName, DBServerIsX86Version, DBServerIsVirtual, DBServerMemory, DBServerProcessor, DBServerOS, DBServerOSBuild, DBServerDirectoryLocation, DBMDFFileLocation, DBMDFFileSize, DBLDFFileLocation, DBLDFFileSize, DBServerIP, DBServerPort, DBServerDependency);
//DetailsView1.m
DetailsView1.DataSource = dt;
DetailsView1.DataBind();
//.Attributes["accordionView"] = "hidden";
//DetailsView1.Attributes.Add("style", "display:block");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["idYonetici"] == null)
{
Response.Redirect("Giris.aspx");
}
if (!Page.IsPostBack)
{
_idTur = Request.QueryString["Type"];
_idAl = Request.QueryString["id"];
_idTum = Request.QueryString["tum"];
if (_idAl != null && _idTur != null)
{
switch (_idTur)
{
case "Siparis":
_dtMesajOku = _sysData._fncSelect("SELECT * FROM Siparis WHERE idSiparis=" + _idAl.ToString());
DetailsView1.DataSource = _dtMesajOku;
DetailsView1.DataBind();
break;
case "Kampanya":
_dtMesajOku = _sysData._fncSelect("SELECT * FROM KampanyaForm WHERE idKampanyaForm=" + _idAl.ToString());
DetailsView1.DataSource = _dtMesajOku;
DetailsView1.DataBind();
break;
case "Mesaj":
_dtMesajOku = _sysData._fncSelect("SELECT * FROM iletisim WHERE idiletisim=" + _idAl.ToString());
DetailsView1.DataSource = _dtMesajOku;
DetailsView1.DataBind();
break;
case "Odeme":
_dtMesajOku = _sysData._fncSelect("SELECT * FROM Odeme WHERE idOdeme=" + _idAl.ToString());
DetailsView1.DataSource = _dtMesajOku;
DetailsView1.DataBind();
break;
case "WebTasarim":
_dtMesajOku = _sysData._fncSelect("SELECT * FROM WebTasarimForm WHERE idWebTasarimForm=" + _idAl.ToString());
DetailsView1.DataSource = _dtMesajOku;
DetailsView1.DataBind();
break;
default:
break;
}
}
else
{
switch (_idTum)
{
case "Siparis":
_dtMesajOku = _sysData._fncSelect("SELECT * FROM Siparis");
GridView1.DataSource = _dtMesajOku;
GridView1.DataBind();
break;
case "Kampanya":
_dtMesajOku = _sysData._fncSelect("SELECT * FROM KampanyaForm");
GridView1.DataSource = _dtMesajOku;
GridView1.DataBind();
break;
case "Mesaj":
_dtMesajOku = _sysData._fncSelect("SELECT * FROM iletisim");
GridView1.DataSource = _dtMesajOku;
GridView1.DataBind();
break;
case "Odeme":
_dtMesajOku = _sysData._fncSelect("SELECT * FROM Odeme");
GridView1.DataSource = _dtMesajOku;
GridView1.DataBind();
break;
case "WebTasarim":
_dtMesajOku = _sysData._fncSelect("SELECT * FROM WebTasarimForm");
GridView1.DataSource = _dtMesajOku;
GridView1.DataBind();
break;
default:
break;
}
}
}
//if (!Page.IsPostBack)
//{
// _idAl= Request.QueryString["id"];
// _idTum = Request.QueryString["tum"];
// if (_idAl!=null)
// {
// try
// {
// _dtMesajOku = _sysData._fncSelect("SELECT * FROM iletisim WHERE idiletisim=" + _idAl + "");
// _lblAdSoyad.Text = _dtMesajOku.Rows[0]["Ad"].ToString() + " " + _dtMesajOku.Rows[0]["Soyad"].ToString();
// _lblEmail.Text = _dtMesajOku.Rows[0]["Email"].ToString();
// _lblTarih.Text = _dtMesajOku.Rows[0]["Tarih"].ToString();
// _lblKonu.Text = _dtMesajOku.Rows[0]["Konu"].ToString();
// _lblAciklama.Text = _dtMesajOku.Rows[0]["Aciklama"].ToString();
// }
// catch (Exception)
// {
// Response.Write("Page_Load");
// }
// }
// else if(_idTum =="tum")
// {
// _dtMesajOku = _sysData._fncSelect("SELECT * FROM iletisim");
// }
// else
// {
// _dtMesajOku = _sysData._fncSelect("SELECT * FROM iletisim");
// }
//}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("detail"))
{
string code2 = e.CommandArgument.ToString().Trim().ToLower();
DetailsView1.DataSource = KullaniciIslem.firmaKullanicilari(code2);
DetailsView1.DataBind();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append("$('#detailModal').modal('show');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "DetailModalScript2", sb.ToString(), false);
}
else if (e.CommandName.Equals("del"))
{
string confirmValue = Request.Form["confirm_value"];
List <string> liste = confirmValue.Split(new char[] { ',' }).ToList();
int sayimiz = liste.Count - 1;
string deger = liste[sayimiz];
if (deger == "Yes")
{
string code2 = e.CommandArgument.ToString().Trim().ToLower();
string userid = User.Identity.GetUserId();
if (code2 != userid)
{
KullaniciIslem.delKullanici(code2);
GridView1.DataSource = KullaniciIslem.KulaniciRoller();
GridView1.DataBind();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append(" alertify.success('Kayıt silindi!');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditHideModalScript3", sb.ToString(), false);
}
else
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append(" alertify.error('Kendi hesabınızı silemezssiniz');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditHideModalScript3", sb.ToString(), false);
}
}
}
else if (e.CommandName.Equals("editRecord"))
{
string[] arg = new string[2];
arg = e.CommandArgument.ToString().Split(';');
string id = Convert.ToString(arg[0]).Trim();
int index = Convert.ToInt32(arg[1]);
string rolid = Convert.ToString(arg[2]).Trim();
GridViewRow gvrow = GridView1.Rows[index];
drdRol.SelectedValue = rolid;
hdnID.Value = id.ToString();
//hdnRolID.Value = rolid.ToString();
txtEposta.Text = HttpUtility.HtmlDecode(gvrow.Cells[1].Text);
txtKullanici.Text = HttpUtility.HtmlDecode(gvrow.Cells[2].Text);
hdnRolID.Value = HttpUtility.HtmlDecode(gvrow.Cells[3].Text);
lblResult.Visible = false;
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append("$('#editModal').modal('show');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditModalScript", sb.ToString(), false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
// DetailsView1.DataSource = PerformanceAnalyzer2.BusinessLogicLayer.LecturerLogic.getLecturerData(Session["userID"]);
DetailsView1.DataBind();
}
protected void DetailsView1_ItemCommand(object sender, DetailsViewCommandEventArgs e)
{
DetailsView1.ChangeMode(DetailsViewMode.Edit);
DetailsView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//多个Part的调用方法
List <Part> parts = new List <Part>();
Part part = new Part();
//part.SoldToErpID = "EFESAI04";
part.OrgID = "EU10";
part.PartNumber = "PCI-1220U-AE";
//part.PlantID = "EUH1";
//part.Currency = "EUR";
parts.Add(part);
Part part2 = new Part();
// part2.Insert();
//part2.SoldToErpID = "EFESAI04";
part2.OrgID = "EU10";
part2.PartNumber = "ADAM-4502-AE";
part2.PlantID = "EUH1";
part2.Currency = "EUR";
parts.Add(part2);
Part part3 = new Part();
//part3.SoldToErpID = "EFESAI04";
part3.OrgID = "EU10";
part3.PartNumber = "IPC-100-60SE";
part3.PlantID = "EUH1";
// part3.ListPrice
part3.Currency = "EUR";
parts.Add(part3);
string errorMsg = "";
PartBusinessLogic.GetPrice(parts, ref errorMsg);
GridView1.DataSource = parts;
GridView1.DataBind();
//单一Part的调用方法
Part part1 = new Part("ADAM-4520-EE");
//part1.SoldToErpID = "ESTORE";
part1.OrgID = "CN01";
//part1.PartNo = "1654002538";
part1.PlantID = "CNH1";
//part1.Currency = "EUR";
PartBusinessLogic.GetPrice(part1, ref errorMsg);
List <Part> parts1 = new List <Part>();
parts1.Add(part1);
DetailsView1.DataSource = parts1;
DetailsView1.DataBind();
GridView2.DataSource = part1.Models;
GridView2.DataBind();
//part1.g
Model _model = new Model(part1.Models[0].Model_Name);
List <Feature> _defaultFeature = _model.Features;
GridView3.DataSource = _defaultFeature;
GridView3.DataBind();
List <Feature> aaa = _model.GetFeaturesByLanguage(LanguageCode.zh_cn);
GVFeature.DataSource = aaa;
GVFeature.DataBind();
List <Literature> _mainpic = _model.GetMainPictures();
List <Literature> _bigpic = _model.GetBigPictures();
List <Literature> _smallpic = _model.GetSmallPictures();
GVMainPIC.DataSource = _mainpic;
GVMainPIC.DataBind();
GVBigPIC.DataSource = _bigpic;
GVBigPIC.DataBind();
GVSmallPIC.DataSource = _smallpic;
GVSmallPIC.DataBind();
}
private void BindData()
{
jobseeker.JobID = Request["JobId"].ToString();
DetailsView1.DataSource = jobseeker.ShowJobInfoByJobId();
DetailsView1.DataBind();
}
protected void OnGridViewRowDeleted(object sender, GridViewDeletedEventArgs e)
{
DetailsView1.DataBind();
}
protected void ThemeButton1_Click(object sender, EventArgs e)
{
DetailsView1.DataBind();
}
protected void DetailsView_Update(object sender, GridViewUpdatedEventArgs e)
{
DetailsView1.DataBind();
}
protected void DetailsView1_ModeChanging(object sender, DetailsViewModeEventArgs e)
{
DetailsView1.DefaultMode = DetailsViewMode.Edit;
DetailsView1.DataBind();
}
private void comando()
{
DetailsView1.DataBind();
GridView1.DataBind();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("detail"))
{
int code = Convert.ToInt32(e.CommandArgument);
using (radiusEntities dc = MyContext.Context(firma))
{
MusteriIslemleri m = new MusteriIslemleri(dc);
DetailsView1.DataSource = m.musteriTekListeR(code);
DetailsView1.DataBind();
}
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append("$('#detailModal').modal('show');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "DetailModalScript", sb.ToString(), false);
}
else if (e.CommandName.Equals("smsEkle"))
{
string no = e.CommandArgument.ToString();
if (Session["teller2"] != null)
{
string teller = Session["teller2"].ToString();
if (!teller.Contains(no))
{
teller += no + ",";
Session["teller2"] = teller;
}
}
else
{
string teller = "";
teller += no + ",";
Session["teller2"] = teller;
}
using (radiusEntities dc = MyContext.Context(firma))
{
MusteriIslemleri m = new MusteriIslemleri(dc);
toplu(m);
}
}
else if (e.CommandName.Equals("editRecord"))
{
string[] arg = new string[2];
arg = e.CommandArgument.ToString().Split(';');
int id = Convert.ToInt32(arg[0]);
int index = Convert.ToInt32(arg[1]);
using (radiusEntities dc = MyContext.Context(firma))
{
MusteriIslemleri m = new MusteriIslemleri(dc);
customer must = m.musteriTekR(Convert.ToInt32(id));
lblID.Value = id.ToString();
txtDuzenAd.Text = must.Ad; //HttpUtility.HtmlDecode(link.Text);
txtDuzenAdres.Text = must.Adres; //HttpUtility.HtmlDecode(gvrow.Cells[5].Text);
txtDuzenTelefon.Text = must.telefon; //HttpUtility.HtmlDecode(gvrow.Cells[6].Text);
//string tcc = HttpUtility.HtmlDecode(gvrow.Cells[7].Text);
txtKimDuzen.Text = must.tanimlayici; //HttpUtility.HtmlDecode(gvrow.Cells[8].Text);
txtDuzenTc.Text = must.TC;
txtDuzenUnvan.Text = must.unvan;
if (must.musteri == true)
{
chcDuzenMust.Checked = true;
}
else
{
chcDuzenMust.Checked = false;
}
if (must.tedarikci == true)
{
chcDuzenTedarikci.Checked = true;
}
else
{
chcDuzenTedarikci.Checked = false;
}
if (must.disservis == true)
{
chcDuzenDisServis.Checked = true;
}
else
{
chcDuzenDisServis.Checked = false;
}
lblResult.Visible = false;
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append("$('#editModal').modal('show');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "EditModalScript", sb.ToString(), false);
}
}
}