/// < Admin Update>
/// Update a existing admin.
/// </summary>
/// <param name="user">Set Values in a Admin Class Property and Pass the Object of Admin Class.</param>
public static void Update(SocioBoard.Domain.Admin user)
{
//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())
{
try
{
// Proceed Sction to update Data.
// And Set the reuired paremeters to find the specific values.
int i = session.CreateQuery("Update Admin set Image =:profileurl, UserName =: username , TimeZone=:timezone,FirstName =:first,LastName =:last where Id = :twtuserid")
.SetParameter("twtuserid", user.Id)
.SetParameter("profileurl", user.Image)
.SetParameter("username", user.UserName)
.SetParameter("timezone", user.TimeZone)
.SetParameter("first",user.FirstName)
.SetParameter("last",user.LastName)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}//End Using trasaction
}//End Using session
}
public static void Update(SocioBoard.Domain.Admin user)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
int i = session.CreateQuery("Update Admin set Image =:profileurl, UserName =: username , TimeZone=:timezone,FirstName =:first,LastName =:last where Id = :twtuserid")
.SetParameter("twtuserid", user.Id)
.SetParameter("profileurl", user.Image)
.SetParameter("username", user.UserName)
.SetParameter("timezone", user.TimeZone)
.SetParameter("first",user.FirstName)
.SetParameter("last",user.LastName)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
public static void Add(SocioBoard.Domain.Admin user)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(user);
transaction.Commit();
}
}
}
/// <Add>
/// Add a new admin in DataBase.
/// </summary>
/// <param name="user">Set Values in a Admin Class Property and Pass the Object of Admin Class (SocioBoard.Domain.Admin).</param>
public static void Add(SocioBoard.Domain.Admin user)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start and open Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action to save data.
session.Save(user);
transaction.Commit();
}//End Using trasaction
}//End Using session
}
public void Add(SocioBoard.Domain.LoginLogs loginLogs)
{
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(loginLogs);
transaction.Commit();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.StackTrace);
}
}
/// <Add>
/// Add logging details of user
/// </Add>
/// <param name="loginLogs">Set Values in a LoginLogs Class Property and Pass the Object of LoginLogs Class (SocioBoard.Domain.LoginLogs).</param>
public void Add(SocioBoard.Domain.LoginLogs loginLogs)
{
try
{
//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 save details.
session.Save(loginLogs);
transaction.Commit();
}//End Transaction
}//End Session
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.StackTrace);
}
}
private string RemainingAccount(SocioBoard.Domain.User user)
{
string res = "using " + Session["ProfileCount"].ToString() + " of " + Session["TotalAccount"].ToString();
try
{
SocialProfilesRepository objSocioRepo = new SocialProfilesRepository();
Session["ProfileCount"] = objSocioRepo.getAllSocialProfilesOfUser(user.Id).Count;
res = "using " + Session["ProfileCount"].ToString() + " of " + Session["TotalAccount"].ToString();
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
return res;
}
