/// <UpdateGroup>
/// Update group name
/// </summary>
/// <param name="group">Set the group name in a Groups Class Property and Pass the same Object of Groups Class.(Domain.Groups)</param>
public void UpdateGroup(Domain.Myfashion.Domain.Groups group)
{
//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 action, to update group name.
session.CreateQuery("Update Groups set GroupName =:groupname where UserId = :userid")
.SetParameter("groupname", group.GroupName)
.SetParameter("userid", group.UserId)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
// return 0;
}
} //End Transaction
} //End Session
}
/// <getGroupDetailsbyId>
/// Get the details of Group by user id and group id.
/// </summary>
/// <param name="userid">User id (Guid)</param>
/// <param name="groupname">Id of Group(Guid)</param>
/// <returns>Return the object of group.(Domein.Group)</returns>
public Domain.Myfashion.Domain.Groups getGroupDetailsbyId(Guid userid, Guid groupid)
{
//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
{
NHibernate.IQuery query = session.CreateQuery("from Groups where UserId = :userid and Id=:groupname");
query.SetParameter("userid", userid);
query.SetParameter("groupname", groupid);
Domain.Myfashion.Domain.Groups grou = query.UniqueResult <Domain.Myfashion.Domain.Groups>();
return(grou);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
/// <DeleteGroup>
/// Delete a group of user by profile id , group id and profile id.
/// </summary>
/// <param name="group">Set the group name and user id in a Groups Class Property and Pass the same Object of Groups Class.(Domain.Groups)</param>
/// <returns>Return 1 when Data is deleted Otherwise retun 0. (int)</returns>
public int DeleteGroup(Domain.Myfashion.Domain.Groups group)
{
//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 action, to delete the group data.
NHibernate.IQuery query = session.CreateQuery("delete from Groups where UserId = :userid and GroupName = :name")
.SetParameter("name", group.GroupName)
.SetParameter("userid", group.UserId);
int isUpdated = query.ExecuteUpdate();
transaction.Commit();
return(isUpdated);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
} //End Transaction
} //End Session
}
/// <AddGroup>
/// Add a new group
/// </summary>
/// <param name="group">Set Values in a Groups Class Property and Pass the same Object of Groups Class.(Domain.Groups)</param>
public void AddGroup(Domain.Myfashion.Domain.Groups group)
{
//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 data.
session.Save(group);
transaction.Commit();
} //End Transaction
} //End Session
}
public string GetGroupDetailsByGroupId(string GroupId)
{
logger.Error("GetGroupDetailsByGroupId inside function");
try
{
Domain.Myfashion.Domain.Groups objGroups = grouprepo.getGroupName(Guid.Parse(GroupId));
return(new JavaScriptSerializer().Serialize(objGroups));
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
Console.WriteLine(ex.StackTrace);
return("Something Went Wrong");
}
}
