public void BindGrid()
{
ClAgreeExplanRepeat cl = new ClAgreeExplanRepeat();
cl.SubjectID = Convert.ToInt32(ddSubjectFilter.SelectedValue);
if (NotDefaultAgree == false)
{
cl.AgreementID = 0;
}
else
{
cl.AgreementID = Convert.ToInt32(LblAgreementID.Text);
}
cl.AgreementID = AgrrementID;
DataSet ds = AgreeExplanRepeatClass.GetList(cl);
DataView dv = new DataView(ds.Tables[0]);
if (ViewState["ExplanRepeatID"] == null)
{
ViewState["ExplanRepeatID"] = "ExplanRepeatID Desc";
}
dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["ExplanRepeatID"].ToString()).ToString();
GridView1.DataSource = dv;
GridView1.DataBind();
}
public void UpItem(object sender, EventArgs e)
{
String ExplanRepeatID = ((HtmlAnchor)sender).HRef.ToString();
LblParamExplanRepeatID.Text = ExplanRepeatID;
ClAgreeExplanRepeat cl = new ClAgreeExplanRepeat();
cl.ExplanRepeatID = Convert.ToInt32(ExplanRepeatID);
Data = cl;
LightBox.Value = "1";
YearMonthShow();
}
//---------------------------------------------------------------------------------------------------------
public static DataSet GetList(ClAgreeExplanRepeat c)
{
SqlCommand cmd = new SqlCommand("PRC_AgreeExplanRepeat_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("ExplanRepeatID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ExplanRepeatID);
cmd.Parameters.Add(new SqlParameter("ExplanID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ExplanID);
cmd.Parameters.Add(new SqlParameter("RpeatMonth1", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth1);
cmd.Parameters.Add(new SqlParameter("RpeatMonth2", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth2);
cmd.Parameters.Add(new SqlParameter("RpeatMonth3", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth3);
cmd.Parameters.Add(new SqlParameter("RpeatMonth4", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth4);
cmd.Parameters.Add(new SqlParameter("RpeatMonth5", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth5);
cmd.Parameters.Add(new SqlParameter("RpeatMonth6", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth6);
cmd.Parameters.Add(new SqlParameter("RpeatMonth7", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth7);
cmd.Parameters.Add(new SqlParameter("RpeatMonth8", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth8);
cmd.Parameters.Add(new SqlParameter("RpeatMonth9", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth9);
cmd.Parameters.Add(new SqlParameter("RpeatMonth10", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth10);
cmd.Parameters.Add(new SqlParameter("RpeatMonth11", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth11);
cmd.Parameters.Add(new SqlParameter("RpeatMonth12", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth12);
cmd.Parameters.Add(new SqlParameter("AgreementID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementID);
cmd.Parameters.Add(new SqlParameter("RepeateYear", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RepeateYear);
cmd.Parameters.Add(new SqlParameter("SubjectID", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.SubjectID);
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(ClAgreeExplanRepeat c)
{
SqlCommand cmd = new SqlCommand("PRC_AgreeExplanRepeat_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("YearLyOrMonthly", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.YearLyOrMonthly);
cmd.Parameters.Add(new SqlParameter("ExplanID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.ExplanID);
cmd.Parameters.Add(new SqlParameter("RpeatMonth1", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth1);
cmd.Parameters.Add(new SqlParameter("RpeatMonth2", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth2);
cmd.Parameters.Add(new SqlParameter("RpeatMonth3", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth3);
cmd.Parameters.Add(new SqlParameter("RpeatMonth4", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth4);
cmd.Parameters.Add(new SqlParameter("RpeatMonth5", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth5);
cmd.Parameters.Add(new SqlParameter("RpeatMonth6", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth6);
cmd.Parameters.Add(new SqlParameter("RpeatMonth7", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth7);
cmd.Parameters.Add(new SqlParameter("RpeatMonth8", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth8);
cmd.Parameters.Add(new SqlParameter("RpeatMonth9", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth9);
cmd.Parameters.Add(new SqlParameter("RpeatMonth10", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth10);
cmd.Parameters.Add(new SqlParameter("RpeatMonth11", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth11);
cmd.Parameters.Add(new SqlParameter("RpeatMonth12", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RpeatMonth12);
cmd.Parameters.Add(new SqlParameter("AgreementID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.AgreementID);
cmd.Parameters.Add(new SqlParameter("RepeateYear", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.RepeateYear);
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)
{
ClAgreeExplanRepeat cl = new ClAgreeExplanRepeat();
cl = Data;
if (NotDefaultAgree == false)
{
cl.AgreementID = null;
}
else
{
cl.AgreementID = Convert.ToInt32(LblAgreementID.Text);
}
if (NotDefaultAgree == false)
{
cl.AgreementID = null;
}
int t = 0;
if (CSharp.PublicFunction.ModeInsert(ExplanRepeatID.ToString()))
{
t = AgreeExplanRepeatClass.insert(cl);
}
else
{
t = AgreeExplanRepeatClass.Update(cl);
}
if (t == 0)
{
LblMsg.ForeColor = System.Drawing.Color.Red;
LblMsg.Text = "خطا در ثبت";
}
else if (t == -1)
{
CSharp.Utility.ShowMsg(Page, CSharp.ProPertyData.MsgType.warning, "برای این شرح کار تکرار ثبت شده است");
}
else
{
LblMsg.ForeColor = System.Drawing.Color.Green;
LblMsg.Text = "ثبت انجام شد.";
BindGrid();
}
LblParamExplanRepeatID.Text = "0";
}
