/// <UpdateBusinessSetting> /// Update BusinessSetting by UserId. /// </summary> /// <param name="businessSetting">Set Values in a BusinessSetting Class Property and Pass the same Object of BusinessSetting Class.(Domain.BusinessSetting)</param> public void UpdateBusinessSetting(BusinessSetting businessSetting) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { // Proceed action to Update Data. // And Set the reuired paremeters to find the specific values. session.CreateQuery("Update BusinessSetting set BusinessName =:businessName,AssigningTasks =:assigningTasks,TaskNotification =:taskNotification,FbPhotoUpload =:fbPhotoUpload,EntryDate =:entryDate where UserId =:userId and groupId=:groupId and BusinessName=:GroupName") .SetParameter("businessName", businessSetting.BusinessName) .SetParameter("assigningTasks", businessSetting.AssigningTasks) .SetParameter("taskNotification", businessSetting.TaskNotification) .SetParameter("fbPhotoUpload", businessSetting.FbPhotoUpload) .SetParameter("entryDate", DateTime.Now) .SetParameter("userId", businessSetting.UserId) .SetParameter("groupId", businessSetting.GroupId) .SetParameter("GroupName", businessSetting.BusinessName) .ExecuteUpdate(); transaction.Commit(); } //End Transaction } //End session }
/// <AddBusinessSetting> /// Check If User Id is exist or Not. If User Id is Exist then It will Update that same Users all Business Setting. Otherwise It add a new Business Setting Data. /// </summary> /// <param name="businessSetting">Set Values in a BusinessSetting Class Property and Pass the same Object of BusinessSetting Class.(Domain.BusinessSetting)</param> public void AddBusinessSetting(BusinessSetting businessSetting) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { //Proceed action. to check if user is Exist or not. List <BusinessSetting> lstBusinessSetting = CheckUserId(businessSetting.UserId, businessSetting.GroupId, businessSetting.BusinessName); //if user is Exist the it update all BusinessSetting of the Same user, //Otherwise it add New BusinessSetting. if (lstBusinessSetting.Count > 0) { UpdateBusinessSetting(businessSetting); } else { session.Save(businessSetting); transaction.Commit(); } } //End Transaction } //End session }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); BusinessSetting.SetBusiness(); }
public static bool ParseURL(string url) { url = url.ToLower(); UrlParser parser = new UrlParser(); parser.Parse(url, '&'); if ((parser.GetKey("ocxversion") != string.Empty) && HasNewVer(parser.GetKey("ocxversion"))) { return(false); } AccountSetting.GetInstance().AccountName = parser.GetKey("currentuser"); BusinessSetting.GetInstance().bustype = parser.GetKey("bustype"); BusinessSetting.GetInstance().busno = parser.GetKey("busno"); AccountSetting.GetInstance().AccountOrgID = parser.GetKey("unitno"); if (parser.GetKey("mode") == "update") { string key = parser.GetKey("barno"); AppContext.GetInstance().GetVal <UCBench>(typeof(UCBench)).QueryMode(key.ToUpper()); } return(true); }
public BusinessSetting IsNotificationTaskEnable(Guid groupId) { // bool flag = 0; using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { List <BusinessSetting> lstdetails = session.CreateQuery("from BusinessSetting where groupId=:groupId") .SetParameter("groupId", groupId).List <BusinessSetting>().ToList <BusinessSetting>(); BusinessSetting objBsnsStng = lstdetails[0]; //flag = objBsnsStng.AssigningTasks; //if (objBsnsStng.AssigningTasks == true) //{ // return true; //} //else //{ // return false; //} return(objBsnsStng); } } }
public void ProcessRequest() { if (Request.QueryString["op"] == "login") { try { string email = Request.QueryString["username"]; string password = Request.QueryString["password"]; Registration regpage = new Registration(); password = regpage.MD5Hash(password); SocioBoard.Helper.SessionFactory.configfilepath = Server.MapPath("~/hibernate.cfg.xml"); UserRepository userrepo = new UserRepository(); LoginLogs objLoginLogs = new LoginLogs(); LoginLogsRepository objLoginLogsRepository = new LoginLogsRepository(); User user = userrepo.GetUserInfo(email, password); if (user == null) { Response.Write("Invalid Email or Password"); } else { if (user.UserStatus == 1) { Session["LoggedUser"] = user; // List<User> lstUser = new List<User>(); if (Session["LoggedUser"] != null) { //SocioBoard.Domain.User.lstUser.Add((User)Session["LoggedUser"]); //Application["OnlineUsers"] = SocioBoard.Domain.User.lstUser; //objLoginLogs.Id = new Guid(); //objLoginLogs.UserId = user.Id; //objLoginLogs.UserName = user.UserName; //objLoginLogs.LoginTime = DateTime.Now.AddHours(11.50); //objLoginLogsRepository.Add(objLoginLogs); Groups objGroups = new Groups(); GroupRepository objGroupRepository = new GroupRepository(); Team objteam = new Team(); TeamRepository objTeamRepository = new TeamRepository(); objGroups = objGroupRepository.getGroupDetail(user.Id); if (objGroups == null) { //================================================================================ //Insert into group try { objGroups = new Groups(); objGroups.Id = Guid.NewGuid(); objGroups.GroupName = ConfigurationManager.AppSettings["DefaultGroupName"]; objGroups.UserId = user.Id; objGroups.EntryDate = DateTime.Now; objGroupRepository.AddGroup(objGroups); objteam.Id = Guid.NewGuid(); objteam.GroupId = objGroups.Id; objteam.UserId = user.Id; objteam.EmailId = user.EmailId; // teams.FirstName = user.UserName; objTeamRepository.addNewTeam(objteam); SocialProfile objSocialProfile = new SocialProfile(); SocialProfilesRepository objSocialProfilesRepository = new SocialProfilesRepository(); List <SocialProfile> lstSocialProfile = objSocialProfilesRepository.getAllSocialProfilesOfUser(user.Id); if (lstSocialProfile != null) { if (lstSocialProfile.Count > 0) { foreach (SocialProfile item in lstSocialProfile) { try { TeamMemberProfile objTeamMemberProfile = new TeamMemberProfile(); TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository(); objTeamMemberProfile.Id = Guid.NewGuid(); objTeamMemberProfile.TeamId = objteam.Id; objTeamMemberProfile.ProfileId = item.ProfileId; objTeamMemberProfile.ProfileType = item.ProfileType; objTeamMemberProfile.Status = item.ProfileStatus; objTeamMemberProfile.StatusUpdateDate = DateTime.Now; objTeamMemberProfileRepository.addNewTeamMember(objTeamMemberProfile); } catch (Exception ex) { Console.WriteLine(ex.Message); } } } } } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error("Error : " + ex.Message); logger.Error("Error : " + ex.StackTrace); } //========================================================================================================== } BusinessSetting objBusinessSetting = new BusinessSetting(); BusinessSettingRepository objBusinessSettingRepository = new BusinessSettingRepository(); List <BusinessSetting> lstBusinessSetting = objBusinessSettingRepository.GetBusinessSettingByUserId(user.Id); if (lstBusinessSetting.Count == 0) { try { List <Groups> lstGroups = objGroupRepository.getAllGroups(user.Id); foreach (Groups item in lstGroups) { objBusinessSetting = new BusinessSetting(); objBusinessSetting.Id = Guid.NewGuid(); objBusinessSetting.BusinessName = item.GroupName; //objbsnssetting.GroupId = team.GroupId; objBusinessSetting.GroupId = item.Id; objBusinessSetting.AssigningTasks = false; objBusinessSetting.AssigningTasks = false; objBusinessSetting.TaskNotification = false; objBusinessSetting.TaskNotification = false; objBusinessSetting.FbPhotoUpload = 0; objBusinessSetting.UserId = user.Id; objBusinessSetting.EntryDate = DateTime.Now; objBusinessSettingRepository.AddBusinessSetting(objBusinessSetting); } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } } Response.Write("user"); } else { Response.Write("You are Blocked by Admin Please contact Admin!"); } } } catch (Exception ex) { Response.Write("Error: " + ex.Message); Console.WriteLine(ex.StackTrace); logger.Error(ex.StackTrace); } } else if (Request.QueryString["op"] == "register") { User user = new User(); UserActivation objUserActivation = new UserActivation(); UserRepository userrepo = new UserRepository(); SocioBoard.Helper.SessionFactory.configfilepath = Server.MapPath("~/hibernate.cfg.xml"); Session["AjaxLogin"] = "******"; try { System.IO.StreamReader sr = new System.IO.StreamReader(Request.InputStream); string line = ""; line = sr.ReadToEnd(); JObject jo = JObject.Parse(line); user.PaymentStatus = "unpaid"; if (!string.IsNullOrEmpty(Request.QueryString["type"])) { user.AccountType = Request.QueryString["type"]; } else { user.AccountType = "deluxe"; } user.CreateDate = DateTime.Now; user.ExpiryDate = DateTime.Now.AddMonths(1); user.Id = Guid.NewGuid(); user.UserName = Server.UrlDecode((string)jo["firstname"]) + " " + Server.UrlDecode((string)jo["lastname"]); user.EmailId = Server.UrlDecode((string)jo["email"]); user.Password = Server.UrlDecode((string)jo["password"]); user.UserStatus = 1; if (!userrepo.IsUserExist(user.EmailId)) { UserRepository.Add(user); Session["LoggedUser"] = user; Response.Write("user"); objUserActivation.Id = Guid.NewGuid(); objUserActivation.UserId = user.Id; objUserActivation.ActivationStatus = "0"; UserActivationRepository.Add(objUserActivation); //add value in userpackage UserPackageRelation objUserPackageRelation = new UserPackageRelation(); UserPackageRelationRepository objUserPackageRelationRepository = new UserPackageRelationRepository(); PackageRepository objPackageRepository = new PackageRepository(); Package objPackage = objPackageRepository.getPackageDetails(user.AccountType); objUserPackageRelation.Id = new Guid(); objUserPackageRelation.PackageId = objPackage.Id; objUserPackageRelation.UserId = user.Id; objUserPackageRelation.PackageStatus = true; objUserPackageRelationRepository.AddUserPackageRelation(objUserPackageRelation); SocioBoard.Helper.MailSender.SendEMail(user.UserName, user.Password, user.EmailId, user.AccountType.ToString(), user.Id.ToString()); //MailSender.SendEMail(user.UserName, user.Password, user.EmailId); // lblerror.Text = "Registered Successfully !" + "<a href=\"login.aspx\">Login</a>"; } else { Response.Write("Email Already Exists !"); } } catch (Exception ex) { logger.Error(ex.StackTrace); Console.WriteLine(ex.StackTrace); } } else if (Request.QueryString["op"] == "facebooklogin") { SessionFactory.configfilepath = Server.MapPath("~/hibernate.cfg.xml"); string redi = "http://www.facebook.com/dialog/oauth/?scope=publish_stream,read_stream,read_insights,manage_pages,user_checkins,user_photos,read_mailbox,manage_notifications,read_page_mailboxes,email,user_videos,offline_access&client_id=" + ConfigurationManager.AppSettings["ClientId"] + "&redirect_uri=" + ConfigurationManager.AppSettings["RedirectUrl"] + "&response_type=code"; Session["login"] = "******"; Response.Write(redi); } else if (Request.QueryString["op"] == "googlepluslogin") { Session["login"] = "******"; oAuthToken objToken = new oAuthToken(); Response.Write(objToken.GetAutherizationLink("https://www.googleapis.com/auth/userinfo.email+https://www.googleapis.com/auth/userinfo.profile+https://www.googleapis.com/auth/plus.me+https://www.googleapis.com/auth/plus.login")); } else if (Request.QueryString["op"] == "removeuser") { try { if (Session["LoggedUser"] != null) { SocioBoard.Domain.User.lstUser.Remove((User)Session["LoggedUser"]); } } catch (Exception Err) { logger.Error(Err.StackTrace); Response.Write(Err.StackTrace); } } }