protected void rptHoursList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
HiddenField hiddenKeyField = (HiddenField)e.Item.FindControl("hiddenKey");
TextBox txtName = (TextBox)e.Item.FindControl("txtName");
TextBox txtHours = (TextBox)e.Item.FindControl("txtHours");
var hoursModel = new HoursOfOperation();
switch (e.CommandName)
{
case "Update":
hoursModel.Update(Convert.ToInt32(hiddenKeyField.Value),
txtName.Text, txtHours.Text);
break;
case "Delete":
hoursModel.Remove(Convert.ToInt32(hiddenKeyField.Value));
break;
case "Insert":
hoursModel.Add(txtName.Text, txtHours.Text);
break;
}
rptHoursList.DataSource = hoursModel.Days;
rptHoursList.DataBind();
}
public async Task Update(HoursOfOperation entity)
{
using (var conn = OpenConnection()) {
using (var t = conn.BeginTransaction()) {
await conn.ExecuteAsync(
@"update hours_of_operations set user_id = @UserId where id = @Id",
entity
);
await conn.ExecuteAsync(
@"delete from hours_of_operation_days where hours_of_operation_id = @Id",
entity
);
var days = entity.Days.Select(d => new HoursOfOperationDayModel {
Id = d.Id,
HoursOfOperationId = entity.Id,
Day = d.Day,
Open = d.Day,
Close = d.Close,
Enabled = d.Enabled
});
await conn.ExecuteAsync(
@"insert into hours_of_operation_days (id, hours_of_operation_id, day, open, close, enabled) values (@Id, @HoursOfOperationId, @Day, @Open, @Close, @Enabled);",
days
);
t.Commit();
}
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
HoursOfOperation hoursOfOperation = await db.HoursOfOperations.FindAsync(id);
db.HoursOfOperations.Remove(hoursOfOperation);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
protected void Page_Load(object sender, EventArgs e)
{
// Load Hours of Operation Model
var hoursModel = new HoursOfOperation();
hoursModel.LoadData();
rptHoursOfOperation.DataSource = hoursModel.Days;
rptHoursOfOperation.DataBind();
}
public async Task <ActionResult> Edit([Bind(Include = "HoursOfOperationID,DayOfWeek,TimeOpen,LocationID")] HoursOfOperation hoursOfOperation)
{
if (ModelState.IsValid)
{
db.Entry(hoursOfOperation).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.LocationID = new SelectList(db.Locations, "LocationID", "StreetAddress1", hoursOfOperation.LocationID);
return(View(hoursOfOperation));
}
// GET: HoursOfOperations/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HoursOfOperation hoursOfOperation = await db.HoursOfOperations.FindAsync(id);
if (hoursOfOperation == null)
{
return(HttpNotFound());
}
return(View(hoursOfOperation));
}
// GET: HoursOfOperations/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HoursOfOperation hoursOfOperation = await db.HoursOfOperations.FindAsync(id);
if (hoursOfOperation == null)
{
return(HttpNotFound());
}
ViewBag.LocationID = new SelectList(db.Locations, "LocationID", "StreetAddress1", hoursOfOperation.LocationID);
return(View(hoursOfOperation));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
Response.Redirect("/Admin/Login.aspx");
}
if (IsPostBack == false)
{
var hoursModel = new HoursOfOperation();
hoursModel.LoadData();
rptHoursList.DataSource = hoursModel.Days;
rptHoursList.DataBind();
}
}
public async Task Delete(HoursOfOperation entity)
{
using (var conn = OpenConnection()) {
using (var t = conn.BeginTransaction()) {
await conn.ExecuteAsync(
@"delete from hours_of_operation_days where hours_of_operation_id = @Id",
entity
);
await conn.ExecuteAsync(
@"delete from hours_of_operations where id = @Id",
entity
);
t.Commit();
}
}
}
public static bool Save(DayCarePL.HoursOfOperationProperties objHoursOfOperation)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clHoursOfOperation, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
clConnection.DoConnection();
DayCareDataContext db = new DayCareDataContext();
HoursOfOperation DBHourOfOeration = null;
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clHoursOfOperation, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
if (objHoursOfOperation.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
DBHourOfOeration = new HoursOfOperation();
DBHourOfOeration.Id = Guid.NewGuid();
}
else
{
DBHourOfOeration = db.HoursOfOperations.SingleOrDefault(id => id.Id.Equals(objHoursOfOperation.Id));
}
DBHourOfOeration.LastModifiedById = objHoursOfOperation.LastModifiedById;
DBHourOfOeration.LastModifiedDatetime = DateTime.Now;
DBHourOfOeration.Day = objHoursOfOperation.Day;
DBHourOfOeration.DayIndex = objHoursOfOperation.DayIndex;
DBHourOfOeration.OpenTime = objHoursOfOperation.OpenTime;
DBHourOfOeration.CloseTime = objHoursOfOperation.CloseTime;
DBHourOfOeration.Comments = objHoursOfOperation.Comments;
DBHourOfOeration.SchoolId = objHoursOfOperation.SchoolId;
if (objHoursOfOperation.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
{
db.HoursOfOperations.InsertOnSubmit(DBHourOfOeration);
}
db.SubmitChanges();
return(true);
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clHoursOfOperation, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Load FAQ Model
var faqModel = new FAQs();
faqModel.LoadData();
rptLaundryFaqs.DataSource = faqModel.FaqList;
rptLaundryFaqs.DataBind();
// Load Hours of Operation Model
var hoursModel = new HoursOfOperation();
hoursModel.LoadData();
rptHoursOfOperation.DataSource = hoursModel.Days;
rptHoursOfOperation.DataBind();
// Load Pricing
var pricingModel = new Models.Pricing();
pricingModel.LoadData();
if (pricingModel.Prices.Count > 0)
{
int firstIndex = Convert.ToInt32(Math.Ceiling((double)pricingModel.Prices.Count / 2));
var firstGroupPricing = pricingModel.Prices.GetRange(0, firstIndex);
rptPricingLeft.DataSource = firstGroupPricing;
rptPricingLeft.DataBind();
if (firstIndex < pricingModel.Prices.Count)
{
var secondGroupPricing = pricingModel.Prices.GetRange(firstIndex, pricingModel.Prices.Count - firstIndex);
rptPricingRight.DataSource = secondGroupPricing;
rptPricingRight.DataBind();
}
}
}
public ActionResult HoursOfOperation(HoursOfOperationViewModel viewModel)
{
var bar = _context.Bars.SingleOrDefault(c => c.Id == viewModel.Bar.Id);
foreach (var hours in _context.HoursOfOperations)
{
if (bar.Id == hours.BarId)
{
_context.HoursOfOperations.Remove(hours);
}
}
bar.HoursOfOperations.Clear();
var hoursOfOpperationSunday = new HoursOfOperation
{
BarId = bar.Id,
DayOfWeekId = 1,
OpenTime = viewModel.SundayOpen,
CloseTime = viewModel.SundayClose
};
_context.HoursOfOperations.Add(hoursOfOpperationSunday);
bar.HoursOfOperations.Add(hoursOfOpperationSunday);
var hoursOfOpperationMonday = new HoursOfOperation
{
BarId = bar.Id,
DayOfWeekId = 2,
OpenTime = viewModel.MondayOpen,
CloseTime = viewModel.MondayClose
};
_context.HoursOfOperations.Add(hoursOfOpperationMonday);
bar.HoursOfOperations.Add(hoursOfOpperationMonday);
var hoursOfOpperationTuesday = new HoursOfOperation
{
BarId = bar.Id,
DayOfWeekId = 3,
OpenTime = viewModel.TuesdayOpen,
CloseTime = viewModel.TuesdayClose
};
_context.HoursOfOperations.Add(hoursOfOpperationTuesday);
bar.HoursOfOperations.Add(hoursOfOpperationTuesday);
var hoursOfOpperationWednesday = new HoursOfOperation
{
BarId = bar.Id,
DayOfWeekId = 4,
OpenTime = viewModel.WednesdayOpen,
CloseTime = viewModel.WednesdayClose
};
_context.HoursOfOperations.Add(hoursOfOpperationWednesday);
bar.HoursOfOperations.Add(hoursOfOpperationWednesday);
var hoursOfOpperationThursday = new HoursOfOperation
{
BarId = bar.Id,
DayOfWeekId = 5,
OpenTime = viewModel.ThursdayOpen,
CloseTime = viewModel.ThursdayClose
};
_context.HoursOfOperations.Add(hoursOfOpperationThursday);
bar.HoursOfOperations.Add(hoursOfOpperationThursday);
var hoursOfOpperationFriday = new HoursOfOperation
{
BarId = bar.Id,
DayOfWeekId = 6,
OpenTime = viewModel.FridayOpen,
CloseTime = viewModel.FridayClose
};
_context.HoursOfOperations.Add(hoursOfOpperationFriday);
bar.HoursOfOperations.Add(hoursOfOpperationFriday);
var hoursOfOpperationSaturday = new HoursOfOperation
{
BarId = bar.Id,
DayOfWeekId = 7,
OpenTime = viewModel.SaturdayOpen,
CloseTime = viewModel.SaturdayClose
};
_context.HoursOfOperations.Add(hoursOfOpperationSaturday);
bar.HoursOfOperations.Add(hoursOfOpperationSaturday);
_context.SaveChanges();
return(RedirectToAction("BarDashboard"));
}
public void DefaultDaysAreSet()
{
var hours = HoursOfOperation.Create(Guid.NewGuid());
Assert.AreNotEqual(hours.Days.Count, 0);
}
