private void comando()
{
DetailsView1.DataBind();
GridView1.DataBind();
}
protected void OnFilterSelectedIndexChanged(object sender, EventArgs e)
{
GridView1.EditIndex = -1;
GridView1.PageIndex = 0;
DetailsView1.ChangeMode(DetailsViewMode.ReadOnly);
}
protected void OnGridViewSelectedIndexChanging(object sender, EventArgs e)
{
GridView1.EditIndex = -1;
DetailsView1.ChangeMode(DetailsViewMode.ReadOnly);
}
protected void Page_Init(object sender, EventArgs e)
{
table = DynamicDataRouteHandler.GetRequestMetaTable(Context);
DetailsView1.SetMetaTable(table, table.GetColumnValuesFromRoute(Context));
DetailsDataSource.EntityTypeFilter = table.EntityType.Name;
}
protected void txtIdRepuesto_Load(object sender, EventArgs e)
{
TextBox txtIdRepuesto = (TextBox)DetailsView1.FindControl("txtIdRepuesto");
txtIdRepuesto.Text = r.countIdRepuesto();
}
protected void NewLinkBtn_Click(object sender, EventArgs e)
{
DetailsView1.ChangeMode(DetailsViewMode.Insert);
MultiView1.ActiveViewIndex = 1;
}
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_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);
}
}
}
private void BindData()
{
recruiter.OrganisationName = Request["OrgName"].ToString();
DetailsView1.DataSource = recruiter.ShowOrganizationDetailByOrg();
DetailsView1.DataBind();
}
public void bind()
{
DetailsView1.DataSource = bs.bs_bind();
DetailsView1.DataBind();
}
protected void btnAddNewAdhaarAndContactNumber_Click(object sender, EventArgs e)
{
DetailsView1.ChangeMode(DetailsViewMode.Insert);
}
protected void Button1_Click(object sender, EventArgs e)
{
DetailsView1.ChangeMode(DetailsViewMode.Insert);
}
public void Load_DetailsView1()
{
DetailsView1.DataSource = AdminLogic.getbasicCourseInfoNew(Session["courseID"].ToString());
DetailsView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
Cache.Remove(ObjectDataSource2.CacheKeyDependency);
Cache[ObjectDataSource2.CacheKeyDependency] = "CacheExample";
DetailsView1.DataBind();
}
protected void BtnCancel_Click(object sender, EventArgs e)
{
DetailsView1.ChangeMode(DetailsViewMode.ReadOnly);
MultiView1.ActiveViewIndex = 0;
}
protected void DetailsView1_ModeChanging(object sender, DetailsViewModeEventArgs e)
{
DetailsView1.ChangeMode(e.NewMode);
this.BindDetail();
}
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e)
{
//ReuseTech obj = GetReuseTech(int.Parse(((HiddenField)DetailsView1.FindControl("Id")).Value));
String sqlReuseTechDel = " delete from ReuseTech where Id =@id ";
OleDbCommand cmdReuseTechDel = new OleDbCommand(sqlReuseTechDel);
cmdReuseTechDel.Parameters.Add("@id", OleDbType.Integer).Value = (int.Parse(((HiddenField)DetailsView1.FindControl("Id")).Value));
SQLUtil.ExecuteSql(cmdReuseTechDel);
//ReuseTech obj = mgr.getReuseTech(int.Parse(((HiddenField)DetailsView1.FindControl("Id")).Value));
//at = SpringUtil.at();
String sql = "SELECT * FROM MatchList WHERE Rid1=@param1 ";
//IDbParameters parameters = at.CreateDbParameters();
//parameters.Add("param1", OleDbType.Integer).Value = obj.Id;
//DataSet ds = new DataSet();
//at.DataSetFillWithParameters(ds, CommandType.Text, sql, parameters);
OleDbCommand cmd = new OleDbCommand(sql);
cmd.Parameters.Add("@param1", OleDbType.Integer).Value = (int.Parse(((HiddenField)DetailsView1.FindControl("Id")).Value));
cmd.CommandType = CommandType.Text;
DataSet ds = SQLUtil.QueryDS(cmd);
ArrayList matchList = null;
if (ds.Tables[0].Rows.Count > 0)
{
matchList = new ArrayList();
foreach (DataRow dRow in ds.Tables[0].Rows)
{
String sqlMatchUp = " Update MatchList ";
sqlMatchUp = sqlMatchUp + " Set Isdeleted=@Isdeleted,";
sqlMatchUp = sqlMatchUp + " Isdeleted1=@Isdeleted1, ";
sqlMatchUp = sqlMatchUp + " Deletedate1=@Deletedate1 ";
sqlMatchUp = sqlMatchUp + " where id=@id ";
OleDbCommand cmdMatchDel = new OleDbCommand(sqlMatchUp);
cmdMatchDel.Parameters.Add("@Deletedate1", OleDbType.Date).Value = DateTime.Now;
cmdMatchDel.Parameters.Add("@Isdeleted", OleDbType.Boolean).Value = true;
cmdMatchDel.Parameters.Add("@Isdeleted1", OleDbType.Boolean).Value = true;
cmdMatchDel.Parameters.Add("@id", OleDbType.Integer).Value = (int)dRow["Id"];
SQLUtil.ExecuteSql(cmdMatchDel);
//Match match = mgrMatch.getMatch((int)dRow["Id"]);
//match.Isdeleted = true;
//match.Isdeleted1 = true;
//match.Deletedate1 = DateTime.Now;
//matchList.Add(match);
}
}
//mgr.Delete(obj, null, matchList);
BindGrid();
MultiView1.ActiveViewIndex = 0;
}
protected void btnFileUploa_Click(object sender, EventArgs e)
{
DropDownList dr = new DropDownList();
strque = dr.SelectedIndex;
//string strque = Request.QueryString["ca_id"];
//ddlist.DataSource;
#region 照片即获取照片名 fileName
Boolean fileOK = false;
FileUpload FileUpload1 = new FileUpload();
FileUpload1 = (FileUpload)DetailsView1.FindControl("FileUpload1");
//获取上传的文件名
string fileName = ((FileUpload)DetailsView1.FindControl("FileUpload1")).FileName;
//获取物理路径
String path = Server.MapPath("~/Images/");
//获取后缀名
String fileExtension = string.Empty;
//判断上传控件是否上传文件
if (FileUpload1.HasFile)
{
//判断上传文件的扩展名是否为允许的扩展名".gif", ".png", ".jpeg", ".jpg" ,".bmp"
fileExtension = System.IO.Path.GetExtension(fileName).ToLower();
String[] Extensions = { ".gif", ".png", ".jpeg", ".jpg", ".bmp" };
for (int i = 0; i < Extensions.Length; i++)
{
if (fileExtension == Extensions[i])
{
fileOK = true;
}
}
}
//如果上传文件扩展名为允许的扩展名，则将文件保存在服务器上指定的目录中
if (fileOK)
{
try
{
fileName = DateTime.Now.Ticks.ToString() + fileExtension;
FileUpload1.PostedFile.SaveAs(path + fileName);
MessageBox("文件上传完毕");
}
catch (Exception ex)
{
MessageBox("文件不能上传，原因：" + ex.Message);
}
}
else
{
MessageBox("不能上传这种类型的文件");
}
#endregion
#region 获取产品名，转卖价，原价，详细说明
TextBox productname = new TextBox(), Transferprice = new TextBox(), productprice = new TextBox(), description = new TextBox();
productname = (TextBox)(DetailsView1.FindControl("productname")); /*产品名*/
Transferprice = (TextBox)(DetailsView1.FindControl("Transferprice")); /*转卖价*/
productprice = (TextBox)(DetailsView1.FindControl("productprice")); /*原价*/
description = (TextBox)(DetailsView1.FindControl("description")); /*详细说明*/
#endregion
#region 储存在数据库中 insert
AccessDataSource ads = new AccessDataSource();
ads.DataFile = "~/App_data/mystore.mdb";
/*插入商家上传的信息*/
try
{
ads.InsertCommand = "insert into [Product] (ca_id,productname,productprice,Transferprice,productimages,description) values(2,@productname,@productprice,@Transferprice,@fileName,@description)";
ads.InsertParameters.Add("@productname", productname.Text.Trim());
ads.InsertParameters.Add("@productprice", productprice.Text.Trim());
ads.InsertParameters.Add("@Transferprice", Transferprice.Text.Trim());
ads.InsertParameters.Add("@fileName", fileName);
ads.InsertParameters.Add("@description", description.Text.Trim());
ads.Insert();
ads.Dispose();
}
catch (Exception ee)
{
Response.Write(ee.Message + "");
}
#endregion
}
protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
e.Values["cityId"] = ((DropDownList)DetailsView1.FindControl("ddlCity")).SelectedValue;
}
protected void btnAddDepartment_Click(object sender, EventArgs e)
{
DetailsView1.ChangeMode(DetailsViewMode.Insert);
}
protected void btnAddComplaintStatus_Click(object sender, EventArgs e)
{
DetailsView1.ChangeMode(DetailsViewMode.Insert);
}
protected void Button3_Command(object sender, CommandEventArgs e)
{
GridView1.DataBind();
MultiView1.ActiveViewIndex = 1;
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 Button1_Click(object sender, EventArgs e)
{
MultiView1.ActiveViewIndex = 1;
DetailsView1.DataBind();
}
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.DataSource = admin.memDetaile(GridView1.SelectedValue.ToString());
DetailsView1.DataBind();
}
protected void OnGridViewRowEditing(object sender, EventArgs e)
{
DetailsView1.ChangeMode(DetailsViewMode.ReadOnly);
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
DetailsView1.PageIndex = GridView1.SelectedIndex;
DetailsView1.DataBind();
}
protected void OnGridViewRowDeleted(object sender, GridViewDeletedEventArgs e)
{
DetailsView1.DataBind();
}
protected void DetailsView1_ItemUpdated(object sender, DetailsViewUpdatedEventArgs e)
{
DetailsView1.DataBind();
}
