public void BindGrid()
{
ClAgreementFine cl = new ClAgreementFine();
if (NotDefaultAgree == false)
{
cl.AgreementID = 0;
}
else
{
cl.AgreementID = Convert.ToInt32(AgreementID);
}
DataSet ds = AgreementFineClass.GetList(cl);
DataView dv = new DataView(ds.Tables[0]);
if (ViewState["AgreementFineID"] == null)
{
ViewState["AgreementFineID"] = "AgreementFineID Desc";
}
dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["AgreementFineID"].ToString()).ToString();
GridView1.DataSource = dv;
GridView1.DataBind();
}
public void UpItem(object sender, EventArgs e)
{
String AgreementFineID = ((HtmlAnchor)sender).HRef.ToString();
LblParamAgreementFineID.Text = AgreementFineID;
ClAgreementFine cl = new ClAgreementFine();
cl.AgreementFineID = Convert.ToInt32(AgreementFineID);
Data = cl;
LightBox.Value = "1";
}
protected void btnprint21_Click(object sender, EventArgs e)
{
try
{
DataSet ds = null;
if (Request.QueryString["RName"].ToString() == "Rp_ExplainPrice2" ||
Request.QueryString["RName"].ToString() == "Rp_SubjectPrice"
)
{
ClArchiveAgree cl = new ClArchiveAgree();
cl.AgreeID = Convert.ToInt32(ddAgree.SelectedValue);
cl.AcrchiveID = ctlArchiveDD.SelectedValue;
if (Request.QueryString["RName"].ToString() == "Rp_ExplainPrice2")
{
ds = ArchiveAgreeClass.GetListReport(cl);
}
else if (Request.QueryString["RName"].ToString() == "Rp_SubjectPrice")
{
ds = AgreementClass.GetListSubjectPrice(cl);
}
}
else if (Request.QueryString["RName"].ToString() == "SumPay" ||
Request.QueryString["RName"].ToString() == "SumPay2" ||
Request.QueryString["RName"].ToString() == "RptSumPayPage")
{
ClExplanSubject cl2 = new ClExplanSubject();
cl2.ExplainSubjectID = Convert.ToInt32(CtlAllSubjectExplan.SelectedValue);
cl2.SubjectID = Convert.ToInt32(CtlAllSubjectExplan.subjectID);
cl2.FromDate = CtlFromToDate.FromDate;
cl2.ToDate = CtlFromToDate.ToDate;
ds = ExplanSubjectClass.GetListSumPay(cl2, 0);
}
else if (Request.QueryString["RName"].ToString() == "Rp_Khesarat" || Request.QueryString["RName"].ToString() == "rp_khesart3")
{
ClAgreementFine cl = new ClAgreementFine();
cl.AgreementID = Convert.ToInt32(ddAgree.SelectedValue);
cl.ArchivID = Convert.ToInt32(ctlArchiveDD.SelectedValue);
ds = AgreementFineClass.GetList_Rep(cl);
}
Session["ReportData"] = ds;
MyIfarm1.Visible = true;
MyIfarm1.Attributes.Add("src", "~/Report/reportview2.aspx?RName=" + Request.QueryString["RName"].ToString() + "&PName=" + Request.QueryString["PName"].ToString());
}
catch { }
}
//---------------------------------------------------------------------------------------------------------
public static DataSet GetList_Rep(ClAgreementFine c)
{
SqlCommand cmd = new SqlCommand("PRC_AgreementFine_GetList_rep", 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("AgreementFineID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementFineID);
cmd.Parameters.Add(new SqlParameter("FineID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.FineID);
cmd.Parameters.Add(new SqlParameter("AgreementID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementID);
cmd.Parameters.Add(new SqlParameter("FineDate", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.FineDate);
cmd.Parameters.Add(new SqlParameter("FinePrice", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.FinePrice);
cmd.Parameters.Add(new SqlParameter("FineComment", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.FineComment);
cmd.Parameters.Add(new SqlParameter("ArchivID", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.ArchivID);
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(ClAgreementFine c)
{
SqlCommand cmd = new SqlCommand("PRC_AgreementFine_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("FineID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.FineID);
cmd.Parameters.Add(new SqlParameter("AgreementID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementID);
cmd.Parameters.Add(new SqlParameter("FineDate", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.FineDate);
cmd.Parameters.Add(new SqlParameter("FinePrice", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.FinePrice);
cmd.Parameters.Add(new SqlParameter("FineComment", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.FineComment);
cmd.Parameters.Add(new SqlParameter("NumberFine", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.NumberFine);
cmd.Parameters.Add(new SqlParameter("AdressFine", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.AdressFine);
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 BtnInsert_Click(Object sender, System.EventArgs e)
{
//if (TXTFineDate.Text == "")
// return;
if (txtAdressFine.Text == "" || TXTFineComment.Text == "" || DDFineID.Text == "" || TXTFineDate.Text == "" || TXTFinePrice.Text == "" || txtNumberFine.Text == "")
{
LblMsg.ForeColor = System.Drawing.Color.Red;
LblMsg.Text = "تمام اطلاعات باید وارد شوند";
return;
}
ClAgreementFine cl = new ClAgreementFine();
cl = Data;
int t = 0;
if (CSharp.PublicFunction.ModeInsert(AgreementFineID.ToString()))
{
t = AgreementFineClass.insert(cl);
}
else
{
t = AgreementFineClass.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";
LblParamAgreementFineID.Text = "0";
}
