// public List<Coupon> GetCouponByCouponCode(MandrillAccount MandrillAccount)
//{
// List<MandrillAccount> res = new List<MandrillAccount>();
// 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 get coupon detail by coupon code.
// res = session.CreateQuery("from Coupon u where u.CouponCode = : couponCode")
// .SetParameter("couponCode", MandrillAccount.CouponCode)
// .List<Coupon>().ToList<Coupon>();
// }//End transaction
// }//End session
// }
// catch (Exception ex)
// {
// Console.WriteLine("Error : " + ex.StackTrace);
// }
// return res;
//}
/// <GetCouponByCouponId>
/// Get the coupon detail by coupon Id.
/// </summary>
/// <param name="coupon">Set coupon value in a coupon Property Class and Pass the Object of coupon Class as a paremeter.(SocioBoard.Domain.Admin).</param>
/// <returns>coupon values in the list of coupon properties classes.(List<Domain.Coupon>) </returns>
public MandrillAccount GetMandrillAccountById(MandrillAccount MandrillAccount)
{
//Coupon res = null;
List<MandrillAccount> res = new List<MandrillAccount>();
MandrillAccount objMandrillAccount = new MandrillAccount();
try
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to get coupon detail by coupon id.
res = session.CreateQuery("from MandrillAccount where Id= : id")
.SetParameter("id", MandrillAccount.Id)
.List<MandrillAccount>().ToList<MandrillAccount>();
}//End transaction
}//End session
objMandrillAccount = res[0];
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return objMandrillAccount;
}
public string Add(MandrillAccount MandrillAccount)
{
string res = null;
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 add new row.
session.Save(MandrillAccount);
transaction.Commit();
res = "Added";
}//End transaction
}//End session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return res;
}
public List<MandrillAccount> GetMandrillAccountByMandrillUsernamePassword(MandrillAccount MandrillAccount)
{
//Coupon res = null;
List<MandrillAccount> res = new List<MandrillAccount>();
try
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to get coupon detail by coupon id.
res = session.CreateQuery("from MandrillAccount where UserName= : uname and Password=:pwd")
.SetParameter("uname", MandrillAccount.UserName)
.SetParameter("pwd", MandrillAccount.UserName)
.List<MandrillAccount>().ToList<MandrillAccount>();
}//End transaction
}//End session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return res;
}
public int UpdateMandrillAccount(MandrillAccount MandrillAccount)
{
int res = 0;
try
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to update existing data by coupon id.
res = session.CreateQuery("Update MandrillAccount set UserName=:username,Password=:pwd,Status=:status where Id = :id")
.SetParameter("id", MandrillAccount.Id)
.SetParameter("username", MandrillAccount.UserName)
.SetParameter("pwd", MandrillAccount.Password)
.SetParameter("status", MandrillAccount.Status)
.ExecuteUpdate();
transaction.Commit();
}//End transaction
}//End session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return res;
}