/// <Add>
/// Add a new invitation in DataBase.
/// </summary>
/// <param name="user">Set Values in a invitation Class Property and Pass the Object of invitation Class (SocioBoard.Domain.Admin).</param>
public int Add(Invitation invitation)
{
int res = 0;
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 data.
session.Save(invitation);
transaction.Commit();
res = 1;
}//End Using trasaction
}//End Using session
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return res;
}
/// < Admin Update>
/// Update a existing admin.
/// </summary>
/// <param name="invitation">Set Values in a Invitation Class Property and Pass the Object of Invitation Class.(Domein.Invitation)</param>
/// <returns>Return integer 1 for true and 0 for false.</returns>
public int SetAllInvitationById(Invitation invitation)
{
int res = 0;
//Creates a database connection and opens up a session
try
{
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.
res = session.CreateQuery("Update Invitation set FriendEmail =:friendEmail, FriendName =: friendName , InvitationBody=:invitationBody, SenderEmail =:senderEmail, SenderName =:senderName, Status =:status, Subject =:subject where Id = :id")
.SetParameter("id", invitation.Id)
.SetParameter("friendEmail", invitation.FriendEmail)
.SetParameter("friendName", invitation.FriendName)
.SetParameter("invitationBody", invitation.InvitationBody)
.SetParameter("senderEmail", invitation.SenderEmail)
.SetParameter("senderName", invitation.SenderName)
.SetParameter("status", invitation.Status)
.SetParameter("subject", invitation.Subject)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}//End Using trasaction
}//End Using session
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return res;
}
/// <GetAllInvitationInfo>
/// Get All Invitation Info
/// </summary>
/// <param name="invitation">Set Values in a Invitation Class Property and Pass the Object of Invitation Class.(Domein.Invitation)</param>
/// <returns>Return a object of Invitation Class with value of each member in form of List type.(List<Invitation>)</returns>
public List<Invitation> GetAllInvitationInfo(Invitation invitation)
{
List<Invitation> lstInvitation = new List<Invitation>();
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())
{
try
{
// Proceed action to Get Data from Query
//Set the parameters to find the specific Data.
lstInvitation = session.CreateQuery("from Invitation")
.SetParameter("id", invitation.Id)
.List<Invitation>().ToList<Invitation>();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}// End using transaction
}//End Using Session
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return lstInvitation;
}
/// <SetInvitationStatusById>
/// Update Invitation Status By Sender Email and Freiend Email
/// </summary>
/// <param name="invitation">Set Values in a Invitation Class Property and Pass the Object of Invitation Class.(Domein.Invitation)</param>
/// <returns>Return integer 1 for true and 0 for false.</returns>
public int SetInvitationStatusBySenderEmailFreiendEmail(Invitation invitation)
{
int res = 0;
//Creates a database connection and opens up a session
try
{
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.
res = session.CreateQuery("Update Invitation set Status =:status where SenderEmail = :senderEmail and FriendEmail = :friendEmail")
.SetParameter("status", invitation.Status)
.SetParameter("senderEmail", invitation.SenderEmail)
.SetParameter("friendEmail", invitation.FriendEmail)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}//End Using trasaction
}//End Using session
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return res;
}
public int AddInvitationInDB(string fname, string lname, string email)
{
int res = 0;
try
{
if (Session["LoggedUser"] != null)
{
SocioBoard.Domain.User user = (User)Session["LoggedUser"];
MailHelper mailhelper = new MailHelper();
string mailpath = HttpContext.Current.Server.MapPath("~/Layouts/Mails/FriendInvitation.htm");
string html = File.ReadAllText(mailpath);
string fromemail = ConfigurationManager.AppSettings["fromemail"];
string usernameSend = ConfigurationManager.AppSettings["username"];
string host = ConfigurationManager.AppSettings["host"];
string port = ConfigurationManager.AppSettings["port"];
string pass = ConfigurationManager.AppSettings["password"];
string urllogin = "******";
//string registrationurl = "http://dev.socioboard.com/Registration.aspx?refid=256f9c69-6b6a-4409-a309-b1f6d1f8e43b";
string registrationurl = "http://dev.socioboard.com/Registration.aspx?refid=" + user.Id;
string Body = mailhelper.InvitationMailByCloudSponge(html, fname + " " + lname, user.EmailId, "", urllogin, registrationurl);
string Subject = "You've been Invited to Socioboard " + email + " Socioboard Account";
#region Add Records in Invitation Table
Invitation objInvitation = new Invitation();
InvitationRepository objInvitationRepository = new InvitationRepository();
objInvitation.Id = Guid.NewGuid();
objInvitation.InvitationBody = Body;
objInvitation.Subject = Subject;
objInvitation.FriendEmail = email;
objInvitation.SenderEmail = user.EmailId;//"*****@*****.**";
objInvitation.FriendName = fname + " " + lname;
objInvitation.SenderName = user.UserName;//"Abhaykumar";
objInvitation.Status = "0";
res = objInvitationRepository.Add(objInvitation);
#endregion
}
//else
//{
// ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Plaese login for this activity!');", true);
//}
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return res;
}
public int SetInvitationStatusAfterSuccessfulRegistration(string refid,string userEmail)
{
int res = 0;
try
{
UserRepository objUserRepository = new UserRepository();
User user = objUserRepository.getUsersById(Guid.Parse(refid));
Invitation objInvitation=new Invitation();
objInvitation.SenderEmail=user.EmailId;
objInvitation.FriendEmail=userEmail;
objInvitation.Status = "12";
InvitationRepository objInvitationRepository = new InvitationRepository();
res = objInvitationRepository.SetInvitationStatusBySenderEmailFreiendEmail(objInvitation);
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
Console.WriteLine(ex.StackTrace);
//Response.Redirect("Home.aspx");
}
return res;
}
