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