Exemplo n.º 1
0
 partial void DeleteWardTag(WardTag instance);
Exemplo n.º 2
0
 partial void InsertWardTag(WardTag instance);
Exemplo n.º 3
0
 partial void UpdateWardTag(WardTag instance);
Exemplo n.º 4
0
        /// <summary>
        /// GenerateTag
        /// </summary>
        /// <returns></returns>
        public string GenerateTag(Guid userId)
        {
            string generatedTag = "";
            int tagNumber = 1;

            var address = context.Addresses.Where(@w => @w.UserId == userId).First();
            var ward = context.Wards.Where(@w => @w.Id == address.WardId).First();
            var zone = context.Zones.Where(@w => @w.Id == ward.ZoneId).First();

            var wardTag = context.WardTags.Where(@w => @w.WardId == ward.Id);

            if (wardTag != null && wardTag.Count() > 0)
            {
                tagNumber = wardTag.First().TagNo + 1;
                generatedTag = "Z" + zone.Number + "-W" + ward.Number + "-" + tagNumber;
                wardTag.First().TagNo = tagNumber;
            }
            else
            {
                WardTag tag = new WardTag
                {
                    Id = Guid.NewGuid(),
                    TagNo = tagNumber,
                    WardId = ward.Id
                };

                generatedTag = "Z" + zone.Number + "-W" + ward.Number + "-" + tagNumber;
                context.WardTags.InsertOnSubmit(tag);
            }

            SubmitData();


            return generatedTag;
        }