protected void btnShajBank_Click(object sender, EventArgs e)
{
//if(Convert.ToInt32( txtPrice.Text)<10000)
//{
// TerraficPlanBLL.Utility.ShowMsg(Page,TerraficPlanBLL.ProPertyData.MsgType.warning,"مبلغ شارژ باید از 1000 تومات بیشتر باشد");
// return;
//}
ClSharj cl = new ClSharj();
cl.CodeMelli = TXTNationalCode.Text;
cl.Mobile = TXTPersonalMobile.Text;
cl.ShariPrice = Convert.ToInt32(txtPrice.Text);
int i = SharjClass.insert(cl);
if (i == 0)
{
TerraficPlanBLL.Utility.ShowMsg(Page, TerraficPlanBLL.ProPertyData.MsgType.warning, "خطا در ثبت");
}
else
{
Pay_Click(i, Convert.ToInt32(txtPrice.Text));
}
}
public void BindGrid()
{
ClSharj cl = new ClSharj();
cl.PersonalID = Convert.ToInt32(LBLPersonlID.Text);
DataSet ds = SharjClass.GetList(cl);
DataView dv = new DataView(ds.Tables[0]);
if (ViewState["Sharj"] == null)
{
ViewState["Sharj"] = "SharjID Desc";
}
dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["Sharj"].ToString()).ToString();
GridView1.DataSource = dv;
GridView1.DataBind();
}
//---------------------------------------------------------------------------------------------------------
public static DataSet GetList(ClSharj c)
{
SqlCommand cmd = new SqlCommand("PRC_Sharj_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("SharjID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.SharjID);
cmd.Parameters.Add(new SqlParameter("PersonalID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PersonalID);
cmd.Parameters.Add(new SqlParameter("ShariPrice", SqlDbType.BigInt)).Value = Securenamespace.SecureData.CheckSecurity(c.ShariPrice);
cmd.Parameters.Add(new SqlParameter("ShajComment", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ShajComment);
cmd.Parameters.Add(new SqlParameter("SharjDate", SqlDbType.SmallDateTime)).Value = Securenamespace.SecureData.CheckSecurity(c.SharjDate);
cmd.Parameters.Add(new SqlParameter("ISExpire", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ISExpire);
cmd.Parameters.Add(new SqlParameter("IsZero", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.IsZero);
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(ClSharj c)
{
SqlCommand cmd = new SqlCommand("PRC_Sharj_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("PersonalID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.PersonalID);
cmd.Parameters.Add(new SqlParameter("ShariPrice", SqlDbType.BigInt)).Value = Securenamespace.SecureData.CheckSecurity(c.ShariPrice);
cmd.Parameters.Add(new SqlParameter("ShajComment", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ShajComment);
cmd.Parameters.Add(new SqlParameter("SharjDate", SqlDbType.SmallDateTime)).Value = Securenamespace.SecureData.CheckSecurity(c.SharjDate);
cmd.Parameters.Add(new SqlParameter("ISExpire", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ISExpire);
cmd.Parameters.Add(new SqlParameter("IsZero", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.IsZero);
cmd.Parameters.Add(new SqlParameter("Mobile", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.Mobile);
cmd.Parameters.Add(new SqlParameter("CodeMelli", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.CodeMelli);
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();
}
}
protected void btnShajBank_Click(object sender, EventArgs e)
{
ClSharj cl = new ClSharj();
cl.PersonalID = Convert.ToInt32(LBLPersonlID.Text);
cl.ShariPrice = Convert.ToInt32(txtPrice.Text);
cl.ShajComment = txtComment.Text;
int i = SharjClass.insert(cl);
if (i == 0)
{
TerraficPlanBLL.Utility.ShowMsg(Page, TerraficPlanBLL.ProPertyData.MsgType.warning, "");
}
else
{
Pay_Click(i, Convert.ToInt32(txtPrice.Text));
BindGrid();
}
}
