OPENINGHOURS
public static DataTable GetOpeningHoursFromBranch(string branchname) { try { int brid = BranchDAL.GetBranchID(branchname); string sql = "SELECT * FROM OPENINGHOURS WHERE BranchId=@brid"; CommandParameterList localparams = new CommandParameterList(); localparams.Add(new CommandParameter("@brid", brid, DbParameterTypes.Int32, ParameterDirection.Input)); localDAC.LocalParameters = localparams; return localDAC.ExecuteDT(sql, AssignmentTypes.SqlStatement, "OPENINGHOURS"); } catch (SQLDacException ex) { throw new BranchDALException(ex.Message); } catch (Exception ex) { throw new BranchDALException(ex.Message); } }
public static DataTable GetOpeningHoursFromBranch(string branchname) { try { return BranchDAL.GetOpeningHoursFromBranch(branchname); } catch (BranchDALException ex) { throw new BranchBLLException(ex.Message); } catch (Exception ex) { throw new BranchBLLException(ex.Message); } }
DataTable localDT = new DataTable("OpeningHours"); localDT = BranchDAL.GetOpeningHoursFromBranch(textBoxBranchName.Text); dataGridViewOpeningHours.DataSource = localDT; dataGridViewOpeningHours.Refresh();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)