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"; }