private static void Addsp()
{
try
{
ProgramScheduled e = new ProgramScheduled()
{
ScheduledProgramID = "A123", ProgramName = "BCA", Location = "Delhi", StartDate = Convert.ToDateTime("12-April-2021"), EndDate = Convert.ToDateTime("17,April,2021"), SessionsPerWeek = 4
};
ProgramScheduled e1 = new ProgramScheduled()
{
ScheduledProgramID = "B123", ProgramName = "Bsc", Location = "Dehradun", StartDate = Convert.ToDateTime("12 /April/ 2021"), EndDate = Convert.ToDateTime("17 /April / 2021"), SessionsPerWeek = 4
};
ProgramsScheduledBL bl = new ProgramsScheduledBL();
bool aded = bl.Add(e);
aded = bl.Add(e1);
if (aded)
{
Console.WriteLine("added succesfully");
}
}
catch (UniversityException e)
{
Console.WriteLine(e.Message);
}
}
private void program_click(object sender, RoutedEventArgs e1)
{
try
{
ProgramScheduled program;
ProgramsScheduledBL blObj = new ProgramsScheduledBL();
List <ProgramScheduled> list = new List <ProgramScheduled>();
list = blObj.GetAll();
foreach (ProgramScheduled e in list)
{
program = new ProgramScheduled()
{
ScheduledProgramID = e.ScheduledProgramID,
ProgramName = e.ProgramName,
Location = e.Location,
StartDate = e.StartDate,
EndDate = e.EndDate,
SessionsPerWeek = e.SessionsPerWeek
};
}
lst_Of_Courses.ItemsSource = list;
}
catch (UniversityException ex)
{
MessageBox.Show(ex.Message);
}
}
public bool Update(string cuspid, ProgramScheduled e)
{
if (e.ScheduledProgramID.Length > 6)
{
throw new UniversityException("Characters are Exceeded in ID Field");
}
if (e.ProgramName.Length > 20)
{
throw new UniversityException("Characters are Exceeded in Program Name Field");
}
if (e.ProgramName.Length > 20)
{
throw new UniversityException("Characters are Exceeded in Location Field");
}
if (e.SessionsPerWeek > 6)
{
throw new UniversityException("Sessions Per Week Cannot be more than 6");
}
bool updt = false;
ProgramsScheduledDAL dal = new ProgramsScheduledDAL();
dal.Update(e.ScheduledProgramID, e.ProgramName, e.Location, e.StartDate, e.EndDate, e.SessionsPerWeek, cuspid);
updt = true;
if (updt == false)
{
throw new UniversityException("Updation Failed");
}
return(updt);
}
public bool Add(ProgramScheduled e)
{
bool add = false;
if (e.ScheduledProgramID.Length > 6)
{
throw new UniversityException("Characters are Exceeded in ID Field");
}
if (e.ProgramName.Length > 20)
{
throw new UniversityException("Characters are Exceeded in Program Name Field");
}
if (e.ProgramName.Length > 20)
{
throw new UniversityException("Characters are Exceeded in Location Field");
}
if (e.SessionsPerWeek > 6)
{
throw new UniversityException("Sessions Per Week Cannot be more than 6");
}
// DAL object will take programoffered
ProgramsScheduledDAL dal = new ProgramsScheduledDAL();
dal.Add(e.ScheduledProgramID, e.ProgramName, e.Location, e.StartDate, e.EndDate, e.SessionsPerWeek);
add = true;
if (add == false)
{
throw new UniversityException("addtion Failed ");
}
return(add);
}
public MainWindow()
{
InitializeComponent();
//All the programs schedule will be initialized with the opening
try
{
ProgramScheduled program;
ProgramsScheduledBL blObj = new ProgramsScheduledBL();
List <ProgramScheduled> list = new List <ProgramScheduled>();
list = blObj.GetAll();
foreach (ProgramScheduled e in list)
{
program = new ProgramScheduled()
{
ScheduledProgramID = e.ScheduledProgramID,
ProgramName = e.ProgramName,
Location = e.Location,
StartDate = e.StartDate,
EndDate = e.EndDate,
SessionsPerWeek = e.SessionsPerWeek
};
}
lst_Of_Courses.ItemsSource = list;
}
catch (UniversityException ex)
{
MessageBox.Show(ex.Message);
}
}
private void update_click(object sender, RoutedEventArgs e)
{
try
{
ProgramScheduled program = new ProgramScheduled();
ProgramsScheduledBL bL = new ProgramsScheduledBL();
program.ScheduledProgramID = txt_schId.Text;
program.ProgramName = txt_pname.Text;
program.Location = txt_loc.Text;
program.StartDate = Convert.ToDateTime(DP_sdate.Text);
program.EndDate = Convert.ToDateTime(DP_edate.Text);
program.SessionsPerWeek = Convert.ToInt32(txt_session.Text);
bool updated = bL.Update(program.ScheduledProgramID, program);
if (updated)
{
MessageBox.Show("Updated Succesfully");
}
}
catch (UniversityException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void add_click(object sender, RoutedEventArgs e)
{
try
{
ProgramScheduled program = new ProgramScheduled();
ProgramsScheduledBL bL = new ProgramsScheduledBL();
if (string.IsNullOrWhiteSpace(txt_schId.Text))
{
throw new UniversityException("Program Id field can not be Empty");
}
if (string.IsNullOrWhiteSpace(txt_pname.Text))
{
throw new UniversityException("Program Name field can not be Empty");
}
if (string.IsNullOrWhiteSpace(txt_loc.Text))
{
throw new UniversityException("Location field can not be Empty");
}
if (string.IsNullOrWhiteSpace(DP_sdate.Text))
{
throw new UniversityException("StartDate field can not be Empty");
}
if (string.IsNullOrWhiteSpace(DP_edate.Text))
{
throw new UniversityException("EndDate field can not be Empty");
}
if (string.IsNullOrWhiteSpace(txt_session.Text))
{
throw new UniversityException("Session field can not be Empty");
}
program.ScheduledProgramID = txt_schId.Text;
program.ProgramName = txt_pname.Text;
program.Location = txt_loc.Text;
program.StartDate = Convert.ToDateTime(DP_sdate.Text);
program.EndDate = Convert.ToDateTime(DP_edate.Text);
program.SessionsPerWeek = Convert.ToInt32(txt_session.Text);
bool added = bL.Add(program);
if (added)
{
MessageBox.Show("Added Succesfully");
}
}
catch (UniversityException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private static void UpdateSp()
{
try
{
ProgramScheduled e = new ProgramScheduled()
{
ScheduledProgramID = "A123", ProgramName = "BCA", Location = "Bangalore", StartDate = Convert.ToDateTime("12-April-2021"), EndDate = Convert.ToDateTime("17,April,2021"), SessionsPerWeek = 4
};
ProgramsScheduledBL bl = new ProgramsScheduledBL();
bool updtd = bl.Update("A123", e);
if (updtd)
{
Console.WriteLine("updated succesfully");
}
}
catch (UniversityException ex)
{
Console.WriteLine(ex.Message);
}
}
private static void DeleteSp()
{
try
{
ProgramScheduled e = new ProgramScheduled();
ProgramsScheduledBL bl = new ProgramsScheduledBL();
bool dltd = bl.Delete(e, "A123");
if (dltd)
{
Console.WriteLine("Deleted Succesfully");
}
else
{
Console.WriteLine("not succesfully deleted");
}
}
catch (UniversityException ex)
{
Console.WriteLine(ex.Message);
}
}
