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