protected void MonthClick(object sender, EventArgs e)
{
HtmlAnchor a = (HtmlAnchor)sender;
int RepeatTypeID = Convert.ToInt32(LightBoxvalue.Value);
int repeateVaue = Convert.ToInt32(a.HRef.ToString());
ClRequestRepeat cl = new ClRequestRepeat();
cl.RequestID = Convert.ToInt32(LblRequestID.Text);
cl.RepeatTypeID = RepeatTypeID;
cl.YearMonthSeasonID = repeateVaue;
int t = RequestRepeatClass.insert(cl);
if (t == 0)
{
TerraficPlanBLL.Utility.ShowMsg(Page, TerraficPlanBLL.ProPertyData.MsgType.General_Fault, "خطا در ثبت!!!");
}
else if (t == -100)
{
TerraficPlanBLL.Utility.ShowMsg(Page, TerraficPlanBLL.ProPertyData.MsgType.General_Fault, "تداخل در تاریخ های انتخابی وجود دارد.لطفا دقت نمایید!!!");
}
else
{
BindGrid();
}
}
private void BindData()
{
ClRequestRepeat cl = new ClRequestRepeat();
cl.RequestID = Convert.ToInt32(lblreqtraficID.Text);
DataSet ds = RequestRepeatClass.GetList(cl);
DataList1.DataSource = ds;
DataList1.DataBind();
}
protected void RepeatDelete(object sender, EventArgs e)
{
HtmlAnchor c = (HtmlAnchor)sender;
int id = Convert.ToInt32(c.HRef.ToString());
ClRequestRepeat cl = new ClRequestRepeat();
cl.RequestRepeatID = id;
if (RequestRepeatClass.Delete(id.ToString()) == 0)
{
TerraficPlanBLL.Utility.ShowMsg(Page, TerraficPlanBLL.ProPertyData.MsgType.General_Fault, "خطا در حذف");
}
else
{
BindGrid();
}
}
//---------------------------------------------------------------------------------------------------------
public static DataSet GetList(ClRequestRepeat c)
{
SqlCommand cmd = new SqlCommand("PRC_RequestRepeat_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("RequestRepeatID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.RequestRepeatID);
cmd.Parameters.Add(new SqlParameter("RequestID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.RequestID);
cmd.Parameters.Add(new SqlParameter("RepeatTypeID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.RepeatTypeID);
cmd.Parameters.Add(new SqlParameter("RepeatDate", SqlDbType.SmallDateTime)).Value = Securenamespace.SecureData.CheckSecurity(c.RepeatDate);
cmd.Parameters.Add(new SqlParameter("YearMonthSeasonID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.YearMonthSeasonID);
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();
}
}
private string RetAllRequestDate(int RequestID)
{
ClRequestRepeat cl = new ClRequestRepeat();
cl.RequestID = RequestID;
DataSet ds = RequestRepeatClass.GetList(cl);
string s = "";
if (ds.Tables[0].Rows.Count > 0)
{
s = ds.Tables[0].Rows[0]["RepeatTypeIDName"].ToString() + "::";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
s += ds.Tables[0].Rows[i]["TitelName"].ToString() + ";";
}
}
ds.Dispose();
return(s);
}
public void BindGrid()
{
ClRequestRepeat cl = new ClRequestRepeat();
cl.RequestID = Convert.ToInt32(LblRequestID.Text);
DataSet ds = RequestRepeatClass.GetList(cl);
dlistselect.DataSource = ds.Tables[0];
dlistselect.DataBind();
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
lblprice.Text = dr["pricee"].ToString();
// lblPriceFa.Text=TerraficPlanBLL.NumbertoText.getnum3(Convert.ToInt32(dr["pricee"].ToString()));
}
else
{
lblprice.Text = "0";
}
ds.Dispose();
}
public static int insert(ClRequestRepeat c)
{
SqlCommand cmd = new SqlCommand("PRC_RequestRepeat_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("RequestID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.RequestID);
cmd.Parameters.Add(new SqlParameter("RepeatTypeID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.RepeatTypeID);
cmd.Parameters.Add(new SqlParameter("RepeatDate", SqlDbType.SmallDateTime)).Value = Securenamespace.SecureData.CheckSecurity(c.RepeatDate);
cmd.Parameters.Add(new SqlParameter("YearMonthSeasonID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.YearMonthSeasonID);
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 btnInsertDay_Click(object sender, EventArgs e)
{
ClRequestRepeat cl = new ClRequestRepeat();
cl.RepeatDate = DateConvert.sh2m(CtlDatePicker1.Text).ToString();
cl.RequestID = Convert.ToInt32(LblRequestID.Text);
cl.RepeatTypeID = Convert.ToInt32(ddHalfDay.SelectedValue);
int t = RequestRepeatClass.insert(cl);
if (t == 0)
{
TerraficPlanBLL.Utility.ShowMsg(Page, TerraficPlanBLL.ProPertyData.MsgType.General_Fault, "خطا در ثبت!!!");
}
else if (t == -100)
{
TerraficPlanBLL.Utility.ShowMsg(Page, TerraficPlanBLL.ProPertyData.MsgType.General_Fault, "تداخل در تاریخ های انتخابی وجود دارد.لطفا دقت نمایید!!!");
}
else
{
BindGrid();
}
LightBox.Value = "1";
}
protected void Aselect_ServerClick(object sender, EventArgs e)
{
string RequestID = ((HtmlAnchor)sender).HRef.ToString();
ClRequestRepeat cl = new ClRequestRepeat();
cl.RequestID = Convert.ToInt32(RequestID);
DataSet ds = RequestRepeatClass.GetList(cl);
dlistselect.DataSource = ds.Tables[0];
dlistselect.DataBind();
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
// lblprice.Text = dr["pricee"].ToString();
// lblPriceFa.Text=TerraficPlanBLL.NumbertoText.getnum3(Convert.ToInt32(dr["pricee"].ToString()));
}
else
{
// lblprice.Text = "0";
}
ds.Dispose();
LightBoxRepeat.Value = "1";
}
