protected void BtnInsert_Click(Object sender, System.EventArgs e)
{
ClPark cl = new ClPark();
cl = Data;
int t = 0;
if (CSharp.PublicFunction.ModeInsert(ParkID.ToString()))
{
t = ParkClass.insert(cl);
}
else
{
t = ParkClass.Update(cl);
}
if (t == 0)
{
LblMsg.ForeColor = System.Drawing.Color.Red;
LblMsg.Text = "خطا در ثبت";
}
else
{
LblMsg.ForeColor = System.Drawing.Color.Green;
LblMsg.Text = "ثبت انجام شد.";
BindGrid();
}
LightBox.Value = "0";
LblParamParkID.Text = "0";
}
private string getAreaPark(int parkid)
{
ClPark cl = new ClPark();
cl.ParkID = parkid;
DataSet ds = ParkClass.GetList(cl);
return(ds.Tables[0].Rows[0]["ParkArea"].ToString());
}
public void UpItem(object sender, EventArgs e)
{
String ParkID = ((HtmlAnchor)sender).HRef.ToString();
LblParamParkID.Text = ParkID;
ClPark cl = new ClPark();
cl.ParkID = Convert.ToInt32(ParkID);
Data = cl;
LightBox.Value = "1";
}
public void BindDD()
{
ClPark cl = new ClPark();
DDParkID.DataSource = ParkClass.GetList(cl);
DDParkID.DataTextField = "ParkName";
DDParkID.DataValueField = "ParkID";
DDParkID.DataBind();
ClPeyman cl2 = new ClPeyman();
DDPeymanID.DataSource = PeymanClass.GetList(cl2);
DDPeymanID.DataTextField = "PeymanName";
DDPeymanID.DataValueField = "PeymanID";
DDPeymanID.DataBind();
}
public void BindGrid()
{
ClPark cl = new ClPark();
cl.ParkDistrict = Convert.ToInt32(dddistincttt.SelectedValue);
DataSet ds = ParkClass.GetList(cl);
DataView dv = new DataView(ds.Tables[0]);
if (ViewState["ParkID"] == null)
{
ViewState["ParkID"] = "ParkID Desc";
}
dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["ParkID"].ToString()).ToString();
GridView1.DataSource = dv;
GridView1.DataBind();
}
public void BindDD()
{
ClPark cl = new ClPark();
//DDParkID.DataSource = ParkClass.GetList(cl);
//DDParkID.DataTextField = "ParkName";
//DDParkID.DataValueField = "ParkID";
//DDParkID.DataBind();
DDParkID.BindDD();
DDParkID.SelectedRegion = Convert.ToInt32(lblParkDistrict.Text);
ClPeyman cl2 = new ClPeyman();
DDPeymanID.DataSource = PeymanClass.GetList(cl2);
DDPeymanID.DataTextField = "PeymanName";
DDPeymanID.DataValueField = "PeymanID";
DDPeymanID.DataBind();
}
//---------------------------------------------------------------------------------------------------------
public static DataSet GetList(ClPark c)
{
SqlCommand cmd = new SqlCommand("PRC_Park_GetList", cnn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = 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("ParkID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ParkID == 0? null:c.ParkID);
cmd.Parameters.Add(new SqlParameter("ParkName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ParkName);
cmd.Parameters.Add(new SqlParameter("ParkAdress", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ParkAdress);
cmd.Parameters.Add(new SqlParameter("ParkArea", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ParkArea);
cmd.Parameters.Add(new SqlParameter("ParkDistrict", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ParkDistrict);
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();
}
}
private void BindPArk()
{
ClPark cl = new ClPark();
cl.ParkDistrict = Convert.ToInt32(ddRegion.SelectedValue);
ddPArk.DataSource = ParkClass.GetList(cl);
ddPArk.DataTextField = "ParkName";
ddPArk.DataValueField = "ParkID";
ddPArk.DataBind();
if (lblAllPark.Text == "1" && ddPArk.Items.Count > 0 && ddPArk.Items.FindByValue("-100") == null)
{
ddPArk.Items.Insert(0, new ListItem("انتخاب همه", "-100"));
}
if (pe != null)
{
pe();
}
}
public static int insert(ClPark c)
{
SqlCommand cmd = new SqlCommand("PRC_Park_Insert", cnn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = 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("ParkName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ParkName);
cmd.Parameters.Add(new SqlParameter("ParkAdress", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ParkAdress);
cmd.Parameters.Add(new SqlParameter("ParkArea", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ParkArea);
cmd.Parameters.Add(new SqlParameter("ParkDistrict", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ParkDistrict);
SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int);
prmResult.Direction = ParameterDirection.Output;
cmd.Parameters.Add(prmResult);
try
{
cnn.Open();
cmd.ExecuteNonQuery();
return(Convert.ToInt32(prmResult.Value));
}
catch (Exception ex)
{
return(0);
}
finally
{
cnn.Close();
}
}
