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(); } }