private void DeleteOperation()
{
var edu = gridView.GetFocusedRow() as Educator;
DataCheck(edu);
DialogResult dialogResult = MessageBox.Show("Желаете ли да изтриете този запис", "Подтвърдете", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var db = new PUEntitiesOne())
{
//db.Entry(edu).State = EntityState.Deleted;
db.Educators.Attach(edu);
db.Educators.Remove(edu);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show("Имате съществуващ запис в друга таблица с тези данни");
return;
}
}
}
}
private void DeleteOperation()
{
var cour = gridView.GetFocusedRow() as Cours;
DialogResult dialogResult = MessageBox.Show("Желаете ли да изтриете този запис", "Подтвърдете", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var db = new PUEntitiesOne())
{
db.Courses.Attach(cour);
db.Courses.Remove(cour);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show("Имате съществуващ запис в друга таблица с тези данни");
return;
}
}
}
}
private void barEditItemTreeArea_EditValueChanged(object sender, EventArgs e)
{
using (var db = new PUEntitiesOne())
{
var data = db.Educators
.Include(x => x.Area)
.Include(x => x.Faculty)
.ToList();
if (barEditItemTreeArea.EditValue != null)
{
var area = barEditItemTreeArea.EditValue as Area;
data = data
.Where(x => x.areaId == area.id)
.ToList();
}
if (barEditItemTreeListFaculty.EditValue != null)
{
var faculty = barEditItemTreeListFaculty.EditValue as Faculty;
data = data
.Where(x => x.faculcyId == faculty.id)
.ToList();
}
gridControl.DataSource = data;
}
}
private void simpleButtonAddUpdate_Click(object sender, EventArgs e)
{
using (var db = new PUEntitiesOne())
{
if (textEditFaculty.Text == null || textEditFaculty.Text == "")
{
MessageBox.Show("Полето трябва да е запълнено");
return;
}
if (isUpdate)
{
var row = db.Faculties.FirstOrDefault(x => x.id == data.id);
row.facultyName = textEditFaculty.Text;
}
else
{
Faculty f = new Faculty();
f.facultyName = textEditFaculty.Text;
db.Faculties.Add(f);
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
this.Hide();
}
}
private void barEditItemFrom_EditValueChanged(object sender, EventArgs e)
{
using (var db = new PUEntitiesOne())
{
var data = db.Courses.ToList();
DateTime dt = Convert.ToDateTime(barEditItemFrom.EditValue);
DateTime dt2 = Convert.ToDateTime(barEditItemTo.EditValue);
data = data.Where(x => x.courseDate >= dt).ToList();
if (dt > dt2 && dt2 != DateTime.MinValue)
{
MessageBox.Show("Моля въведете валиден период");
barEditItemTo.EditValue = null;
return;
}
if (dt2 >= dt && dt2 != DateTime.MinValue)
{
data = data.Where(x => x.courseDate <= dt2).ToList();
}
if (barEditItemTreeList.EditValue != null)
{
var educator = barEditItemTreeList.EditValue as Educator;
data = data
.Where(x => x.educatorId == educator.id).ToList();
gridControl.DataSource = data;
}
gridControl.DataSource = data;
}
}
public void LoadData()
{
using (var db = new PUEntitiesOne())
{
var data = db.Courses
.Include(x => x.Area)
.Include(x => x.Educator)
.ToList();
var area = db.Areas.ToList();
var educator = db.Educators
.Include(x => x.Area)
.Include(x => x.Faculty)
.ToList();
treeListLookUpEditArea.Properties.DataSource = area;
treeListLookUpEditEducator.Properties.DataSource = educator;
repositoryItemTreeListLookUpEdit1.DataSource = area;
repositoryItemTreeListLookUpEdit2.DataSource = educator;
gridControl.DataSource = data;
bsiRecordsCount.Caption = "RECORDS : " + data.Count;
}
}
private void DeleteOperation()
{
var con = gridView.GetFocusedRow() as Contraget;
DataCheck(con);
DialogResult dialogResult = MessageBox.Show("Желаете ли да изтриете този запис", "Подтвърдете", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
using (var db = new PUEntitiesOne())
{
db.Entry(con).State = System.Data.Entity.EntityState.Deleted;
db.Contragets.Remove(con);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show("Имате съществуващ запис в друга таблица с тези данни");
return;
}
}
}
LoadData();
}
public void LoadData()
{
using (var db = new PUEntitiesOne())
{
var data = db.Areas.ToList();
gridControlArea.DataSource = data;
bsiRecordsCount.Caption = "RECORDS : " + data.Count;
}
}
public void LoadData()
{
using (var db = new PUEntitiesOne())
{
var data = db.Educators.Include(e => e.Area).Include(e => e.Faculty).ToList();
gridControl.DataSource = data;
bsiRecordsCount.Caption = "RECORDS : " + data.Count;
}
}
public XtraFormAddUpdateEducator()
{
InitializeComponent();
this.CenterToScreen();
using (var db = new PUEntitiesOne())
{
treeListLookUpEditArea.Properties.DataSource = db.Areas.ToList();
treeListLookUpEdit1.Properties.DataSource = db.Faculties.ToList();
}
}
public XtraFormCourses()
{
InitializeComponent();
this.CenterToScreen();
using (var db = new PUEntitiesOne())
{
treeListLookUpEdit1.Properties.DataSource = db.Areas.ToList();
treeListLookUpEdit2.Properties.DataSource = db.Educators.ToList();
}
}
public XtraFormAddUpdateContracts()
{
InitializeComponent();
this.CenterToScreen();
using (var db = new PUEntitiesOne())
{
treeListLookUpEditContragent.Properties.DataSource = db.Contragets.ToList();
treeListLookUpEditEducator.Properties.DataSource = db.Educators.ToList();
treeListLookUpEditCourse.Properties.DataSource = db.Courses.ToList();
}
}
public void LoadData()
{
using (var db = new PUEntitiesOne())
{
var data = db.Courses.Include(x => x.Area).Include(x => x.Educator).ToList();
gridControl.DataSource = data;
repositoryItemTreeListLookUpEdit1.DataSource = db.Educators.ToList();
bsiRecordsCount.Caption = "RECORDS : " + data.Count;
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (DataCheck())
{
return;
}
using (var db = new PUEntitiesOne())
{
if (isUpdate)
{
var course = db.Courses.FirstOrDefault(x => x.id == cours.id);
course.protocol = textEditProtocol.Text;
course.courseDate = dateEdit1.DateTime;
course.theme = textEditTheme.Text;
course.anotation = textEditAnotation.Text;
course.totalHour = int.Parse(textEditTotalHour.Text);
course.totalCredit = int.Parse(textEditTotalCredit.Text);
course.areaId = int.Parse(treeListLookUpEdit1.EditValue.ToString());
course.educatorId = int.Parse(treeListLookUpEdit2.EditValue.ToString());
}
else
{
Cours course = new Cours();
course.protocol = textEditProtocol.Text;
course.courseDate = dateEdit1.DateTime;
course.theme = textEditTheme.Text;
course.anotation = textEditAnotation.Text;
course.totalHour = int.Parse(textEditTotalHour.Text);
course.totalCredit = int.Parse(textEditTotalCredit.Text);
course.areaId = int.Parse(treeListLookUpEdit1.EditValue.ToString());
course.educatorId = int.Parse(treeListLookUpEdit2.EditValue.ToString());
db.Courses.Add(course);
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
this.Hide();
}
}
public XtraUserControlSumOfContracts()
{
InitializeComponent();
LoadData();
using (var db = new PUEntitiesOne())
{
var data = db.Contracts
.Include(x => x.Cours)
.Include(x => x.Contraget)
.Include(x => x.Educator)
.ToList();
Sum(data);
}
}
public void LoadData()
{
using (var db = new PUEntitiesOne())
{
//Include го използваме да заредим връзките (lazy loading check!!!)
var data = db.Educators
.Include(e => e.Area)
.Include(e => e.Faculty)
.ToList();
repositoryItemTreeListLookUpEdit1.DataSource = db.Areas.ToList();
repositoryItemTreeListLookUpEdit2.DataSource = db.Faculties.ToList();
gridControl.DataSource = data;
bsiRecordsCount.Caption = "RECORDS : " + data.Count;
}
}
private void Edit()
{
var addUpdate = new XtraFormAreaAddUpdate();
using (var db = new PUEntitiesOne())
{
var area = gridView1.GetFocusedRow() as Area;
DataCheck(area);
addUpdate.Pass(area);
if (addUpdate.ShowDialog() == DialogResult.OK)
{
}
}
}
private void barEditDateFrom_EditValueChanged(object sender, EventArgs e)
{
using (var db = new PUEntitiesOne())
{
var data = db.Courses.ToList();
DateTime dt = Convert.ToDateTime(barEditDateFrom.EditValue);
DateTime dt2 = Convert.ToDateTime(barEditDateTo.EditValue);
//if (barEditItemTreeList.EditValue != null && dt2 != DateTime.MinValue && dt != DateTime.MinValue)
//{
// var get = barEditItemTreeList.EditValue as Area;
// data = data
// .Where(x => x.areaId == get.id).ToList();
// gridControl.DataSource = data;
//}
data = data.Where(a => a.courseDate >= dt).ToList();
if (dt2 < dt && dt2 != DateTime.MinValue)
{
MessageBox.Show("Моля въведете валиден период");
barEditDateTo.EditValue = null;
return;
}
if (dt2 >= dt && dt2 != DateTime.MinValue)
{
data = data.Where(a => a.courseDate <= dt2).ToList();
}
if (barEditItemTreeList.EditValue != null)
{
var get = barEditItemTreeList.EditValue as Area;
data = data
.Where(x => x.areaId == get.id).ToList();
}
gridControl.DataSource = data;
}
}
private void DeleteOperation()
{
var area = gridView1.GetFocusedRow() as Area;
//id = int.Parse(gridView1.GetFocusedRowCellValue("id").ToString());
//int idArea = int.Parse(area.id.ToString());
DataCheck(area);
DialogResult dialogresult = MessageBox.Show("Желаете ли да изтриете този запис", "Подтвърдете", MessageBoxButtons.YesNo);
if (dialogresult == DialogResult.Yes)
{
using (var db = new PUEntitiesOne())
{
//bool educator = db.Educators.Any(x => x.areaId == area.id);
//bool courses = db.Courses.Any(x => x.areaId == area.id);
//if (educator || courses)
//{
// MessageBox.Show("Имате съществуващ запис в друга таблица с тези данни");
// return;
//}
//db.DeleteArea(id);
db.Entry(area).State = System.Data.Entity.EntityState.Deleted;
db.Areas.Remove(area);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show("Имате съществуващ запис в друга таблица с тези данни");
return;
//MessageBox.Show(ex.ToString());
}
LoadData();
}
}
}
private void simpleButtonAddUpdate_Click(object sender, EventArgs e)
{
if (textEditEducatorName.Text == null || textEditEducatorName.Text == "" ||
treeListLookUpEdit1.EditValue == null || treeListLookUpEditArea.EditValue == null)
{
MessageBox.Show("Въведете валидни данни");
return;
}
using (var db = new PUEntitiesOne())
{
if (isUpdate)
{
var edu = db.Educators.FirstOrDefault(x => x.id == data.id);
edu.educatorName = textEditEducatorName.Text;
edu.areaId = int.Parse(treeListLookUpEditArea.EditValue.ToString());
edu.faculcyId = int.Parse(treeListLookUpEdit1.EditValue.ToString());
}
else
{
Educator edu = new Educator();
edu.educatorName = textEditEducatorName.Text;
edu.areaId = int.Parse(treeListLookUpEditArea.EditValue.ToString());
edu.faculcyId = int.Parse(treeListLookUpEdit1.EditValue.ToString());
db.Educators.Add(edu);
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
this.Hide();
}
}
private void simpleButtonContragent_Click(object sender, EventArgs e)
{
using (var db = new PUEntitiesOne())
{
if (textEditName.Text == null || textEditName.Text == "" || textEditEIK.Text == "" || textEditMOL.Text == "")
{
MessageBox.Show("Полето трябва да е запълнено");
return;
}
if (isUpdate)
{
var con = db.Contragets.FirstOrDefault(x => x.id == data.id);
con.name = textEditName.Text;
con.address = textEditAddress.Text;
con.EIK = textEditEIK.Text;
con.MOL = textEditMOL.Text;
}
else
{
Contraget con = new Contraget();
con.name = textEditName.Text;
con.address = textEditAddress.Text;
con.EIK = textEditEIK.Text;
con.MOL = textEditMOL.Text;
db.Contragets.Add(con);
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
this.Hide();
}
}
private void barEditItemFrom_EditValueChanged(object sender, EventArgs e)
{
using (var db = new PUEntitiesOne())
{
var data = db.Contracts
.Include(x => x.Cours)
.Include(x => x.Educator)
.Include(x => x.Contraget)
.ToList();
DateTime dt = Convert.ToDateTime(barEditItemFrom.EditValue);
DateTime dt2 = Convert.ToDateTime(barEditItemTo.EditValue);
data = data.Where(a => a.contractDate >= dt).ToList();
if (dt2 < dt && dt2 != DateTime.MinValue)
{
MessageBox.Show("Моля въведете валиден период");
barEditItemTo.EditValue = null;
return;
}
if (dt2 >= dt && dt2 != DateTime.MinValue)
{
data = data.Where(a => a.contractDate <= dt2).ToList();
}
if (barEditItemTreeList.EditValue != null)
{
var get = barEditItemTreeList.EditValue as Contract;
data = data
.Where(x => x.id == get.id).ToList();
gridControl.DataSource = data;
}
Sum(data);
gridControl.DataSource = data;
}
}
public void LoadData()
{
using (var db = new PUEntitiesOne())
{
var data = db.Contracts.Include(e => e.Educator).Include(x => x.Cours).Include(x => x.Contraget).ToList();
gridControl.DataSource = data;
var contragents = db.Contragets.ToList();
var educators = db.Educators.Include(e => e.Area).Include(e => e.Faculty).ToList();
var courses = db.Courses.Include(e => e.Educator).Include(x => x.Area).ToList();
treeListLookUpEditContragent.Properties.DataSource = contragents;
treeListLookUpEditEducator.Properties.DataSource = educators;
treeListLookUpEditCourse.Properties.DataSource = courses;
repositoryItemTreeListLookUpEdit1.DataSource = contragents;
repositoryItemTreeListLookUpEdit2.DataSource = educators;
repositoryItemTreeListLookUpEdit3.DataSource = courses;
bsiRecordsCount.Caption = "RECORDS : " + data.Count;
}
}
//public bool IsNumber(object value)
//{
// return value is double
// || value is decimal;
//}
//public List<Data> Fill()
//{
// //db.SaveChanges е закоментирано !!!!!!!!
// var listData = new List<Data>();
// foreach (var item in )
// {
// if (IsNumber(item))
// {
// //listData.Add(int.Parse(item.ToString()));
// }
// }
// return listData;
//}
private void simpleButtonAddUpdate_Click(object sender, EventArgs e)
{
//Трябва да се разкоментира и да се направи условие
int contractNum = int.Parse(textEditContractNum.Text);
DateTime contractDate = textEditContractDate.DateTime;
DateTime startDate = dateEditStart.DateTime;
DateTime endDate = dateEditEnd.DateTime;
decimal priceWithCredit = decimal.Parse(textEditWithCredit.EditValue.ToString());
double totalWihtCredit = double.Parse(textEditTotalCredit.Text);
double priceWithoutCredit = double.Parse(textEditWithCredit.EditValue.ToString());
double totalWihtoutCredit = double.Parse(textEditTotalWithoutCredit.EditValue.ToString());
double totalSum = double.Parse(textEditTotalOfContracts.EditValue.ToString());
double DDS = double.Parse(textEditDDS.EditValue.ToString());
double DKPRPS = double.Parse(textEditDKPRPS.EditValue.ToString());
double honorar = double.Parse(textEditHonorar.EditValue.ToString());
double materialExprenses = double.Parse(textEditMaterialExpense.EditValue.ToString());
if (contractNum == 0 || contractDate == DateTime.MinValue || treeListLookUpEditContragent.EditValue != "" ||
treeListLookUpEditCourse.EditValue != "" || treeListLookUpEditEducator.EditValue != "" || startDate == DateTime.MinValue ||
endDate == DateTime.MinValue)
{
MessageBox.Show("Трябва да въведете валидни данни");
return;
}
using (var db = new PUEntitiesOne())
{
if (isUpdate)
{
var row = db.Contracts.FirstOrDefault(x => x.id == contract.id);
row.contractNumber = int.Parse(textEditContractNum.EditValue.ToString());
row.contractDate = textEditContractDate.DateTime;
row.contragentId = int.Parse(treeListLookUpEditContragent.EditValue.ToString());
row.courseId = int.Parse(treeListLookUpEditCourse.EditValue.ToString());
row.educatorId = int.Parse(treeListLookUpEditEducator.EditValue.ToString());
row.startDate = dateEditStart.DateTime;
row.endDate = dateEditEnd.DateTime;
row.priceWithCredit = decimal.Parse(textEditWithCredit.EditValue.ToString());
row.totalWithCredit = int.Parse(textEditTotalCredit.EditValue.ToString());
row.priceWithoutCredit = decimal.Parse(textEditWithoutCredit.EditValue.ToString());
row.totalWithoutCredit = int.Parse(textEditTotalWithoutCredit.EditValue.ToString());
row.sumOfContract = int.Parse(textEditTotalOfContracts.EditValue.ToString());
row.DDS = int.Parse(textEditDDS.EditValue.ToString());
row.deductionsForPU = int.Parse(textEditPU.EditValue.ToString());
row.deductionsForDKPRPS = int.Parse(textEditDKPRPS.EditValue.ToString());
row.remunerationFee = int.Parse(textEditHonorar.EditValue.ToString());
row.materialCost = int.Parse(textEditMaterialExpense.EditValue.ToString());
}
else
{
Contract con = new Contract();
con.contractNumber = int.Parse(textEditContractNum.EditValue.ToString());
con.contractDate = textEditContractDate.DateTime;
con.contragentId = int.Parse(treeListLookUpEditContragent.EditValue.ToString());
con.courseId = int.Parse(treeListLookUpEditCourse.EditValue.ToString());
con.educatorId = int.Parse(treeListLookUpEditEducator.EditValue.ToString());
con.startDate = dateEditStart.DateTime;
con.endDate = dateEditEnd.DateTime;
con.priceWithCredit = decimal.Parse(textEditWithCredit.EditValue.ToString());
con.totalWithCredit = int.Parse(textEditTotalCredit.EditValue.ToString());
con.priceWithoutCredit = decimal.Parse(textEditWithoutCredit.EditValue.ToString());
con.totalWithoutCredit = int.Parse(textEditTotalWithoutCredit.EditValue.ToString());
con.sumOfContract = int.Parse(textEditTotalOfContracts.EditValue.ToString());
con.DDS = int.Parse(textEditDDS.EditValue.ToString());
con.deductionsForPU = int.Parse(textEditPU.EditValue.ToString());
con.deductionsForDKPRPS = int.Parse(textEditDKPRPS.EditValue.ToString());
con.remunerationFee = int.Parse(textEditHonorar.EditValue.ToString());
con.materialCost = int.Parse(textEditMaterialExpense.EditValue.ToString());
db.Contracts.Add(con);
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
this.Hide();
}
}
