/// <summary>
/// Abre la ventana detalle en modo "detalle" o "edición" dependiendo de sus permisos
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// [emoguel] created 19/05/2016
/// </history>
private void Cell_DoubleClick(object sender, RoutedEventArgs e)
{
MembershipGroup membershipGroup = (MembershipGroup)dgrMembershipGroup.SelectedItem;
frmMembershipGroupDetail frmMembershipGroup = new frmMembershipGroupDetail();
frmMembershipGroup.Owner = this;
frmMembershipGroup.oldMembershipGroup = membershipGroup;
frmMembershipGroup.enumMode = EnumMode.Edit;
if (frmMembershipGroup.ShowDialog() == true)
{
List <MembershipGroup> lstMembershipGroups = (List <MembershipGroup>)dgrMembershipGroup.ItemsSource;
int nIndex = 0;
if (ValidateFilter(frmMembershipGroup.membershipGroup)) //Verificamos que cumpla con los filtros
{
ObjectHelper.CopyProperties(membershipGroup, frmMembershipGroup.membershipGroup); //Actualizamos los datos del registro
lstMembershipGroups.Sort((x, y) => string.Compare(x.mgN, y.mgN)); //Ordenamos la lista
nIndex = lstMembershipGroups.IndexOf(membershipGroup); //Obtenemos la posición del registro
}
else
{
lstMembershipGroups.Remove(membershipGroup); //Quitamos el registro
}
dgrMembershipGroup.Items.Refresh(); //Actualizamos la vista
GridHelper.SelectRow(dgrMembershipGroup, nIndex); //Seleccionamos el registro
StatusBarReg.Content = lstMembershipGroups.Count + " Membership Groups"; //Actualizamos el contador
}
}
/// <summary>
/// Valida que un membershipGroup cumpla con los filtros actuales
/// </summary>
/// <param name="membershipGroup">Objeto validar</param>
/// <returns>True. si cumple | False. No cumple</returns>
/// <history>
/// [emoguel] created 19/05/2016
/// </history>
private bool ValidateFilter(MembershipGroup membershipGroup)
{
if (_nStatus != -1)
{
if (membershipGroup.mgA != Convert.ToBoolean(_nStatus))//Filtro por estatus
{
return(false);
}
}
if (!string.IsNullOrWhiteSpace(_memberShipGroupFilter.mgID))//FIltro por ID
{
if (membershipGroup.mgID != _memberShipGroupFilter.mgID)
{
return(false);
}
}
if (!string.IsNullOrWhiteSpace(_memberShipGroupFilter.mgN))//Filtro por estatus
{
if (!membershipGroup.mgN.Contains(_memberShipGroupFilter.mgN, StringComparison.OrdinalIgnoreCase))
{
return(false);
}
}
return(true);
}
public HttpResponseMessage UpdateMembershipGroup(MembershipGroup updatedRecord)
{
try
{
if (updatedRecord == null)
{
return(new HttpResponseMessage(HttpStatusCode.BadRequest));
}
// Create the entity record in the Azure SQL DB:
int updateResult = _membershipGroupWorker.UpdateCreate(updatedRecord);
if (updateResult > 0)
{
return(new HttpResponseMessage(HttpStatusCode.OK));
}
// Existed already:
else if (updateResult == 0)
{
return(new HttpResponseMessage(HttpStatusCode.OK));
}
return(new HttpResponseMessage(HttpStatusCode.OK));
}
catch (Exception e)
{
return(new HttpResponseMessage(HttpStatusCode.BadRequest));
}
}
public virtual ActionResult IsNameAvailable(string name)
{
var membershipGroup = new MembershipGroup()
{
Membership = Membership, Name = name
}.AsActual();
if (membershipGroup != null)
{
return(Json("The name is duplicate.".Localize(), JsonRequestBehavior.AllowGet));
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Agrega|Actualiza un membershipGroup
/// Asigna|Desasina una lista de membershiptype
/// </summary>
/// <param name="membershipGroup">Objeto a guardar</param>
/// <param name="lstAdd">lista a asignar</param>
/// <param name="blnUpdate">True. Actualiza | False. Inserta</param>
/// <returns>0. No se pudo guardar | >1. Se guardó correctamente | -1. Existe un registro con el mismo ID</returns>
/// <history>
/// [emoguel] created 19/05/2016
/// </history>
public async static Task <int> SaveMembershipGroup(MembershipGroup membershipGroup, List <MembershipType> lstAdd, bool blnUpdate)
{
return(await Task.Run(() =>
{
using (var dbContext = new IMEntities(ConnectionHelper.ConnectionString()))
{
using (var transaccion = dbContext.Database.BeginTransaction(IsolationLevel.Serializable))
{
try
{
#region Update
if (blnUpdate)
{
dbContext.Entry(membershipGroup).State = System.Data.Entity.EntityState.Modified;
}
#endregion
#region Add
else
{
if (dbContext.MembershipsGroups.Where(mg => mg.mgID == membershipGroup.mgID).FirstOrDefault() != null)
{
return -1;
}
else
{
dbContext.MembershipsGroups.Add(membershipGroup);
}
}
#endregion
#region membership a asignar
dbContext.MembershipTypes.AsEnumerable().Where(mt => lstAdd.Any(mtt => mtt.mtID == mt.mtID)).ToList().ForEach(mt =>
{
mt.mtGroup = membershipGroup.mgID;
});
#endregion
int nRes = 0;
nRes = dbContext.SaveChanges();
transaccion.Commit();
return nRes;
}
catch
{
transaccion.Rollback();
return 0;
}
}
}
}));
}
public virtual ActionResult Create(MembershipGroup model, string @return)
{
JsonResultData data = new JsonResultData(ModelState);
if (ModelState.IsValid)
{
data.RunWithTry((resultData) =>
{
model.Membership = Membership;
_manager.Add(model);
resultData.RedirectUrl = @return;
});
}
return(Json(data));
}
private void createButton3_Click(object sender, EventArgs e)
{
Doc doc = new Doc();
Properties props = Properties.FromDoc(doc, true);
List <Group> groups = new List <Group>();
for (int i = 1; i < 4; i++)
{
groups.Add(props.AddGroup("Layer " + i.ToString(), null));
}
// membership policies are simple to use but limited in scope
MembershipGroup alloff = props.AddMembershipGroup();
alloff.Policy = MembershipGroup.PolicyEnum.AllOff;
alloff.PolicyGroups = groups;
// membership visibility expressions are more complex but more powerful
MembershipGroup mgve = props.AddMembershipGroup();
ArrayAtom ve = mgve.MakeVisibilityExpression(MembershipGroup.LogicEnum.Or, groups);
mgve.EntryVE = mgve.MakeVisibilityExpression(MembershipGroup.LogicEnum.Not, new ArrayAtom[] { ve });
doc.FontSize = 36;
doc.Rect.Inset(20, 20);
for (int i = 0; i < 3; i++)
{
doc.Page = doc.AddPage();
Page page = (Page)doc.ObjectSoup[doc.Page];
Writer writer = new Writer(props, page);
OptionalContent.Layer layer1 = writer.AddGroup(alloff);
doc.AddText("The next line uses a Policy so that it is only visible if all layers are turned off...\r\n");
writer.StartLayer(layer1);
doc.AddText("I am normally invisible\r\n\r\n");
writer.EndLayer();
OptionalContent.Layer layer2 = writer.AddGroup(mgve);
doc.AddText("The next line uses a Visibility Expression so that it is only visible if all layers are turned off...\r\n");
writer.StartLayer(layer2);
doc.AddText("I am normally invisible\r\n");
writer.EndLayer();
doc.Flatten();
}
LoadPDF(doc);
}
/// <summary>
/// Llena el grid de MembershipGroups
/// </summary>
/// <param name="membershipGroup">Objeto a seleccionar</param>
/// <history>
/// [emoguel] created 19/05/2016
/// </history>
private async void LoadMembershipGroups(MembershipGroup membershipGroup = null)
{
try
{
status.Visibility = Visibility.Visible;
int nIndex = 0;
List <MembershipGroup> lstMembershipGroups = await BRMembershipGroups.GetMembershipGroups(_nStatus, _memberShipGroupFilter);
dgrMembershipGroup.ItemsSource = lstMembershipGroups;
if (lstMembershipGroups.Count > 0 && membershipGroup != null)
{
membershipGroup = lstMembershipGroups.Where(mg => mg.mgID == membershipGroup.mgID).FirstOrDefault();
nIndex = lstMembershipGroups.IndexOf(membershipGroup);
}
GridHelper.SelectRow(dgrMembershipGroup, nIndex);
StatusBarReg.Content = lstMembershipGroups.Count + " Membership Groups.";
status.Visibility = Visibility.Collapsed;
}
catch (Exception ex)
{
UIHelper.ShowMessage(ex);
}
}
/// <summary>
/// Actualiza los datos de la ventana
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// [emoguel] 19/05/2016
/// </history>
private void btnRef_Click(object sender, RoutedEventArgs e)
{
MembershipGroup membershipGroup = (MembershipGroup)dgrMembershipGroup.SelectedItem;
LoadMembershipGroups(membershipGroup);
}
public MembershipGroupModel(MembershipGroup membershipGroup)
{
_membershipGroup = membershipGroup;
}
/// <summary>
/// Obtiene registros del catalogo MembershipGroups
/// </summary>
/// <param name="nStatus">-1. Todos | 0. Inactivos | 1. Activos</param>
/// <param name="membershipGroup">Objeto con filtros especiales</param>
/// <returns> lista de tipo MembershipGroup</returns>
/// <history>
/// [emoguel] created 04/04/2016
/// </history>
public async static Task <List <MembershipGroup> > GetMembershipGroups(int nStatus = -1, MembershipGroup membershipGroup = null)
{
List <MembershipGroup> lstMembershipGroup = null;
await Task.Run(() =>
{
using (var dbContext = new IMEntities(ConnectionHelper.ConnectionString()))
{
var query = from mg in dbContext.MembershipsGroups
select mg;
if (nStatus != -1)//filtro por estatus
{
bool blnStatus = Convert.ToBoolean(nStatus);
query = query.Where(mg => mg.mgA == blnStatus);
}
#region Filtros adicionales
if (membershipGroup != null)
{
if (!string.IsNullOrWhiteSpace(membershipGroup.mgID))//Filtro por ID
{
query = query.Where(mg => mg.mgID == membershipGroup.mgID);
}
if (!string.IsNullOrWhiteSpace(membershipGroup.mgN))//Filtro por descripción
{
query = query.Where(mg => mg.mgN.Contains(membershipGroup.mgN));
}
}
#endregion
lstMembershipGroup = query.OrderBy(mg => mg.mgN).ToList();
}
});
return(lstMembershipGroup);
}
private void SetCategoryGroupDefaults(MembershipCategoryGroupDefault membershipCategoryGroupDefault, MembershipGroup membershipGroup)
{
membershipCategoryGroupDefault.Description = membershipGroup.Description;
membershipCategoryGroupDefault.MemberOnBankHolidays = membershipGroup.MemberOnBankHolidays;
membershipCategoryGroupDefault.MemberAtChristmasWeek = membershipGroup.MemberAtChristmasWeek;
membershipCategoryGroupDefault.IsMonAvailable = membershipGroup.IsMonAvailable;
membershipCategoryGroupDefault.IsTuesAvailable = membershipGroup.IsTuesAvailable;
membershipCategoryGroupDefault.IsWedAvailable = membershipGroup.IsWedAvailable;
membershipCategoryGroupDefault.IsThursAvailable = membershipGroup.IsThursAvailable;
membershipCategoryGroupDefault.IsFriAvailable = membershipGroup.IsFriAvailable;
membershipCategoryGroupDefault.IsSatAvailable = membershipGroup.IsSatAvailable;
membershipCategoryGroupDefault.IsSunAvailable = membershipGroup.IsSunAvailable;
membershipCategoryGroupDefault.Token1 = membershipGroup.Token1;
membershipCategoryGroupDefault.Token2 = membershipGroup.Token2;
membershipCategoryGroupDefault.Token3 = membershipGroup.Token3;
membershipCategoryGroupDefault.Token4 = membershipGroup.Token4;
membershipCategoryGroupDefault.Token5 = membershipGroup.Token5;
membershipCategoryGroupDefault.MembershipCategoryGroupDefaultEPOS.AllowedClubCard = membershipGroup.MembershipGroupEPOS.AllowedClubCard;
membershipCategoryGroupDefault.MembershipCategoryGroupDefaultEPOS.OverdraftLimit1 = membershipGroup.MembershipGroupEPOS.OverdraftLimit1;
membershipCategoryGroupDefault.MembershipCategoryGroupDefaultEPOS.OverdraftLimit2 = membershipGroup.MembershipGroupEPOS.OverdraftLimit2;
membershipCategoryGroupDefault.MembershipCategoryGroupDefaultEPOS.DiscountRateAll = membershipGroup.MembershipGroupEPOS.DiscountRateAll;
membershipCategoryGroupDefault.MembershipCategoryGroupDefaultEPOS.DiscountRate1 = membershipGroup.MembershipGroupEPOS.DiscountRate1;
membershipCategoryGroupDefault.MembershipCategoryGroupDefaultEPOS.DiscountRate2 = membershipGroup.MembershipGroupEPOS.DiscountRate2;
membershipCategoryGroupDefault.MembershipCategoryGroupDefaultEPOS.DiscountRate3 = membershipGroup.MembershipGroupEPOS.DiscountRate3;
membershipCategoryGroupDefault.MembershipCategoryGroupDefaultEPOS.DiscountRate4 = membershipGroup.MembershipGroupEPOS.DiscountRate4;
membershipCategoryGroupDefault.MembershipCategoryGroupDefaultEPOS.DiscountRate5 = membershipGroup.MembershipGroupEPOS.DiscountRate5;
membershipCategoryGroupDefault.MembershipCategoryGroupDefaultEPOS.DisplayMessage = membershipGroup.MembershipGroupEPOS.DisplayMessage;
}
