public ICollection<FanPageStatus> GetAllFanPageStatus(FanPageStatus acc) { ICollection<FanPageStatus> iCol = null; try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { iCol = session.CreateCriteria(typeof(FanPageStatus)).List<FanPageStatus>(); } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } return iCol; }
public void Update(FanPageStatus acc) { try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { //session.Update(acc.Password, acc); transaction.Commit(); } } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } }
public void Insert(FanPageStatus acc) { try { lock (lockerInsert) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { session.Save(acc); transaction.Commit(); } } } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } }
public void DeleteUsingMainPageUrl(FanPageStatus fpStatus) { try { lock (lockerDeleteUsingMainPageUrl) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { var query = session.CreateQuery("Delete from FanPageStatus where MainPageUrl= :mainPageUrl"); query.SetParameter("mainPageUrl", fpStatus.MainPageUrl); int res = query.ExecuteUpdate(); transaction.Commit(); } } } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } }
private void PageManagerQuery(DataSet ds, params string[] paramValue) { try { if (paramValue.Length > 1) { if (paramValue[0] == "Model : FanPageStatusRepository") { try { FanPageStatus objFanPageStatus = new FanPageStatus(); if (paramValue[1] == "Function : DeleteUsingMainPageUrl") { objFanPageStatus.MainPageUrl = paramValue[2]; objFanPageStatusRepository.DeleteUsingMainPageUrl(objFanPageStatus); } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } if (paramValue[0] == "Model : FanPagePostRepository") { try { FanPagePost objFanPagePost = new FanPagePost(); if (paramValue[1] == "Function : Insert") { try { objFanPagePost.FriendId = paramValue[2]; objFanPagePost.Status = "0"; objFanPagePost.Level = "0"; objFanPagePost.Date = System.DateTime.Now.ToString(); objFanPagePost.MainPageUrl = paramValue[6]; objFanPagePostRepository.Insert(objFanPagePost); } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } if (paramValue[1] == "Function : InsertChasngeLevel") { try { objFanPagePost.FriendId = paramValue[2]; objFanPagePost.Status = "0"; objFanPagePost.Level = "1"; objFanPagePost.Date = System.DateTime.Now.ToString(); objFanPagePost.MainPageUrl = paramValue[6]; objFanPagePostRepository.InsertChasngeLevel(objFanPagePost); } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } if (paramValue[1] == "Function : UpdateStatusUsingFriendId") { try { objFanPagePost.FriendId = paramValue[2]; objFanPagePost.Status = "1"; objFanPagePostRepository.UpdateStatusUsingFriendId(objFanPagePost); } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } if (paramValue[1] == "Function : GetFanPagePostUsingLevelStatusMainPageUrl") { try { objFanPagePost.MainPageUrl = paramValue[2]; objFanPagePost.Status = "0"; objFanPagePost.Level = "0"; List<FanPagePost> lstFPPost = objFanPagePostRepository.GetFanPagePostUsingLevelStatusMainPageUrl(objFanPagePost); if (lstFPPost.Count > 0) { DataTable dt = new DataTable(); dt.Columns.Add("FriendId", typeof(string)); foreach (FanPagePost item in lstFPPost) { try { dt.Rows.Add(item.FriendId.ToString()); } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } ds.Tables.Add(dt); } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } if (paramValue[1] == "Function : GetFanPagePostFriendIdMainPageUrlUsingLevelStatusMainPageUrl") { try { objFanPagePost.MainPageUrl = paramValue[2]; objFanPagePost.Status = "0"; objFanPagePost.Level = "1"; List<FanPagePost> lstFPPost = objFanPagePostRepository.GetFanPagePostUsingLevelStatusMainPageUrl(objFanPagePost); if (lstFPPost.Count > 0) { DataTable dt = new DataTable(); dt.Columns.Add("FriendId", typeof(string)); dt.Columns.Add("MainPageUrl", typeof(string)); foreach (FanPagePost item in lstFPPost) { try { dt.Rows.Add(item.FriendId.ToString(), item.MainPageUrl); } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } ds.Tables.Add(dt); } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } if (paramValue[0] == "Model : EmailRepository") { Email objemail = new Email(); try { if (paramValue[1] == "Function : InsertCreatedEmailinEmailDatatbase") { objemail.UserName = paramValue[2]; objemail.Password = paramValue[3]; objemail.IsUsed = "0"; objEmailRepository.Insert(objemail); } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } if (paramValue[0] == "Model : CaptchaSetting") { faceboardpro.Domain.Captcha objcaptcha = new faceboardpro.Domain.Captcha(); try { if (paramValue[1] == "Function : InsertCaptchaSettinginCaptchaDatatbase") { objcaptcha.Username = paramValue[2]; objcaptcha.Password = paramValue[3]; objcaptcha.CaptchaService = paramValue[4]; objcaptcha.Status = "True"; objCaptchaRepositry.Insert(objcaptcha); objCaptchaRepositry.UpdateCaptchaStatusForOtherService(objcaptcha); } if (paramValue[1] == "Function : UpdateCaptchaSettinginCaptchaDatatbase") { objcaptcha.Username = paramValue[2]; objcaptcha.Password = paramValue[3]; objcaptcha.CaptchaService = paramValue[4]; objcaptcha.Status = "True"; objCaptchaRepositry.UpdateCaptchaStatusForOtherService(objcaptcha); objCaptchaRepositry.UpdateCaptchaSetting(objcaptcha); } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } if (paramValue[0] == "Model : FanPageDataRepository") { try { FanPageData objFanPageData = new FanPageData(); if (paramValue[1] == "Function : Insert") { try { objFanPageData.Id = (paramValue[2]); } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } try { objFanPageData.Name = paramValue[3]; } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } try { objFanPageData.FirstName = paramValue[4]; } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } try { objFanPageData.MiddleName = paramValue[5]; } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } try { objFanPageData.LastName = paramValue[6]; } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } try { objFanPageData.Link = paramValue[7]; } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } try { objFanPageData.Gender = paramValue[8]; } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } try { objFanPageData.Locale = paramValue[9]; } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } try { objFanPageData.ProfileStatus = paramValue[10]; } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } try { objFanPageData.Url = paramValue[11]; } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } try { objFanPageData.ShowUser = paramValue[12]; } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } objFanPageDataRepository.Insert(objFanPageData); } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } } } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } }