public void UpdateCaptchaSetting(faceboardpro.Domain.Captcha Captchasetting)
{
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
var query = session.CreateQuery("Update Captcha set Username = :username,Password= :password , Status= :status where CaptchaService= :captchaservice");
query.SetParameter("username", Captchasetting.Username );
query.SetParameter("password", Captchasetting.Password );
query.SetParameter("status", Captchasetting.Status );
query.SetParameter("captchaservice", Captchasetting.CaptchaService);
int res = query.ExecuteUpdate();
transaction.Commit();
//return res;
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
public ICollection<faceboardpro.Domain.Captcha> GetAllCaptchaSetting(faceboardpro.Domain.Captcha captcha)
{
ICollection<faceboardpro.Domain.Captcha> eCol = null;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
eCol = session.CreateCriteria(typeof(faceboardpro.Domain.Captcha)).List<faceboardpro.Domain.Captcha>();
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
return eCol;
}
public void Update(faceboardpro.Domain.Captcha captcha)
{
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Update(captcha.CaptchaService , captcha);
transaction.Commit();
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
