private void BindddNazar()
{
DataSet ds = CatalogClass.GetListTypeID("11");
ddnazar.DataSource = ds;
ddnazar.DataTextField = "CatalogName";
ddnazar.DataValueField = "CatalogValue";
ddnazar.DataBind();
ddRequestStatus.DataSource = ds;
ddRequestStatus.DataTextField = "CatalogName";
ddRequestStatus.DataValueField = "CatalogValue";
ddRequestStatus.DataBind();
ddRequestStatus.Items.Insert(0, new ListItem("همه موارد", "-1"));
ddRequestStatus.Items.Insert(1, new ListItem("پرداخت شده", "-2"));
ClCompany cl = new ClCompany();
ddcompany.DataSource = CompanyClass.GetList(cl);
ddcompany.DataTextField = "CompanyName";
ddcompany.DataValueField = "CompanyID";
ddcompany.DataBind();
ddcompany.Items.Insert(0, new ListItem("بدون انتخاب", "0"));
ds.Dispose();
}
public int CompnaytypeID()
{
string ctype = "0";
ClCompany cl = new ClCompany();
cl.PersonalID = PersonID;
DataSet ds = CompanyClass.GetListPersonl(cl);
if (ds.Tables[0].Rows.Count > 0)
{
ctype = ds.Tables[0].Rows[0]["CompanyTypeID"].ToString();
if (ctype == "2")
{
sa1.Visible = true;
sa2.Visible = true;
}
else
{
sa1.Visible = false;
sa2.Visible = false;
}
}
else
{
sa1.Visible = false;
sa2.Visible = false;
ctype = "-1";
}
return(Convert.ToInt32(ctype));
}
protected void BtnInsert_Click(object sender, EventArgs e)
{
ClCompany cl = new ClCompany();
cl = Data;
int i = 0;
if (LblParamCompanyID.Text == "0")
{
i = CompanyClass.insert(cl);
}
else
{
i = CompanyClass.Update(cl);
}
if (i.ToString() == "0")
{
Utility.ShowMsg(Page, ProPertyData.MsgType.General_Fault, "ثبت با خطا مواجه شد");
}
else
{
// Utility.ShowMsg(Page, ProPertyData.MsgType.General_Success, "ثبت با موفقیت انجام شد.");
//Session["CompanyID"] = LblParamCompanyID.Text;
BindGrid();
LightBox.Value = "0";
}
LblParamCompanyID.Text = "0";
}
protected void Page_Load(object sender, EventArgs e)
{
var liActive = (HtmlGenericControl)Master.FindControl("step1");
liActive.Attributes.Add("class", "active");
var master = this.Master;
if (!Page.IsPostBack)
{
if (Request.QueryString["msg"] != "" && Request.QueryString["msg"] != null)
{
TerraficPlanBLL.Utility.ShowMsg(Page, TerraficPlanBLL.ProPertyData.MsgType.warning, Request.QueryString["msg"]);
// Request.QueryString["msg"] = "";
}
CtlPerson1.RedirectPage = "";
CtlPerson1.UpdateMode = true;
ClPersonal cl = new ClPersonal();
cl.PersonalID = Convert.ToInt32(Session["PersonalID"].ToString());
CtlPerson1.PersonalID = Convert.ToInt32(Session["PersonalID"].ToString());
CtlPerson1.Data = cl;
ClCompany clCompany = new ClCompany();
clCompany.PersonalID = Convert.ToInt32(Session["PersonalID"].ToString());
CtlCompanyOnly1.Data = clCompany;
Session["CompanyID"] = CtlCompanyOnly1.CompanyID.ToString();
}
}
protected void ACompany_ServerClick(object sender, EventArgs e)
{
ClCompany clCompany = new ClCompany();
clCompany.PersonalID = Convert.ToInt32(((HtmlAnchor)sender).HRef.ToString());
ctlCompany.Data = clCompany;
LightBoxCompany.Value = "1";
}
public void BindDD()
{
ClCompany cl = new ClCompany();
DataSet ds = CompanyClass.GetList(new ClCompany());
ddCompany.DataSource = ds;
ddCompany.DataTextField = "CompanyName";
ddCompany.DataValueField = "CompanyID";
ddCompany.DataBind();
}
public void UpItem(object sender, EventArgs e)
{
String ID = ((HtmlAnchor)sender).HRef.ToString();
ClCompany cl = new ClCompany();
cl.CompanyID = Convert.ToInt32(ID);
Data = cl;
LightBox.Value = "1";
BtnInsert.Visible = true;
BtnSerach.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CtlCompanyOnly1.PErsonalID = Convert.ToInt32(Session["PersonalID"].ToString());
ClCompany cl = new ClCompany();
cl.PersonalID = Convert.ToInt32(Session["PersonalID"].ToString());
CtlCompanyOnly1.BindDD();
CtlCompanyOnly1.Data = cl;
CtlCompanyOnly1.VisibleBtn = false;
}
}
public void BindDD()
{
ClCompany cl = new ClCompany();
DDCompanyID.DataSource = CompanyClass.GetList(cl);
DDCompanyID.DataTextField = "CompanyName";
DDCompanyID.DataValueField = "CompanyID";
DDCompanyID.DataBind();
DDCompanyID.Items.Insert(0, new ListItem("", "0"));
//DDDiscountTypeID.DataSource = CatalogClass.GetListDiscountType();
//DDDiscountTypeID.DataTextField = "CatalogName";
//DDDiscountTypeID.DataValueField = "caid";
//DDDiscountTypeID.DataBind();
}
private void BindGrid()
{
ClCompany cl = new ClCompany();
cl.YearIDfilter = Convert.ToInt32(ddDefauleYear.SelectedValue);
DataSet ds = CompanyClass.GetListCompanyRequest(cl);
DataView dv = new DataView(ds.Tables[0]);
if (ViewState["PersonalID"] == null)
{
ViewState["PersonalID"] = "PersonalID Desc";
}
dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["PersonalID"].ToString()).ToString();
grid1.DataSource = dv;
grid1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Request.QueryString["cname"] == null)
{
ClCompany cl = new ClCompany();
cl.companyID = Convert.ToInt32(Request.QueryString["cid"]);
DataSet ds = CompanyClass.GetList(cl);
DataRow dr = ds.Tables[0].Rows[0];
lblCompanyName.Text = dr[""].ToString();
}
lblCompanyName.Text = Request.QueryString["cname"].ToString();
}
catch { }
}
private string GetCompanyID(int PersonalId)
{
ClCompany clCompany = new ClCompany();
clCompany.PersonalID = PersonalId;
DataSet ds = CompanyClass.GetListPersonl(clCompany);
DataRow dr;
if (ds.Tables[0].Rows.Count > 0)
{
dr = ds.Tables[0].Rows[0];
lblCompanyID.Text = dr["CompanyID"].ToString();
}
ds.Dispose();
return(lblCompanyID.Text);
}
public void BindGrid()
{
ClCompany cl = new ClCompany();
cl = Data;
DataSet ds = CompanyClass.GetList(cl);
DataView dv = new DataView(ds.Tables[0]);
if (ViewState["CompanyID"] == null)
{
ViewState["CompanyID"] = "CompanyID Desc";
}
dv.Sort = ViewState["CompanyID"].ToString();
GridView1.DataSource = dv;
GridView1.DataBind();
}
public static DataSet GetListPersonl(ClCompany c)
{
SqlCommand cmd = new SqlCommand("PRC_Company_GetListPersonal", 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("CompanyID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.CompanyID);
cmd.Parameters.Add(new SqlParameter("CompanyName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.CompanyName);
cmd.Parameters.Add(new SqlParameter("ManageName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ManageName);
cmd.Parameters.Add(new SqlParameter("CompanyTel", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.CompanyTel);
cmd.Parameters.Add(new SqlParameter("ComapnyAdress", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ComapnyAdress);
cmd.Parameters.Add(new SqlParameter("RepresentativeName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RepresentativeName);
cmd.Parameters.Add(new SqlParameter("RepresentativeMobile", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RepresentativeMobile);
cmd.Parameters.Add(new SqlParameter("CompanyEmail", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.CompanyEmail);
cmd.Parameters.Add(new SqlParameter("PersonalID", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.PersonalID);
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(ClCompany c)
{
SqlCommand cmd = new SqlCommand("PRC_Company_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("CompanyName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.CompanyName);
cmd.Parameters.Add(new SqlParameter("ManageName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ManageName);
cmd.Parameters.Add(new SqlParameter("CompanyTel", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.CompanyTel);
cmd.Parameters.Add(new SqlParameter("ComapnyAdress", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ComapnyAdress);
cmd.Parameters.Add(new SqlParameter("RepresentativeName", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RepresentativeName);
cmd.Parameters.Add(new SqlParameter("RepresentativeMobile", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RepresentativeMobile);
cmd.Parameters.Add(new SqlParameter("CompanyEmail", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.CompanyEmail);
cmd.Parameters.Add(new SqlParameter("PersonalID", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.PersonalID);
cmd.Parameters.Add(new SqlParameter("CompanyTypeID", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.CompanyTypeID);
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();
}
}
public static DataSet GetListCompanyRequest(ClCompany c)
{
SqlCommand cmd = new SqlCommand("Prc_RequestTraffic_GetListCompanyGroup", 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("YearIDfilter", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.YearIDfilter);
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();
}
}