private void toolStripButton1_Click(object sender, EventArgs e) { PersianDateFormatter pdf = new PersianDateFormatter(); int date = pdf.convert(toolStripTextBox1.Text); OtherRepository otherRepository = new OtherRepository(); radGridView1.DataSource = otherRepository.getCustomerJoinContract(date); }
private void CustomerPaymentsForm_Load(object sender, EventArgs e) { OtherRepository repo = new OtherRepository(); radGridView1.DataSource = repo.getCustomersPayment(); radGridView1.GridViewElement.PagingPanelElement.RightToLeft = true; ((GridTableElement)radGridView1.TableElement).AlternatingRowColor = Color.FromArgb(215, 234, 124); radGridView1.TableElement.RowHeight = 35; saveFileDialog1.FileName = "export"; saveFileDialog1.Filter = "xlsx files (*.xlsx)|*.xlsx|All files (*.*)|*.*"; }
private void toolStripbNext_Click(object sender, EventArgs e) { PersianDateFormatter pdf = new PersianDateFormatter(); DateTime dt = DateTime.Now; dayCounter++; dt = dt.AddDays(dayCounter); toolStripTextBox1.Text = pdf.getDateString(dt); OtherRepository otherRepository = new OtherRepository(); radGridView1.DataSource = otherRepository.getCustomerJoinContract(dt); }
private void EasyAccounting_Load(object sender, EventArgs e) { PersianDateFormatter pdf = new PersianDateFormatter(); toolStripTextBox1.Text = pdf.getDateString(DateTime.Now); ((GridTableElement)radGridView1.TableElement).AlternatingRowColor = Color.FromArgb(215, 234, 124); radGridView1.TableElement.RowHeight = 50; OtherRepository otherRepository = new OtherRepository(); radGridView1.DataSource = otherRepository.getCustomerJoinContract(DateTime.Now); timer1.Start(); //GsmCommMain comm = new GsmCommMain("COM8", 9600, 150); //comm.Open(); //byte dcs = (byte)DataCodingScheme.GeneralCoding.Alpha16Bit; //SmsSubmitPdu pdu = new SmsSubmitPdu("امین", "09398987855", dcs); //comm.SendMessage(pdu); }
public ComponentsController( CPUWatercoolerRepository cpuWatercoolerRepository, FanRepository fanRepository, GraphicsCardRepository graphicsCardRepository, HardDriveRepository hardDriveRepository, MotherboardRepository motherboardRepository, OtherRepository otherRepository, PCCaseRepository pcCaseRepository, PowerSupplyRepository powerSupplyRepository, ProcessorRepository processorRepository, RAMRepository ramRepository) { this._cpuWatercoolerRepository = cpuWatercoolerRepository; this._fanRepository = fanRepository; this._graphicsCardRepository = graphicsCardRepository; this._hardDriveRepository = hardDriveRepository; this._motherboardRepository = motherboardRepository; this._otherRepository = otherRepository; this._pcCaseRepository = pcCaseRepository; this._powerSupplyRepository = powerSupplyRepository; this._processorRepository = processorRepository; this._ramRepository = ramRepository; }
public ActionResult getBranch(string hub_code) { return(Json(OtherRepository.GetAllBranches(hub_code).OrderBy(a => a.branch_name), JsonRequestBehavior.AllowGet)); }
// GET: UserAccounts public ActionResult Index() { ViewBag.hub_code = new SelectList(OtherRepository.GetAllHub().OrderBy(a => a.hub_name), "hub_code", "hub_name"); return(View()); }
public string LoadLogo() { OtherRepository otherRepo = new OtherRepository(); return(otherRepo.GetOtherByCode("Logo").Other_Content); }
public PublicDataRepository(OtherRepository repository) { Repository = repository; }
private void toolStripButton1_Click(object sender, EventArgs e) { PersianDateFormatter pdf = new PersianDateFormatter(); int date = pdf.convert(toolStripTextBox1.Text); OtherRepository otherRepository = new OtherRepository(); radGridView1.DataSource = otherRepository.getCustomerJoinContract(date); }
private void toolStripbNext_Click(object sender, EventArgs e) { PersianDateFormatter pdf = new PersianDateFormatter(); DateTime dt = DateTime.Now; dayCounter++; dt = dt.AddDays(dayCounter); toolStripTextBox1.Text = pdf.getDateString(dt); OtherRepository otherRepository = new OtherRepository(); radGridView1.DataSource = otherRepository.getCustomerJoinContract(dt); }
private void CustomerPaymentsForm_Load(object sender, EventArgs e) { OtherRepository repo = new OtherRepository(); radGridView1.DataSource = repo.getCustomersPayment(); radGridView1.GridViewElement.PagingPanelElement.RightToLeft = true; ((GridTableElement)radGridView1.TableElement).AlternatingRowColor = Color.FromArgb(215, 234, 124); radGridView1.TableElement.RowHeight = 35; saveFileDialog1.FileName = "export"; saveFileDialog1.Filter = "xlsx files (*.xlsx)|*.xlsx|All files (*.*)|*.*"; }
private void EasyAccounting_Load(object sender, EventArgs e) { PersianDateFormatter pdf = new PersianDateFormatter(); toolStripTextBox1.Text = pdf.getDateString(DateTime.Now); ((GridTableElement)radGridView1.TableElement).AlternatingRowColor = Color.FromArgb(215, 234, 124); radGridView1.TableElement.RowHeight = 50; OtherRepository otherRepository = new OtherRepository(); radGridView1.DataSource = otherRepository.getCustomerJoinContract(DateTime.Now); timer1.Start(); //GsmCommMain comm = new GsmCommMain("COM8", 9600, 150); //comm.Open(); //byte dcs = (byte)DataCodingScheme.GeneralCoding.Alpha16Bit; //SmsSubmitPdu pdu = new SmsSubmitPdu("امین", "09398987855", dcs); //comm.SendMessage(pdu); }
private void timer1_Tick(object sender, EventArgs e) { PersianDateFormatter pdf = new PersianDateFormatter(); int date = pdf.convert(toolStripTextBox1.Text); OtherRepository otherRepository = new OtherRepository(); radGridView1.DataSource = otherRepository.getCustomerJoinContract(date); ///////////////////////////////////////////////// DefaultSettingsRepository dRepo = new DefaultSettingsRepository(); DefaultSetting gsmPort = dRepo.GetSetting("gsm_port"); DefaultSetting lastSend = dRepo.GetSetting("last_send"); if (lastSend == null) { DefaultSetting ls = new DefaultSetting(); ls.Value = "13000101"; ls.Name = "last_send"; dRepo.AddSettings(ls); } else { int lastSendInt = Convert.ToInt32(lastSend.Value); int todayInt = pdf.getDateInteger(DateTime.Now); int x = 0; if (todayInt <= lastSendInt) { return; } } if (gsmPort != null) { if (gsmPort.Value != "NULL") { try { GsmCommMain comm = new GsmCommMain(gsmPort.Value, 9600, 150); comm.Open(); byte dcs = (byte)DataCodingScheme.GeneralCoding.Alpha16Bit; DefaultSetting sendTime = dRepo.GetSetting("send_message_time"); DefaultSetting days = dRepo.GetSetting("days_before_send"); DefaultSetting text = dRepo.GetSetting("message_text"); int daysInteger = Convert.ToInt32(days.Value); TimeSpan ts = TimeSpan.Parse(sendTime.Value); TimeSpan nts = DateTime.Now.TimeOfDay; TimeSpan fivemin = TimeSpan.FromMinutes(5); if (nts.CompareTo(ts) >= 0) { if (nts.Subtract(ts).CompareTo(fivemin) > 0) { return; } } else { if (ts.Subtract(nts).CompareTo(fivemin) > 0) { return; } } DateTime dt = DateTime.Now; dt = dt.AddDays(daysInteger); string dateString = pdf.getDateString(dt); object customers = otherRepository.getCustomerJoinContract(dt); IEnumerable <object> collection = (IEnumerable <object>)customers; foreach (object item in collection) { var nameOfProperty = "PhoneNumber"; var propertyInfo = item.GetType().GetProperty(nameOfProperty); var phoneNumber = propertyInfo.GetValue(item, null); var nameOfProperty2 = "Time"; var propertyInfo2 = item.GetType().GetProperty(nameOfProperty2); var time = propertyInfo2.GetValue(item, null); string timeString = time.ToString(); timeString = timeString.Remove(timeString.Length - 3); string smsText = text.Value + Environment.NewLine + dateString + Environment.NewLine + timeString; SmsSubmitPdu pdu = new SmsSubmitPdu(smsText, phoneNumber.ToString(), dcs); comm.SendMessage(pdu); } DefaultSettingsRepository dRepo2 = new DefaultSettingsRepository(); DefaultSetting lsls = dRepo2.GetSetting("last_send"); lsls.Value = pdf.getDateInteger(DateTime.Now).ToString(); dRepo2.UpdateSetting(lsls); } catch (Exception ex) { } } } }
public OthersController(OtherRepository repository) { this._repository = repository; }
private void bShowChart_Click(object sender, EventArgs e) { if (cDropDownMonth.Enabled == true) { radChartView1.Series.Clear(); radChartView1.Axes.Clear(); int monthInteger = Convert.ToInt32(cDropDownMonth.SelectedValue.ToString()); int year = Convert.ToInt32(numericUpDown1.Value); OtherRepository repo = new OtherRepository(); List <DayReport> list = repo.getGroupByDay(year, monthInteger); CartesianSeries series = new LineSeries(); CategoricalAxis horizontalAxis = new CategoricalAxis(); horizontalAxis.PlotMode = AxisPlotMode.OnTicksPadded; LinearAxis verticalAxis = new LinearAxis(); verticalAxis.AxisType = AxisType.Second; series.PointSize = new SizeF(5, 5); series.HorizontalAxis = horizontalAxis; series.VerticalAxis = verticalAxis; series.BorderWidth = 3; series.BorderColor = Color.SkyBlue; series.CategoryMember = "Day"; series.ValueMember = "Income"; series.DataSource = list; series.ShowLabels = true; this.radChartView1.Series.Add(series); } else if (comboBox1.SelectedIndex == 1) { radChartView1.Series.Clear(); radChartView1.Axes.Clear(); int monthInteger = Convert.ToInt32(cDropDownMonth.SelectedValue.ToString()); int year = Convert.ToInt32(numericUpDown1.Value); OtherRepository repo = new OtherRepository(); List <MonthReport> list = repo.getGroupByMonth(year); CartesianSeries series = new LineSeries(); CategoricalAxis horizontalAxis = new CategoricalAxis(); horizontalAxis.PlotMode = AxisPlotMode.OnTicksPadded; LinearAxis verticalAxis = new LinearAxis(); verticalAxis.AxisType = AxisType.Second; series.PointSize = new SizeF(5, 5); series.HorizontalAxis = horizontalAxis; series.VerticalAxis = verticalAxis; series.BorderWidth = 3; series.BorderColor = Color.SkyBlue; series.CategoryMember = "Month"; series.ValueMember = "Income"; series.DataSource = list; series.ShowLabels = true; this.radChartView1.Series.Add(series); } else { radChartView1.Series.Clear(); radChartView1.Axes.Clear(); int monthInteger = Convert.ToInt32(cDropDownMonth.SelectedValue.ToString()); int year = Convert.ToInt32(numericUpDown1.Value); OtherRepository repo = new OtherRepository(); List <YearReport> list = repo.getGroupByYear(); CartesianSeries series = new LineSeries(); CategoricalAxis horizontalAxis = new CategoricalAxis(); horizontalAxis.PlotMode = AxisPlotMode.OnTicksPadded; LinearAxis verticalAxis = new LinearAxis(); verticalAxis.AxisType = AxisType.Second; series.PointSize = new SizeF(5, 5); series.HorizontalAxis = horizontalAxis; series.VerticalAxis = verticalAxis; series.BorderWidth = 3; series.BorderColor = Color.SkyBlue; series.CategoryMember = "Year"; series.ValueMember = "Income"; series.DataSource = list; series.ShowLabels = true; this.radChartView1.Series.Add(series); } }
public string LoadSDT() { OtherRepository otherRepo = new OtherRepository(); return(otherRepo.GetOtherByCode("Hotline").Other_Content); }
private void timer1_Tick(object sender, EventArgs e) { PersianDateFormatter pdf = new PersianDateFormatter(); int date = pdf.convert(toolStripTextBox1.Text); OtherRepository otherRepository = new OtherRepository(); radGridView1.DataSource = otherRepository.getCustomerJoinContract(date); ///////////////////////////////////////////////// DefaultSettingsRepository dRepo = new DefaultSettingsRepository(); DefaultSetting gsmPort = dRepo.GetSetting("gsm_port"); DefaultSetting lastSend = dRepo.GetSetting("last_send"); if (lastSend == null) { DefaultSetting ls = new DefaultSetting(); ls.Value = "13000101"; ls.Name = "last_send"; dRepo.AddSettings(ls); } else { int lastSendInt = Convert.ToInt32(lastSend.Value); int todayInt = pdf.getDateInteger(DateTime.Now); int x = 0; if (todayInt <= lastSendInt) { return; } } if (gsmPort != null) { if (gsmPort.Value != "NULL") { try { GsmCommMain comm = new GsmCommMain(gsmPort.Value, 9600, 150); comm.Open(); byte dcs = (byte)DataCodingScheme.GeneralCoding.Alpha16Bit; DefaultSetting sendTime = dRepo.GetSetting("send_message_time"); DefaultSetting days = dRepo.GetSetting("days_before_send"); DefaultSetting text = dRepo.GetSetting("message_text"); int daysInteger = Convert.ToInt32(days.Value); TimeSpan ts = TimeSpan.Parse(sendTime.Value); TimeSpan nts = DateTime.Now.TimeOfDay; TimeSpan fivemin = TimeSpan.FromMinutes(5); if (nts.CompareTo(ts) >= 0) { if (nts.Subtract(ts).CompareTo(fivemin) > 0) { return; } } else { if (ts.Subtract(nts).CompareTo(fivemin) > 0) { return; } } DateTime dt = DateTime.Now; dt = dt.AddDays(daysInteger); string dateString = pdf.getDateString(dt); object customers = otherRepository.getCustomerJoinContract(dt); IEnumerable<object> collection = (IEnumerable<object>)customers; foreach (object item in collection) { var nameOfProperty = "PhoneNumber"; var propertyInfo = item.GetType().GetProperty(nameOfProperty); var phoneNumber = propertyInfo.GetValue(item, null); var nameOfProperty2 = "Time"; var propertyInfo2 = item.GetType().GetProperty(nameOfProperty2); var time = propertyInfo2.GetValue(item, null); string timeString = time.ToString(); timeString = timeString.Remove(timeString.Length-3); string smsText = text.Value + Environment.NewLine + dateString + Environment.NewLine + timeString; SmsSubmitPdu pdu = new SmsSubmitPdu(smsText, phoneNumber.ToString(), dcs); comm.SendMessage(pdu); } DefaultSettingsRepository dRepo2 = new DefaultSettingsRepository(); DefaultSetting lsls = dRepo2.GetSetting("last_send"); lsls.Value = pdf.getDateInteger(DateTime.Now).ToString(); dRepo2.UpdateSetting(lsls); } catch (Exception ex) { } } } }