protected void BtnInsert_Click(Object sender, System.EventArgs e)
{
ClPeyman cl = new ClPeyman();
cl = Data;
int t = 0;
if (CSharp.PublicFunction.ModeInsert(ParkID.ToString()))
{
t = PeymanClass.insert(cl);
}
else
{
t = PeymanClass.Update(cl);
}
if (t == 0)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.General_Success, "خطا در ثبت");
}
else
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.General_Success, "ثبت انجام شد.");
BindGrid();
}
LightBox.Value = "0";
LblParamPeymanID.Text = "0";
}
private void BindPeyman2()
{
ClPeyman cl = new ClPeyman();
DataSet ds = PeymanClass.GetList(cl);
ddPeyman.DataSource = ds;
ddPeyman.DataTextField = "PeymanName";
ddPeyman.DataValueField = "PeymanID";
ddPeyman.DataBind();
if (ddagree.SelectedValue != "0")
{
//ClPeymanPark cl2 = new ClPeymanPark();
//cl2.AgreementID = Convert.ToInt32(ddPeyman.SelectedValue);
//DataSet ds2 = PeymanParkClass.GetList(cl2);
//ddPeyman2.SelectedValue = ds2.Tables[0].Rows[0]["PeymanID"].ToString();
//ddPeyman2.Enabled = false;
ClAgreement cl2 = new ClAgreement();
cl2.AgreementID = Convert.ToInt32(ddagree.SelectedValue);
DataSet ds2 = AgreementClass.GetList(cl2);
if (ds2.Tables[0].Rows.Count > 0)
{
ddPeyman.SelectedValue = ds2.Tables[0].Rows[0]["PeymanID"].ToString();
}
ddPeyman.Enabled = false;
}
else
{
ddPeyman.Enabled = true;
}
}
private void BindPeyman(string i = "0")
{
ClPeyman cl = new ClPeyman();
if (Request.QueryString["aid"] != "")
{
ClAgreement CL2 = new ClAgreement();
CL2.AgreementID = Convert.ToInt32(Request.QueryString["aid"]);
DataSet DSSS = AgreementClass.GetList(CL2);
DDPeymanSelect.DataSource = PeymanClass.GetList(cl);
DDPeymanSelect.DataTextField = "PeymanName";
DDPeymanSelect.DataValueField = "PeymanID";
DDPeymanSelect.DataBind();
}
else
{
cl.PeymanID = 0;
DDPeymanSelect.DataSource = PeymanClass.GetList(cl);
DDPeymanSelect.DataTextField = "PeymanName";
DDPeymanSelect.DataValueField = "PeymanID";
DDPeymanSelect.DataBind();
}
DDPeymanSelect.Items.Insert(0, new ListItem("پیش فرض", "0"));
}
public void UpItem(object sender, EventArgs e)
{
String PeymanID = ((HtmlAnchor)sender).HRef.ToString();
LblParamPeymanID.Text = PeymanID;
ClPeyman cl = new ClPeyman();
cl.PeymanID = Convert.ToInt32(PeymanID);
Data = cl;
LightBox.Value = "1";
BtnInsert.Visible = true;
}
public void BindGrid()
{
ClPeyman cl = new ClPeyman();
DataSet ds = PeymanClass.GetList(cl);
DataView dv = new DataView(ds.Tables[0]);
if (ViewState["PeymanID"] == null)
{
ViewState["PeymanID"] = "PeymanID Desc";
}
dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["PeymanID"].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();
ClPeyman cl2 = new ClPeyman();
DDPeymanID.DataSource = PeymanClass.GetList(cl2);
DDPeymanID.DataTextField = "PeymanName";
DDPeymanID.DataValueField = "PeymanID";
DDPeymanID.DataBind();
}
public void BindDD()
{
DDMasterGreenSpaceID.DataSource = TaxiDAL.UsersClass.GetList(null, null, null, null, null, null, "4", null, null, null, null);
DDMasterGreenSpaceID.DataTextField = "FullNameUser";
DDMasterGreenSpaceID.DataValueField = "UserID";
DDMasterGreenSpaceID.DataBind();
DDMonitorinOfficeID.DataSource = TaxiDAL.CatalogClass.GetListTypeID("5");
DDMonitorinOfficeID.DataTextField = "CatalogName";
DDMonitorinOfficeID.DataValueField = "CatalogValue";
DDMonitorinOfficeID.DataBind();
ClPeyman clpeyman = new ClPeyman();
DDPeymanID.DataSource = PeymanClass.GetList(clpeyman);
DDPeymanID.DataTextField = "PeymanName";
DDPeymanID.DataValueField = "PeymanID";
DDPeymanID.DataBind();
DDPeymanKarID.DataSource = TaxiDAL.UsersClass.GetList(null, null, null, null, null, null, "1", null, null, null, null);
DDPeymanKarID.DataTextField = "FullNameUser";
DDPeymanKarID.DataValueField = "UserID";
DDPeymanKarID.DataBind();
DataSet ds = TaxiDAL.UsersClass.GetList(null, null, null, null, null, null, "2", null, null, null, null);
DDsupervisor2ID.DataSource = ds;
DDsupervisor2ID.DataValueField = "UserID";
DDsupervisor2ID.DataTextField = "FullNameUser";
DDsupervisor2ID.DataBind();
DataSet ds22 = TaxiDAL.UsersClass.GetList(null, null, null, null, null, null, null, null, null, null, null);
DDsupervisor3ID.DataSource = ds22;
DDsupervisor3ID.DataTextField = "FullNameUser";
DDsupervisor3ID.DataValueField = "UserID";
DDsupervisor3ID.DataBind();
//DataSet ds22 = TaxiDAL.UsersClass.GetList(null, null, null, null, null, null, "6", null, null, null, null);
DDsupervisorStaticID.DataSource = ds22;
DDsupervisorStaticID.DataTextField = "FullNameUser";
DDsupervisorStaticID.DataValueField = "UserID";
DDsupervisorStaticID.DataBind();
checkTamdid();
}
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(ClPeyman c)
{
SqlCommand cmd = new SqlCommand("PRC_Peyman_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("PeymanID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PeymanID == 0 ? null :c.PeymanID);
cmd.Parameters.Add(new SqlParameter("PeymanName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.PeymanName);
cmd.Parameters.Add(new SqlParameter("PeymanNumber", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.PeymanNumber);
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 static int insert(ClPeyman c)
{
SqlCommand cmd = new SqlCommand("PRC_Peyman_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("PeymanName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.PeymanName);
cmd.Parameters.Add(new SqlParameter("PeymanNumber", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.PeymanNumber);
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();
}
}
