/// <summary>
/// Obtiene la fecha de cierre de algun Sales Room
/// </summary>
/// <param name="salesRoomType"></param>
/// <param name="salesRoom"></param>
/// <returns> DateTime </returns>
/// <history>
/// [vipacheco] 19/Abril/2016 Created
/// [michan] 07/Junio/2016 Modified Se agregó la fecha de cierre de CxC
/// </history>
public static DateTime?GetCloseSalesRoom(EnumEntities salesRoomType, string salesRoom)
{
using (var dbContext = new IMEntities(ConnectionHelper.ConnectionString()))
{
SalesRoom _salesRoom;
switch (salesRoomType)
{
case EnumEntities.Shows:
_salesRoom = dbContext.SalesRooms.Where(x => x.srID == salesRoom).SingleOrDefault();
return(_salesRoom.srShowsCloseD);
case EnumEntities.MealTickets:
_salesRoom = dbContext.SalesRooms.Where(x => x.srID == salesRoom).SingleOrDefault();
return(_salesRoom.srMealTicketsCloseD);
case EnumEntities.Sales:
_salesRoom = dbContext.SalesRooms.Where(x => x.srID == salesRoom).SingleOrDefault();
return(_salesRoom.srSalesCloseD);
case EnumEntities.GiftsReceipts:
_salesRoom = dbContext.SalesRooms.Where(x => x.srID == salesRoom).SingleOrDefault();
return(_salesRoom.srGiftsRcptCloseD);
case EnumEntities.CxC:
_salesRoom = dbContext.SalesRooms.Where(x => x.srID == salesRoom).SingleOrDefault();
return(_salesRoom.srCxCCloseD);
default:
return(null);
}
}
}
static internal void LoadDataFromEntity(EnumEntities enEntity)
{
switch (enEntity)
{
case 0: OrgaDatabase.LoadQueryOf((int)EnumEntities.Customer); break;
}
}
/// <summary>
/// Función para actualizar los controles DataPicker del UI
/// </summary>
/// <history>
/// [vipacheco] 02/03/2016 Created
/// </history>
private void updateDate(EnumEntities salesRoomType, DateTime?dateUpdate)
{
switch (salesRoomType)
{
case EnumEntities.Shows:
dtpCloseShows.Value = _serverDate.AddDays(-1);
dtpCloseShowsLast.Value = dateUpdate;
break;
case EnumEntities.MealTickets:
dtpCloseMealTicket.Value = _serverDate.AddDays(-1);
dtpCloseMealTicketsLast.Value = dateUpdate;
break;
case EnumEntities.Sales:
dtpCloseSales.Value = _serverDate.AddDays(-1);
dtpCloseSalesLast.Value = dateUpdate;
break;
case EnumEntities.GiftsReceipts:
dtpCloseGiftsReceipts.Value = _serverDate.AddDays(-1);
dtpCloseGiftsReceiptsLast.Value = dateUpdate;
break;
}
UIHelper.ShowMessage("Closing process completed.", MessageBoxImage.Information, salesRoomType.ToString() + " Process");
}
/// <summary>
/// Funcion para cerrar una entidad de la sala de ventas
/// </summary>
/// <param name="salesRoomType"> Tipo de entidad </param>
/// <history>
/// [vipacheco] 01/03/2016 Createad
/// </history>
public static void SetCloseSalesRoom(EnumEntities salesRoomType, string salesRoom, DateTime?dateClose)
{
using (var dbContext = new IMEntities(ConnectionHelper.ConnectionString()))
{
switch (salesRoomType)
{
case EnumEntities.Shows:
dbContext.USP_OR_CloseShows(salesRoom, dateClose);
break;
case EnumEntities.MealTickets:
dbContext.USP_OR_CloseMealTickets(salesRoom, dateClose);
break;
case EnumEntities.Sales:
dbContext.USP_OR_CloseSales(salesRoom, dateClose);
break;
case EnumEntities.GiftsReceipts:
dbContext.USP_OR_CloseGiftsReceipts(salesRoom, dateClose);
break;
}
}
}
/// <summary>
/// Funcion para cerrar una sala de ventas segun el tipo requerido.
/// </summary>
/// <param name="_closeType"> Tipo de Cierre </param>
/// <param name="_dateClose"> Date de cierre </param>
/// <param name="_dateCloseLast">Date del ultimo cierre registrado </param>
/// <history>
/// [vipacheco] 01/03/2016 Created
/// </history>
private void CloseSalesRoom(EnumEntities _closeType, ref DateTimePicker _dateClose, DateTimePicker _dateCloseLast)
{
//verificacion de fechas no mayores a la actual
if (_dateClose.Value.Value > _serverDate)
{
UIHelper.ShowMessage("Closing date con not be greater than today.", MessageBoxImage.Exclamation);
return;
}
//Se pregunta si en verdad desea realizar el cierre
if (UIHelper.ShowMessage("Are you sure you want to close all " + _closeType.ToString() + " until " + _dateClose.Text + "? You wont't be able to modify that " + _closeType.ToString() + " anymore.",
MessageBoxImage.Question) == MessageBoxResult.Cancel)
{
return;
}
//Realizamos el cierre
BRSalesRooms.SetCloseSalesRoom(_closeType, Context.User.SalesRoom.srID, _dateClose.Value);
//Guardamos la accion en el historico de sala de ventas
BRSalesRoomsLogs.SaveSalesRoomLog(Context.User.SalesRoom.srID, Convert.ToInt16(Context.User.SalesRoom.srHoursDif), Context.User.User.peID);
//Actualizamos datos de UI
updateDate(_closeType, _dateClose.Value);
}
/// <summary>
/// Valida que una fecha de una entidad no este en una fecha cerrada con 7 dias
/// </summary>
/// <param name="pEntity"></param>
/// <param name="pDate"></param>
/// <param name="pDateClose"></param>
/// <param name="pDescription"></param>
/// <param name="pCondition"></param>
/// <returns></returns>
/// <history>
/// [vipacheco] 08/Julio/2016 Created
/// [aalcocer] 12/08/2016 Modified. Se valida si el parametro pDate tiene valor
/// </history>
public static bool ValidateCloseDate(EnumEntities pEntity, ref DateTimePicker pDate, DateTime pDateClose, string pDescription = "", bool pCondition = true)
{
int diffDay = 0;
string items = "", description = "";
if (pDate.Value == null)
{
return(true);
}
// Dias transcurridos
diffDay = (pDateClose - pDate.Value.Value.Date).Days;
// si la condicion es valida y el editor esta habilitado
if (pCondition && pDate.IsEnabled)
{
items = EnumToListHelper.GetEnumDescription(pEntity);
// si no se envio una descripcion
if (pDescription == "")
{
switch (pEntity)
{
case EnumEntities.Shows:
description = "Show";
break;
case EnumEntities.MealTickets:
description = "Meal Ticket";
break;
case EnumEntities.Sales:
description = "Sale";
break;
case EnumEntities.GiftsReceipts:
description = "Gift Receipt";
break;
}
}
else
{
description = pDescription;
}
// validamos que la fecha no sea mayor a la fecha actual
if (pDate.Value.Value.Date > BRHelpers.GetServerDate())
{
UIHelper.ShowMessage(description + " can not be after today.", System.Windows.MessageBoxImage.Exclamation, "Intelligence Marketing");
pDate.Focus();
return(false);
}
// validamos que la fecha no sea menor o igual a la fecha de cierre y no sea mayor o igual a 7 dias y si viene de Show
else if (pEntity == EnumEntities.Shows)
{
pDate.Focus();
return(ValidateCloseDate7Days(pDate.Value.Value.Date, pDateClose.Date, diffDay));
}
// validamos que la fecha no sea menor o igual a la fecha de cierre
else if (pDate.Value.Value.Date <= pDateClose.Date)
{
UIHelper.ShowMessage("It's not allowed to make " + items + " for a closed date.", System.Windows.MessageBoxImage.Exclamation);
pDate.Focus();
return(false);
}
}
return(true);
}
