Ejemplo n.º 1
0
        public dynamic SendMessage(MessageModel mM)
        {
            MessageModel Messages = new MessageModel();

            using (LystenEntities db = new LystenEntities())
            {
                Message ms = new Message();
                ms.Body            = mM.Body;
                ms.CreatedDate     = System.DateTime.Now;
                ms.ParentMessageId = 0;
                ms.CreatorId       = mM.CreatorId;
                db.Messages.Add(ms);
                db.SaveChanges();

                MessageRecipient MR = new MessageRecipient();
                if (mM.RecipientId == null)
                {
                    MR.RecipientGroupId = mM.RecipientGroupId;
                }
                else
                {
                    MR.RecipientId = mM.RecipientId;
                }
                MR.MessageId = ms.Id;
                MR.IsRead    = false;
                db.MessageRecipients.Add(MR);
                db.SaveChanges();
            }
            return(Messages);
        }
Ejemplo n.º 2
0
 public dynamic SaveEmailTemplateData(EmailTemplate UM)
 {
     try
     {
         using (LystenEntities db = new LystenEntities())
         {
             EmailTemplate emailtemp = new EmailTemplate();
             if (UM.Id != 0)
             {
                 emailtemp                 = db.EmailTemplates.Where(x => x.Id == UM.Id).FirstOrDefault();
                 emailtemp.Title           = UM.Title;
                 emailtemp.Subject         = UM.Subject;
                 emailtemp.Body            = UM.Body;
                 emailtemp.SystemName      = UM.SystemName;
                 db.Entry(emailtemp).State = EntityState.Modified;
                 db.SaveChanges();
                 return(new { TemplateId = UM.Id, Status = "Update" });
             }
             else
             {
                 if (db.EmailTemplates.Any(x => x.SystemName == UM.SystemName))
                 {
                     return(new { TemplateId = UM.Id, Status = "Exists" });
                 }
                 db.EmailTemplates.Add(UM);
                 db.SaveChanges();
                 return(new { TemplateId = UM.Id, Status = "Insert" });
             }
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 3
0
 internal dynamic SaveEventCategoryimage(CategoryImageEvent CM)
 {
     using (LystenEntities db = new LystenEntities())
     {
         if (CM.Id > 0)
         {
             var CategoryImageEvents = db.CategoryImageEvents.Where(x => x.Id == CM.Id).FirstOrDefault();
             CategoryImageEvents.Image           = CM.Image;
             db.Entry(CategoryImageEvents).State = EntityState.Modified;
             db.SaveChanges();
             return(new { Id = CM.Id, Status = "Update" });
         }
         else
         {
             if (db.CategoryImageEvents.Any(x => x.CategoryId == (CM.CategoryId)))
             {
                 CM.Id = db.CategoryImageEvents.Where(x => x.CategoryId == (CM.CategoryId)).Select(x => x.Id).FirstOrDefault();
                 return(new { Id = CM.Id, Status = "Exists" });
             }
             else
             {
                 db.CategoryImageEvents.Add(CM);
                 db.SaveChanges();
                 return(new { Id = CM.Id, Status = "Insert" });
             }
         }
     }
 }
Ejemplo n.º 4
0
 public dynamic SaveEmailAccountsData(EmailAccount UM)
 {
     using (LystenEntities db = new LystenEntities())
     {
         if (UM.Id == 0)
         {
             db.EmailAccounts.Add(UM);
             db.SaveChanges();
             return(new { AccountId = UM.Id, Status = "Insert" });
         }
         else
         {
             var obj = db.EmailAccounts.Where(x => x.Id == UM.Id).FirstOrDefault();
             obj.EmailId   = UM.EmailId;
             obj.Password  = UM.Password;
             obj.Port      = UM.Port;
             obj.SMTPRelay = UM.SMTPRelay;
             obj.EnableSSL = UM.EnableSSL;
             obj.SMTPRelay = UM.SMTPRelay; db.Entry(obj).State = EntityState.Modified;
             db.SaveChanges();
             return(new
             {
                 AccountId
                     = UM.Id,
                 Status = "Update"
             });
         }
     }
 }
Ejemplo n.º 5
0
 public dynamic SaveCountry(Country_Master CM)
 {
     using (LystenEntities db = new LystenEntities())
     {
         if (CM.Id > 0)
         {
             var country = db.Country_Master.Where(x => x.Id == CM.Id).FirstOrDefault();
             country.ModifyDate      = System.DateTime.Now;
             country.Name            = CM.Name;
             country.IsActive        = CM.IsActive;
             country.CountryCode     = CM.CountryCode;
             db.Entry(country).State = EntityState.Modified;
             db.SaveChanges();
             return(new { Id = CM.Id, Status = "Update" });
         }
         else
         {
             if (db.Country_Master.Any(x => x.Name == (CM.Name).Trim()))
             {
                 CM.Id = db.Country_Master.Where(x => x.Name == (CM.Name).Trim()).Select(x => x.Id).FirstOrDefault();
                 return(new { Id = CM.Id, Status = "Exists" });
             }
             else
             {
                 CM.CreatedDate = System.DateTime.Now;
                 CM.CreatedBy   = 1;
                 db.Country_Master.Add(CM);
                 db.SaveChanges();
                 return(new { Id = CM.Id, Status = "Insert" });
             }
         }
     }
 }
Ejemplo n.º 6
0
 public dynamic SaveCategory(Category CM)
 {
     using (LystenEntities db = new LystenEntities())
     {
         if (CM.Id > 0)
         {
             var Category = db.Categories.Where(x => x.Id == CM.Id).FirstOrDefault();
             Category.ModifyDate      = System.DateTime.Now;
             Category.Name            = CM.Name;
             Category.Description     = CM.Description;
             db.Entry(Category).State = EntityState.Modified;
             db.SaveChanges();
             return(new { Id = CM.Id, Status = "Update" });
         }
         else
         {
             if (db.Categories.Any(x => x.Name == (CM.Name).Trim()))
             {
                 CM.Id = db.Categories.Where(x => x.Name == (CM.Name).Trim()).Select(x => x.Id).FirstOrDefault();
                 return(new { Id = CM.Id, Status = "Exists" });
             }
             else
             {
                 CM.CreatedDate = System.DateTime.Now;
                 CM.IsActive    = true;
                 db.Categories.Add(CM);
                 db.SaveChanges();
                 return(new { Id = CM.Id, Status = "Insert" });
             }
         }
     }
 }
Ejemplo n.º 7
0
        public void appServer_NewSessionConnected(WebSocketSession session)
        {
            try
            {
                var GroupId = session.Path.Split(',')[1].Split(':')[1];
                var UserId  = session.Path.Split(',')[0].Split(':')[1];

                using (LystenEntities db = new LystenEntities())
                {
                    int gid = Convert.ToInt32(GroupId);
                    int uid = Convert.ToInt32(UserId);


                    var obj = db.Groups.Where(x => x.Id == gid).FirstOrDefault();
                    if (obj.GroupTypeId == 1)
                    {
                        if (!db.Groups.Any(x => x.CreatorId == uid && x.Id == gid))
                        {
                            if (!db.UserGroupMappings.Any(x => x.UserId == uid && x.GroupId == gid))
                            {
                                UserGroupMapping ugm = new UserGroupMapping()
                                {
                                    GroupId = gid,
                                    UserId  = uid
                                };
                                db.UserGroupMappings.Add(ugm);
                                db.SaveChanges();
                            }
                        }
                    }
                    WebSocketSessionDb webs = new WebSocketSessionDb();

                    if (db.WebSocketSessionDbs.Any(x => x.GroupID == gid && x.UserId == uid))
                    {
                        webs                 = db.WebSocketSessionDbs.Where(x => x.GroupID == gid && x.UserId == uid).FirstOrDefault();
                        webs.GroupID         = Convert.ToInt32(GroupId);
                        webs.UserId          = Convert.ToInt32(UserId);
                        webs.SessionId       = session.SessionID;
                        db.Entry(webs).State = EntityState.Modified;
                        db.SaveChanges();
                    }
                    else
                    {
                        webs.GroupID   = Convert.ToInt32(GroupId);
                        webs.UserId    = Convert.ToInt32(UserId);
                        webs.SessionId = session.SessionID;
                        db.WebSocketSessionDbs.Add(webs);
                        db.SaveChanges();
                    }
                }
            }
            catch (Exception ex)
            {
                CommonServices.ErrorLogging(ex);
            }
        }
Ejemplo n.º 8
0
        public static void Add_UpdateToken(int userId, TokenDetails _token, int forceupdate = 0, string deviceType = null)
        {
            try
            {
                LystenEntities db       = new LystenEntities();
                var            chkToken = db.AppAccessTokens.Where(x => x.UserId == userId).FirstOrDefault();
                if (chkToken != null)
                {
                    if (chkToken.ExpiresOn <= DateTime.Now)
                    {
                        db.Entry(chkToken).State = EntityState.Modified;

                        TimeSpan t = TimeSpan.FromMinutes(Convert.ToInt16(ConfigurationManager.AppSettings["TokenExpireHour"].ToString()));
                        chkToken.AuthToken = _token.access_token;
                        chkToken.ExpiresOn = DateTime.Now.Add(t);
                        chkToken.IssuedOn  = DateTime.Now;

                        db.SaveChanges();
                    }
                    else
                    {
                        if (forceupdate > 0)
                        {
                            db.Entry(chkToken).State = EntityState.Modified;

                            TimeSpan t = TimeSpan.FromMinutes(Convert.ToInt16(ConfigurationManager.AppSettings["TokenExpireHour"].ToString()));
                            chkToken.AuthToken  = _token.access_token;
                            chkToken.ExpiresOn  = DateTime.Now.Add(t);
                            chkToken.IssuedOn   = DateTime.Now;
                            chkToken.DeviceType = deviceType;
                            db.SaveChanges();
                        }
                    }
                }
                else
                {
                    AppAccessToken _tokenDetails = new AppAccessToken();
                    _tokenDetails.UserId   = userId;
                    _tokenDetails.IssuedOn = DateTime.Now;
                    TimeSpan t = TimeSpan.FromMinutes(Convert.ToInt16(ConfigurationManager.AppSettings["TokenExpireHour"].ToString()));
                    _tokenDetails.ExpiresOn  = DateTime.Now.Add(t);
                    _tokenDetails.AuthToken  = _token.access_token;
                    _tokenDetails.DeviceType = deviceType;
                    db.AppAccessTokens.Add(_tokenDetails);
                    db.SaveChanges();
                }
                db.Dispose();
            }
            catch (Exception ex)
            {
            }
        }
Ejemplo n.º 9
0
        public dynamic CreateGroup(GroupViewModel GVM)
        {
            string baseURL = HttpContext.Current.Request.Url.Authority;

            baseURL += (WebConfigurationManager.AppSettings["groupimagepath"]).Replace("~", "");
            GroupViewModel data = new GroupViewModel();

            Group G = new Group();

            using (LystenEntities db = new LystenEntities())
            {
                int CreatorId  = Convert.ToInt32(GVM.CreatorId);
                int CategoryId = Convert.ToInt32(GVM.CategoryId);
                G = new Group()
                {
                    Name        = GVM.Name,
                    IsActive    = true,
                    CreatedDate = System.DateTime.Now,
                    CreatorId   = CreatorId,
                    GroupTypeId = Convert.ToInt32(GVM.GroupTypeId),
                    CategoryId  = CategoryId
                };
                db.Groups.Add(G);
                db.SaveChanges();

                data = AutoMapper.Mapper.Map <Group, GroupViewModel>(G);
                if (G.Image == null || G.Image == "")
                {
                    data.Image = "";
                }
                else
                {
                    data.Image = baseURL + GVM.Image;
                }

                if (!db.UserCategoryMappings.Any(x => x.UserId == CreatorId && x.CategoryId == CategoryId))
                {
                    UserCategoryMapping uc = new UserCategoryMapping()
                    {
                        CategoryId = CategoryId,
                        UserId     = CreatorId
                    };
                    db.UserCategoryMappings.Add(uc);
                    db.SaveChanges();
                }
            }
            return(data);
        }
Ejemplo n.º 10
0
        public dynamic PostLoginAuthentication(UserMasterModel objtblusermaster)
        {
            using (LystenEntities db = new LystenEntities())
            {
                var paswrdenc = SecutiryServices.EncodePasswordToBase64(objtblusermaster.Password);
                var result    = (from um in db.User_Master
                                 where um.Email.ToUpper() == objtblusermaster.Email.ToUpper() && um.Password == paswrdenc && um.IsActive == true
                                 select um
                                 ).ToList();

                if (result.Count > 0)
                {
                    int id       = result.Select(y => y.Id).FirstOrDefault();
                    var chkToken = db.AppAccessTokens.Where(x => x.UserId == id).FirstOrDefault();
                    if (chkToken != null)
                    {
                        db.Entry(chkToken).State = EntityState.Deleted;
                        db.SaveChanges();
                    }

                    objresult.Code = 200;
                    objresult.Msg  = "Success";
                    objresult.Data = result;
                }
                else
                {
                    objresult.Code = 0;
                    objresult.Msg  = "Something Went Wrong.";
                    objresult.Data = result;
                }
                return(objresult);
            }
        }
Ejemplo n.º 11
0
        public dynamic acceptrejectcall(CallViewModel uM)
        {
            using (LystenEntities db = new LystenEntities())
            {
                Calling_Request qs = db.Calling_Request.Where(x => x.Id == uM.Id).FirstOrDefault();



                //TimeZoneInfo.ConvertTime(qs.AcceptDatetime.Value, qs.TimeZoneId, destinationTimeZone);

                var dt = DateTime.SpecifyKind(uM.AcceptDatetime == 1 ? qs.CallingDateTime1.Value : uM.AcceptDatetime == 2 ? qs.CallingDateTime2.Value : uM.AcceptDatetime == 3 ? qs.CallingDateTime3.Value : System.DateTime.Now, DateTimeKind.Local);

                qs.AcceptDatetime = uM.AcceptDatetime == 1 ? qs.CallingDateTime1 : uM.AcceptDatetime == 2 ? qs.CallingDateTime2 : uM.AcceptDatetime == 3 ? qs.CallingDateTime3 : System.DateTime.Now;



                TimeZoneInfo easternZone = TimeZoneInfo.FindSystemTimeZoneById(qs.TimeZoneId);


                qs.AcceptDatetimeUTC = TimeZoneInfo.ConvertTimeToUtc(qs.AcceptDatetime.Value, easternZone);
                //= TimeZoneInfo.ConvertTimeToUtc(dt);



                qs.IsAccept        = uM.IsAccept == 1 ? true : false;
                qs.IsReject        = uM.IsAccept == 0 ? true : false;
                qs.RejectedNote    = uM.RejectedNote;
                db.Entry(qs).State = EntityState.Modified;
                db.SaveChanges();

                return(qs);
            }
        }
Ejemplo n.º 12
0
        public dynamic logoutUser(int UserId)
        {
            ResultClassCommon result = new ResultClassCommon();

            using (LystenEntities db = new LystenEntities())
            {
                int companyid = 0;
                var obj       = db.User_Master.Where(x => x.Id == UserId).FirstOrDefault();

                if (obj != null)
                {
                    obj.IsLogin         = false;
                    obj.DeviceToken     = null;
                    db.Entry(obj).State = EntityState.Modified;
                    db.SaveChanges();
                    result.Code = (int)HttpStatusCode.OK;
                    result.Msg  = ap.Success;
                }
                else
                {
                    result.Code = (int)HttpStatusCode.NonAuthoritativeInformation;
                    result.Msg  = ap.GlobalError;
                }
            }
            return(result);
        }
Ejemplo n.º 13
0
        public ResultClassToken ChangePassword(ChangePasswordModel cP, string token)
        {
            ResultClassToken rc = new ResultClassToken();

            using (LystenEntities db = new LystenEntities())
            {
                var pwd = SecutiryServices.EncodePasswordToBase64(cP.CurrentPassword);

                var data = db.User_Master.Where(x => x.Password == pwd && x.Id == cP.UserId).FirstOrDefault();
                if (data != null)
                {
                    data.Password        = SecutiryServices.EncodePasswordToBase64(cP.NewPassword);
                    db.Entry(data).State = EntityState.Modified;
                    db.SaveChanges();
                    rc.Code = (int)HttpStatusCode.OK;
                    rc.Msg  = ap.Success;
                    //objresult.Data = model;
                }
                else
                {
                    rc.Code = (int)HttpStatusCode.NotFound;
                    rc.Msg  = ap.CurrentPaasswordNotSame;
                    //objresult.Data = model;
                }
            }
            return(rc);
        }
Ejemplo n.º 14
0
 public void updatesession(User_Master objuser)
 {
     using (LystenEntities db = new LystenEntities())
     {
         db.Entry(objuser).State = EntityState.Modified;
         db.SaveChanges();
     }
 }
Ejemplo n.º 15
0
        public dynamic SaveEvents(EventViewModel uM)
        {
            IdModel IM = new IdModel();


            using (LystenEntities db = new LystenEntities())
            {
                var data = DateTimeOffset.Parse(uM.CreatedDate);

                if (uM.Id > 0)
                {
                    Event qs = db.Events.Where(x => x.Id == uM.Id).Include(x => x.Category).FirstOrDefault();
                    qs.Title           = uM.Title;
                    qs.Description     = uM.Description;
                    qs.CategoryId      = uM.CategoryId;
                    qs.Location        = uM.Location;
                    qs.CreatedDate     = data.UtcDateTime;
                    qs.Image           = uM.Image;
                    qs.IsActive        = true;
                    db.Entry(qs).State = EntityState.Modified;
                    db.SaveChanges();
                    IM.Id = qs.Id;
                    return(IM);
                }
                else
                {
                    Event qs = new Event()
                    {
                        Title       = uM.Title,
                        Description = uM.Description,
                        CategoryId  = uM.CategoryId,
                        Location    = uM.Location,
                        CreatedDate = data.UtcDateTime,
                        Image       = uM.Image,
                        CreatorId   = uM.UserId,
                        IsActive    = true,
                    };
                    db.Events.Add(qs);
                    db.SaveChanges();
                    IM.Id = qs.Id;
                    return(IM);
                }
            }
        }
Ejemplo n.º 16
0
        public override void OnMessage(string message)
        {
            try
            {
                if (message != null && message != "")
                {
                    var UserId  = message.Split(',')[0].Split(':')[1];
                    var IsLogin = message.Split(',')[1].Split(':')[1];

                    if (IsLogin == "1")
                    {
                        var TimeZone = message.Split(',')[2].Split(':')[1];

                        using (LystenEntities db = new LystenEntities())
                        {
                            if (UserId != "" && TimeZone != "")
                            {
                                int uid = Convert.ToInt32(UserId);

                                var obj = db.User_Master.Where(x => x.Id == uid).FirstOrDefault();

                                if (obj != null)
                                {
                                    obj.TimeZone        = TimeZone;
                                    obj.IsLogin         = true;
                                    db.Entry(obj).State = EntityState.Modified;
                                    db.SaveChanges();
                                }
                            }
                        }
                    }
                    else
                    {
                        using (LystenEntities db = new LystenEntities())
                        {
                            int uid = Convert.ToInt32(UserId);

                            var obj = db.User_Master.Where(x => x.Id == uid).FirstOrDefault();
                            if (obj != null)
                            {
                                obj.IsLogin = false;
                                //obj.TimeZone = "";
                                //obj.DeviceToken = null;
                                db.Entry(obj).State = EntityState.Modified;
                                db.SaveChanges();
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                CommonServices.ErrorLogging(ex);
            }
        }
Ejemplo n.º 17
0
 public dynamic DeleteCountry(int id)
 {
     using (LystenEntities db = new LystenEntities())
     {
         var country = db.Country_Master.Where(x => x.Id == id).FirstOrDefault();
         country.IsActive        = false;
         db.Entry(country).State = EntityState.Modified;
         db.SaveChanges();
         return(new { Id = 1, Status = "Delete" });
     }
 }
Ejemplo n.º 18
0
 public dynamic SendDisclaimer(int UserId, int IsAdded)
 {
     using (LystenEntities db = new LystenEntities())
     {
         var data = db.User_Master.Where(x => x.Id == UserId).FirstOrDefault();
         if (IsAdded == 1)
         {
             data.IsDisclaimer    = true;
             db.Entry(data).State = EntityState.Modified;
             db.SaveChanges();
         }
         else
         {
             data.IsDisclaimer    = false;
             db.Entry(data).State = EntityState.Modified;
             db.SaveChanges();
         }
         return(data);
     }
 }
Ejemplo n.º 19
0
 public dynamic deletequestion(int questionId)
 {
     using (LystenEntities db = new LystenEntities())
     {
         var obj = db.Questions.Where(x => x.Id == questionId).FirstOrDefault();
         obj.IsActive        = false;
         db.Entry(obj).State = EntityState.Modified;
         db.SaveChanges();
         return(1);
     }
 }
Ejemplo n.º 20
0
 public dynamic UpdateCallingRequest(decimal amount, PaymentModel pM, string id)
 {
     using (LystenEntities db = new LystenEntities())
     {
         var obj = db.Calling_Request.Where(x => x.Id == pM.CallingRequestId).FirstOrDefault();
         obj.TotalCallingTime = pM.TotalCallingTime;
         obj.TotalAmount      = amount + obj.TotalAmount;
         db.Entry(obj).State  = EntityState.Modified;
         db.SaveChanges();
         return(obj);
     }
 }
Ejemplo n.º 21
0
 public dynamic SaveCallingPriceMaster(CallingPriceMaster viewModel)
 {
     using (LystenEntities db = new LystenEntities())
     {
         if (viewModel.Id > 0)
         {
             var callingPrice = db.CallingPriceMasters.Where(x => x.Id == viewModel.Id).FirstOrDefault();
             callingPrice.ModifiedDate    = System.DateTime.Now;
             callingPrice.Name            = viewModel.Name;
             callingPrice.Description     = viewModel.Description;
             callingPrice.Price           = viewModel.Price;
             callingPrice.Time            = viewModel.Time;
             callingPrice.ModifiedDate    = DateTime.Now;
             db.Entry(callingPrice).State = EntityState.Modified;
             db.SaveChanges();
             return(new { Id = viewModel.Id, Status = "Update" });
         }
         else
         {
             if (db.Categories.Any(x => x.Name == (viewModel.Name).Trim()))
             {
                 viewModel.Id = db.Categories.Where(x => x.Name == (viewModel.Name).Trim()).Select(x => x.Id).FirstOrDefault();
                 return(new { Id = viewModel.Id, Status = "Exists" });
             }
             else
             {
                 viewModel.IsActive     = true;
                 viewModel.CreatedDate  = DateTime.Now;
                 viewModel.ModifiedDate = DateTime.Now;
                 db.CallingPriceMasters.Add(viewModel);
                 db.SaveChanges();
                 return(new { Id = viewModel.Id, Status = "Insert" });
             }
         }
     }
 }
Ejemplo n.º 22
0
 public dynamic SaveEvent(Event CM)
 {
     using (LystenEntities db = new LystenEntities())
     {
         if (CM.Id > 0)
         {
             var Event = db.Events.Where(x => x.Id == CM.Id).FirstOrDefault();
             Event.ModifiedDate    = System.DateTime.Now;
             Event.Description     = CM.Description;
             Event.Title           = CM.Title;
             Event.CategoryId      = CM.CategoryId;
             Event.IsActive        = CM.IsActive;
             Event.Location        = CM.Location;
             db.Entry(Event).State = EntityState.Modified;
             db.SaveChanges();
             return(new { Id = CM.Id, Status = "Update" });
         }
         else
         {
             if (db.Events.Any(x => x.Title == (CM.Title).Trim()))
             {
                 CM.Id = db.Events.Where(x => x.Title == (CM.Title).Trim()).Select(x => x.Id).FirstOrDefault();
                 return(new { Id = CM.Id, Status = "Exists" });
             }
             else
             {
                 CM.IsActive    = true;
                 CM.CreatedDate = System.DateTime.Now;
                 CM.CreatedBy   = 1;
                 db.Events.Add(CM);
                 db.SaveChanges();
                 return(new { Id = CM.Id, Status = "Insert" });
             }
         }
     }
 }
Ejemplo n.º 23
0
 public object ActiveDeActiveUser(int id)
 {
     using (LystenEntities db = new LystenEntities())
     {
         var User = db.User_Master.Where(x => x.Id == id).FirstOrDefault();
         if (User.IsActive == true)
         {
             User.IsActive = false;
         }
         else
         {
             User.IsActive = true;
         }
         db.Entry(User).State = EntityState.Modified;
         db.SaveChanges();
         return(new { Id = 1, Status = User.IsActive });
     }
 }
Ejemplo n.º 24
0
 public dynamic ActiveDeActiveCategory(int id)
 {
     using (LystenEntities db = new LystenEntities())
     {
         var Categories = db.Categories.Where(x => x.Id == id).FirstOrDefault();
         if (Categories.IsActive == true)
         {
             Categories.IsActive = false;
         }
         else
         {
             Categories.IsActive = true;
         }
         db.Entry(Categories).State = EntityState.Modified;
         db.SaveChanges();
         return(new { Id = 1, Status = Categories.IsActive });
     }
 }
Ejemplo n.º 25
0
 public object ActivedeActiveCallingPrice(int id)
 {
     using (LystenEntities db = new LystenEntities())
     {
         var Event = db.CallingPriceMasters.Where(x => x.Id == id).FirstOrDefault();
         if (Event.IsActive == true)
         {
             Event.IsActive = false;
         }
         else
         {
             Event.IsActive = true;
         }
         db.Entry(Event).State = EntityState.Modified;
         db.SaveChanges();
         return(new { Id = 1, Status = Event.IsActive });
     }
 }
Ejemplo n.º 26
0
 public bool DeleteStripeCutomer(string userId)
 {
     try
     {
         using (LystenEntities db = new LystenEntities())
         {
             var _Payment = db.BraintreeCustomerMappings.Where(x => x.BraintreeCustomerId == userId).FirstOrDefault();
             if (_Payment != null)
             {
                 db.BraintreeCustomerMappings.Remove(_Payment);
                 db.SaveChanges();
             }
             return(true);
         }
     }
     catch
     {
         return(false);
     }
 }
Ejemplo n.º 27
0
 public dynamic Changepassword(UserModel objcurpwd)
 {
     using (LystenEntities db = new LystenEntities())
     {
         var         paswrdenc = SecutiryServices.EncodePasswordToBase64(objcurpwd.Currentpassword);
         User_Master result    = (from um in db.User_Master
                                  where um.Id == objcurpwd.Id &&
                                  um.Password == paswrdenc
                                  select um
                                  ).FirstOrDefault();
         if (result != null)
         {
             result.Password        = SecutiryServices.EncodePasswordToBase64(objcurpwd.Newpassword);
             db.Entry(result).State = EntityState.Modified;
             db.SaveChanges();
             return("Success");
         }
         else
         {
             return("Invalid Password.");
         }
     }
 }
Ejemplo n.º 28
0
        public object MarkAsVerified(int id)
        {
            using (LystenEntities db = new LystenEntities())
            {
                var User = db.User_Master.Where(x => x.Id == id).FirstOrDefault();
                if (User.IsVerified == null || User.IsVerified == false)
                {
                    User.IsVerified = true;
                }

                db.Entry(User).State = EntityState.Modified;
                db.SaveChanges();
                try
                {
                    Helpers.EmailHelper.SendEmail(User.Email, User.UserName, User.Password);
                }
                catch
                {
                }


                return(new { Id = 1, Status = User.IsActive });
            }
        }
Ejemplo n.º 29
0
        public dynamic UpdateGroup(GroupViewModel GVM)
        {
            string baseURL = HttpContext.Current.Request.Url.Authority;

            baseURL += (WebConfigurationManager.AppSettings["groupimagepath"]).Replace("~", "");
            GroupViewModel data = new GroupViewModel();
            Group          G    = new Group();

            using (LystenEntities db = new LystenEntities())
            {
                G              = db.Groups.Where(x => x.Id == GVM.Id).FirstOrDefault();
                G.Name         = GVM.Name;
                G.ModifiedDate = System.DateTime.Now;
                if (GVM.Image != null)
                {
                    data.Image        = baseURL + GVM.Image;
                    G.Image           = GVM.Image;
                    db.Entry(G).State = EntityState.Modified;
                    db.SaveChanges();
                }
                else
                {
                    data.Image = baseURL + GVM.Image;
                }
                data = AutoMapper.Mapper.Map <Group, GroupViewModel>(G);
                if (G.Image == null || G.Image == "")
                {
                    data.Image = "";
                }
                else
                {
                    data.Image = baseURL + GVM.Image;
                }
                return(data);
            }
        }
Ejemplo n.º 30
0
 public dynamic SaveUser(UserModel objUM)
 {
     using (LystenEntities db = new LystenEntities())
     {
         if (objUM.Id > 0)
         {
             var user     = db.User_Master.Where(x => x.Id == objUM.Id).FirstOrDefault();
             var sendflag = false;
             if (user.Password != objUM.Password)
             {
                 sendflag = true;
             }
             //user.Email = objUM.Email;
             user.Password        = objUM.Password;
             user.Address         = objUM.Address;
             user.CountryId       = objUM.Country;
             user.StateId         = objUM.State;
             user.CityId          = objUM.City;
             user.Phone           = objUM.Phone;
             user.Mobile          = objUM.Mobile;
             user.Displayname     = objUM.Displayname;
             user.IsActive        = true;
             user.Modifydate      = System.DateTime.Now;
             db.Entry(user).State = EntityState.Modified;
             db.SaveChanges();
             if (sendflag == true)
             {
                 ES.SendToUser(user);
             }
             return(new { Id = user.Id, Status = "Update" });
         }
         else
         {
             if (db.User_Master.Any(x => x.Email == (objUM.Email).Trim()))
             {
                 objUM.Id = db.User_Master.Where(x => x.Email == (objUM.Email).Trim()).Select(x => x.Id).FirstOrDefault();
                 return(new { Id = objUM.Id, Status = "Exists" });
             }
             else
             {
                 User_Master user = new User_Master();
                 user.Email       = objUM.Email;
                 user.Password    = objUM.Password;
                 user.Address     = objUM.Address;
                 user.CountryId   = objUM.Country;
                 user.StateId     = objUM.State;
                 user.CityId      = objUM.City;
                 user.Phone       = objUM.Phone;
                 user.Mobile      = objUM.Mobile;
                 user.Displayname = objUM.Displayname;
                 user.IsActive    = true;
                 user.Createdate  = System.DateTime.Now;
                 user.Modifydate  = System.DateTime.Now;
                 user.Createdby   = 1;
                 db.User_Master.Add(user);
                 db.SaveChanges();
                 ES.SendToUser(user);
                 return(new { Id = user.Id, Status = "Insert" });
             }
         }
     }
 }