private void FillMonthList() { lvwExist.Items.Clear(); if (selectedMagazine == null || selectedYear == 0) { return; } MagazineDate obj = new MagazineDate { MagazineId = selectedMagazine.MagazineId, Date = new DateTime(selectedYear, 1, 1) }; OMagazineDateGet get = new OMagazineDateGet(obj); get.Execute(); List <MagazineDate> objList = get.ObjList; //Kayıtlı aylar dolduruluyor int i = 1; foreach (MagazineDate maObj in objList) { string monthName = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(maObj.Date.Month); string[] row = { i.ToString(), monthName, maObj.MagazineDateId.ToString() }; ListViewItem item = new ListViewItem(row); lvwExist.Items.Add(item); i++; } ResizeColumns(lvwMagazine); }
private void FillMonthList() { if (selectedMagazine == null || selectedYear == 0) { return; } lvwExist.Items.Clear(); lvwMonth.Items.Clear(); MagazineDate obj = new MagazineDate { MagazineId = selectedMagazine.MagazineId, Date = new DateTime(selectedYear, 1, 1) }; OMagazineDateGet get = new OMagazineDateGet(obj); get.Execute(); List <MagazineDate> objList = get.ObjList; List <int> months = new List <int> { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 }; //Kayıtlı aylar dolduruluyor int i = 1; foreach (MagazineDate maObj in objList) { months.Remove(maObj.Date.Month); string monthName = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(maObj.Date.Month); string[] row = { i.ToString(), monthName, maObj.Date.Month.ToString() }; ListViewItem item = new ListViewItem(row); lvwExist.Items.Add(item); i++; } //Kayıtlı olmayan aylar dolduruluyor i = 1; foreach (int a in months) { string monthName = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(a); string[] row = { i.ToString(), monthName, a.ToString() }; ListViewItem item = new ListViewItem(row); lvwMonth.Items.Add(item); i++; } lvwExist.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); lvwMonth.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); }
private void BsStandartToolStrip1_OkDeleteButtonClicked(object sender, EventArgs e) { MagazineDate obj = new MagazineDate { MagazineId = selectedMagazine.MagazineId, Date = new DateTime(selectedYear, deletedMonth, 1) }; OMagazineDateDelete delete = new OMagazineDateDelete(obj); BsNewResult result = delete.Execute(); BsMessageBox.Show(result); GetFormReady(); }
public List <MagazineDate> GetList(MagazineDate obj) { string query = string.Format("SELECT * FROM MagazineDate " + "JOIN Magazine " + "ON MagazineDate.MagazineId = Magazine.MagazineId " + "WHERE MagazineDate.MagazineId = {0} " + "AND strftime('%Y', Date) = '{1}' " + "ORDER BY Date", obj.MagazineId, obj.Date.Year); using (var cnn = SimpleDbConnection()) { cnn.Open(); return(cnn.Query <MagazineDate>(query).AsList()); } }
public override string ToString() { StringBuilder stringBuilder = new StringBuilder(); foreach (var article in ArticleList) { stringBuilder.AppendLine(article.ToString()); } stringBuilder.AppendLine("Persons:"); foreach (var person in PersonsList) { stringBuilder.AppendLine(person.ToString()); } return(string.Format( " MagazineName: {0},\n Timing: {1},\n MagazineDate: {2},\n Article: {3},\n MiddleRate: {4}\n", MagazineName, Timing, MagazineDate.ToShortDateString(), stringBuilder, MiddleRate)); }
public virtual string ToShortString() { return(string.Format(" MagazineName: {0},\n Timing: {1},\n MagazineDate: {2},\n MiddleRate: {3}\n", MagazineName, Timing, MagazineDate.ToShortDateString(), MiddleRate)); }
public OMagazineDateDelete(MagazineDate obj) { this.obj = obj; }
public OMagazineDateSave(MagazineDate obj) { this.obj = obj; }
public OMagazineDateGet(MagazineDate obj) { this.obj = obj; }