private bool Create()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Education_Program Newdata = new Education_Program();
if (GoCheck.IsEmpityOrMaxChar(textBoxName.Text) && GoCheck.IsStringValue(textBoxName.Text))
{
Newdata.Name_edu = GoCheck.ClearValue;
}
else
{
return(false);
}
if (GoCheck.isPrice(textBoxPrice.Text))
{
Newdata.Price = Convert.ToDecimal(GoCheck.ClearValue);
Newdata.Status_edu = true;
}
else
{
return(false);
}
db.Education_Program.Add(Newdata);
return(GoCheck.isSave(db.SaveChanges()));
}
}
private bool UpdateData()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Education_Program UpdatedData = db.Education_Program.Where(x => x.ID_edu == SelectedID).FirstOrDefault();
if (GoCheck.IsEmpityOrMaxChar(textBoxName.Text) && GoCheck.IsStringValue(textBoxName.Text))
{
UpdatedData.Name_edu = GoCheck.ClearValue;
}
else
{
return(false);
}
if (GoCheck.isPrice(textBoxPrice.Text))
{
UpdatedData.Price = Convert.ToDecimal(GoCheck.ClearValue);
}
else
{
return(false);
}
return(GoCheck.isSave(db.SaveChanges()));
}
}
private void CreateEducationProgram()
{
int affectedrows = 0;
using (CodeAcademyEntities1 db = new CodeAcademyEntities1())
{
Education_Program EP = new Education_Program
{
Name = EPNameTxt.Text,
Price = Convert.ToInt32(EPPriceTxt.Text),
Status = true
};
db.Education_Programs.Add(EP);
affectedrows = db.SaveChanges();
}
if (affectedrows > 0)
{
MessageBox.Show("Program created");
ResetInputs();
dgvPrograms.Rows.Clear();
}
else
{
MessageBox.Show("Program could not be created");
return;
}
}
private bool Delete()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Education_Program DeletedData = db.Education_Program.Where(x => x.ID_edu == SelectedID).FirstOrDefault();
string Dialog = "Seçilmiş " + DeletedData.Name_edu + " təhsil proqramını silmək istəyirsiniz?";
DialogResult result = MessageBox.Show(Dialog, "Silmək Sorğusu!", MessageBoxButtons.YesNo);
if (DialogResult.Yes != result)
{
MessageBox.Show("Seçilmiş " + DeletedData.Name_edu + " təhsil proqramı Silinmədi.", "Silmək Sorğusuna cavab");
return(false);
}
else
{
DeletedData.Status_edu = false;
return(GoCheck.isDeleted(db.SaveChanges()));
}
}
}
