protected void btnInsert_Click(object sender, EventArgs e)
{
ClCuttingTree cl = new ClCuttingTree();
cl.Address = txtAddress.Text;
cl.Bon = Convert.ToInt32(txtBon.Text);
cl.Count = Convert.ToInt32(txtCount.Text);
cl.date = CtlDatePick.Text;
cl.dddeeesssccc = txtcomment.Text;
cl.Desc = txtcomment.Text;
cl.GeoTree = latlong.Value;
cl.HaghighiId = Convert.ToInt32(txtHaghighiId.Value);
cl.id = Convert.ToInt32(txtid.Value);
cl.LicesnceTypeid = 0;
cl.MantagheId = Convert.ToInt32(ddRegion.SelectedValue);
cl.StreetTypeid = Convert.ToInt32(ddlStreetType.SelectedValue);
cl.TreeTypeId = Convert.ToInt32(ddlTreeType.SelectedValue);
int i = 0;
if (cl.id == 0)
{
i = CuttingTreeSpace.CuttingTreeClass2.insert(cl);
}
else
{
i = CuttingTreeSpace.CuttingTreeClass2.Update(cl);
}
if (i == 0)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "خطا در ثبت");
}
}
//---------------------------------------------------------------------------------------------------------
public static DataSet GetList(ClCuttingTree c)
{
SqlCommand cmd = new SqlCommand("PRC_CuttingTree_GetListMap", cnn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = 1;// CSharp.PublicFunction.GetUserID();
cmd.Parameters.Add(new SqlParameter("IpLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetIPAddress();
cmd.Parameters.Add(new SqlParameter("OSLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetOS();
cmd.Parameters.Add(new SqlParameter("OSVerLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetBrowser() + CSharp.PublicFunction.GetBrowserVersion();
cmd.Parameters.Add(new SqlParameter("URLLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetURL();
cmd.Parameters.Add(new SqlParameter("id", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.id);
cmd.Parameters.Add(new SqlParameter("TreeTypeId", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.TreeTypeId);
cmd.Parameters.Add(new SqlParameter("Count", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.Count);
cmd.Parameters.Add(new SqlParameter("Bon", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.Bon);
cmd.Parameters.Add(new SqlParameter("date", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.date);
cmd.Parameters.Add(new SqlParameter("Address", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.Address);
cmd.Parameters.Add(new SqlParameter("x", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.x);
cmd.Parameters.Add(new SqlParameter("y", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.y);
cmd.Parameters.Add(new SqlParameter("image", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.image);
cmd.Parameters.Add(new SqlParameter("StreetTypeid", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.StreetTypeid);
cmd.Parameters.Add(new SqlParameter("PersonalId", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PersonalId);
cmd.Parameters.Add(new SqlParameter("Peyman", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.Peyman);
cmd.Parameters.Add(new SqlParameter("Peymanid", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.Peymanid);
cmd.Parameters.Add(new SqlParameter("MantagheId", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.MantagheId);
cmd.Parameters.Add(new SqlParameter("Mojavez", SqlDbType.Bit)).Value = Securenamespace.SecureData.CheckSecurity(c.Mojavez);
cmd.Parameters.Add(new SqlParameter("HaghighiId", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.HaghighiId);
cmd.Parameters.Add(new SqlParameter("LicesnceTypeid", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.LicesnceTypeid);
cmd.Parameters.Add(new SqlParameter("Title", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.Title);
cmd.Parameters.Add(new SqlParameter("dddeeesssccc", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.dddeeesssccc);
cmd.Parameters.Add(new SqlParameter("recRoleID", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.recRoleID);
cmd.Parameters.Add(new SqlParameter("status", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.status);
cmd.Parameters.Add(new SqlParameter("GeoTree", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.GeoTree);
cmd.Parameters.Add(new SqlParameter("Desc", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.Desc);
cmd.Parameters.Add(new SqlParameter("PointGeo", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.PointGeo);
SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int);
prmResult.Direction = ParameterDirection.Output;
cmd.Parameters.Add(prmResult);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
cnn.Open();
da.Fill(ds);
return(ds);
}
catch (Exception ex)
{
return(null);
}
finally
{
cnn.Close();
}
}
public string GetMapReport(ClCuttingTree oobbjj)
{
//string text = File.ReadAllText(@"D:\B\file.txt", Encoding.UTF8);
//return text;
ClCuttingTree cl2 = new ClCuttingTree();
if (oobbjj.PersonalId != 0)
{
cl2.PersonalId = oobbjj.PersonalId; // Convert.ToInt32(Session["PersonalID"].ToString()==null ? "1":"0");
}
if (oobbjj.id != 0)
{
cl2.id = oobbjj.id;
}
// cl2.PersonalId = 1;// Convert.ToInt32(objj.PersonalId);
DataSet ds = CuttingTreeSpace.CuttingTreeClass2.GetList(cl2);
List <ClCuttingTree> messages = new List <GreenSpaceCL.ClCuttingTree>();
DataRow dr;
if (ds == null)
{
return("");
}
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ClCuttingTree cl = new ClCuttingTree();
cl.PersonalId = 1;
dr = ds.Tables[0].Rows[i];
cl.Bon = Convert.ToInt32(dr["Bon"].ToString() == "" ?"0":dr["Bon"].ToString());
cl.Address = dr["Address"].ToString();
cl.Count = Convert.ToInt32(dr["Count"].ToString() == "" ? "0" : dr["Count"].ToString());
cl.dddeeesssccc = dr["Desc"].ToString();
cl.Desc = dr["Desc"].ToString();
cl.GeoTree = dr["GeoTree"].ToString();
cl.LicesnceTypeid = Convert.ToInt32(dr["LicesnceTypeid"].ToString() == "" ? "0" : dr["LicesnceTypeid"].ToString());
cl.MantagheId = Convert.ToInt32(dr["MantagheId"].ToString() == "" ? "0" : dr["MantagheId"].ToString());
cl.Mojavez = Convert.ToInt32(dr["Mojavez"].ToString() == "True" ? "1" :"0");
cl.StreetTypeid = Convert.ToInt32(dr["StreetTypeid"].ToString() == "" ? "0" : dr["StreetTypeid"].ToString());
cl.Title = dr["Title"].ToString();
cl.TreeTypeId = Convert.ToInt32(dr["TreeTypeId"].ToString() == "" ? "0" : dr["TreeTypeId"].ToString());
cl.PointGeo = dr["PointGeo"].ToString();
cl.P = dr["P"].ToString();
cl.lat = dr["lat"].ToString();
cl.longg = dr["Long"].ToString();
cl.id = Convert.ToInt32(dr["id"].ToString());
messages.Add(cl);
}
}
string ff = GetPointGeoJasonBySubGroupColor(messages);
return(ff);
}
public string savepoint(ClCuttingTree objectt)
{
ClCuttingTree cl = new ClCuttingTree();
cl = objectt;
int i = 0;
///cl.PersonalId = 1;
if (objectt.id == 0 || objectt.id == null)
{
i = CuttingTreeSpace.CuttingTreeClass2.insert(cl);
}
else
{
i = CuttingTreeSpace.CuttingTreeClass2.Update(cl);
}
return(i.ToString());
//objectt.Bon = 0;
//objectt.Count = 1;
//string constr = ConfigurationManager.ConnectionStrings["GreenCnn"].ConnectionString;
//using (SqlConnection con = new SqlConnection(constr))
//{
// //using (SqlCommand cmd = new SqlCommand("INSERT INTO Tbl_CuttingTree(bon,Count,PointGeo) VALUES(@Bon, @Count,@PointGeo)"))
// using (SqlCommand cmd = new SqlCommand("PRC_CuttingTree_Insert"))
// {
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@Bon", objectt.Bon);
// cmd.Parameters.AddWithValue("@Count", objectt.Count);
// cmd.Parameters.AddWithValue("@PointGeo", objectt.PointGeo);
// cmd.Connection = con;
// con.Open();
// cmd.ExecuteNonQuery();
// con.Close();
// }
//}
}
public string GetPointGeoJasonBySubGroupColor(List <ClCuttingTree> messages)
{
ClCuttingTree msg = new ClCuttingTree();
//List<ClTreeBonCuttingDB> groups = msg.PersonalID;
string jason = "{" +
"\"type\": \"FeatureCollection\"," +
"\"crs\": { \"type\": \"name\", \"properties\": { \"name\": \"urn:ogc:def:crs:EPSG::32639\" } }," +
"\"features\": [";
string p = "";
foreach (ClCuttingTree db in messages)
{
if (!string.IsNullOrEmpty(db.PointGeo))
{
p = "[" + db.lat + "," + db.longg + "]";
// p = db.SHAPE.ToString().Remove(0, 6).Replace('(', '[').Replace(' ', ',').Replace(')', ']');
// messages cc = messages.Find(t => t.SubgroupId == db.SubGroupId);
string color = "#000000";
//if (db != null)
// color = db.Icon;
jason +=
"{ \"type\": \"Feature\", \"properties\": { \"id\": \" " + db.id + "\" ," +
"\"comment\": \" " + db.Desc + "\" ," +
"\"Address\": \" " + db.Address + "\" ," +
"\"DatePick\": \" " + db.date + "\" ," +
"\"Bon\": \" " + db.Bon + "\" ," +
"\"Count\": \" " + db.Count + "\" ," +
"\"Region\": \" " + db.MantagheId + "\" ," +
"\"LicesnceType\": \" " + db.LicesnceTypeid + "\" ," +
"\"StreetType\": \" " + db.StreetTypeid + "\" ," +
" \"Color\":\"" + color + "\" }, \"geometry\": { \"type\": \"Point\", \"coordinates\": " + p + " } },";
}
}
jason = jason.Remove(jason.Length - 1, 1);
jason += "]}";
return(jason);
}
public string deleteTree(ClCuttingTree oobbjj)
{
string ff = CuttingTreeClass.Delete(Convert.ToInt32(oobbjj.PersonalId)).ToString();
return(ff);
}
