protected void btnSave_Click(object sender, EventArgs e)
{
try
{
Package objPkg = new Package();
if (Request.QueryString["Id"] != null)
objPkg.Id = Guid.Parse(Request.QueryString["Id"].ToString());
else
objPkg.Id = Guid.NewGuid();
objPkg.PackageName = txtPackage.Text;
objPkg.Pricing =double.Parse(txtPricing.Text);
objPkg.EntryDate = DateTime.Now;
objPkg.Status = bool.Parse(ddltatus.SelectedValue);
if (objPkgRepo.checkPackageExists(objPkg.Id))
objPkgRepo.UpdatePackage(objPkg);
else
objPkgRepo.AddPackage(objPkg);
Response.Redirect("ManagePackage.aspx");
}
catch(Exception Err)
{
logger.Error(Err.Message);
Response.Write(Err.StackTrace);
}
}
/// <UpdatePackage>
/// Update Package
/// </summary>
/// <param name="package">Set Values in a Package Class Property and Pass the Object of Package Class.(Domein.Package)</param>
public void UpdatePackage(Package package)
{
//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 data.
session.CreateQuery("Update Package set PackageName =:packagename , Pricing=:pricing, Status=:status where Id = :packageid")
.SetParameter("packagename", package.PackageName)
.SetParameter("pricing", package.Pricing)
.SetParameter("status",package.Status)
.SetParameter("packageid",package.Id)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
// return 0;
}
}//End Transaction
}//End Session
}
public void AddPackage(Package package)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(package);
transaction.Commit();
}
}
}
/// <AddPackage>
/// Add Package
/// </summary>
/// <param name="package">Set Values in a Package Class Property and Pass the Object of Package Class.(Domein.Package)</param>
public void AddPackage(Package package)
{
//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(package);
transaction.Commit();
}//End Transaction
}//End Session
}
/// <summary>
/// to check user reference and update user expiry , userrefrencerelation status
/// created by Abhay Kr 5-3-2014
/// </summary>
/// <param name="RefereeId"></param>
/// <returns></returns>
public bool IsUserReferenceActivated(string RefereeId)
{
//testing
Console.WriteLine("Inside " + RefereeId);
bool ret = false;
try
{
User objUser = new User();
Package objPackage=new Package ();
UserPackageRelation objUserPackageRelation=new UserPackageRelation ();
UserRepository objUserRepository = new UserRepository();
UserPackageRelationRepository objUserPackageRelationRepository = new UserPackageRelationRepository();
UserRefRelation objUserRefRelation = new UserRefRelation();
UserRefRelationRepository objUserRefRelationRepository = new UserRefRelationRepository();
PackageRepository objPackageRepository = new PackageRepository();
objUserRefRelation.ReferenceUserId = (Guid.Parse(RefereeId));
//testing
List<UserRefRelation> check =objUserRefRelationRepository.GetUserRefRelationInfo();
//testing
List<UserRefRelation> lstUserRefRelation = objUserRefRelationRepository.GetUserRefRelationInfoByRefreeId(objUserRefRelation);
if (lstUserRefRelation.Count > 0)
{
if (lstUserRefRelation[0].Status == "0")
{
objUserRefRelation = lstUserRefRelation[0];
objUserRefRelation.Status = "1";
objUser = objUserRepository.getUsersById(lstUserRefRelation[0].ReferenceUserId);
objUser.ExpiryDate = objUser.ExpiryDate.AddDays(30);
objUser.AccountType = "Premium";
objPackage = objPackageRepository.getPackageDetails("Premium");
objUserPackageRelation.Id=Guid.NewGuid();
objUserPackageRelation.UserId=objUser.Id;
objUserPackageRelation.PackageId=objPackage.Id;
objUserPackageRelation.ModifiedDate=DateTime.Now;
objUserPackageRelation.PackageStatus=true;
objUserPackageRelationRepository.AddUserPackageRelation(objUserPackageRelation);
int objUserRepositoryresponse = objUserRepository.UpdateUserExpiryDateById(objUser);
int objUserRefRelationRepositoryresponse = objUserRefRelationRepository.UpdateStatusById(objUserRefRelation);
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
return ret;
}
public void UpdatePackage(Package package)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
session.CreateQuery("Update Package set PackageName =:packagename , Pricing=:pricing, Status=:status where Id = :packageid")
.SetParameter("packagename", package.PackageName)
.SetParameter("pricing", package.Pricing)
.SetParameter("status",package.Status)
.SetParameter("packageid",package.Id)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
// return 0;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
User user = (User)Session["LoggedUser"];
if (!IsPostBack)
{
if (user == null)
Response.Redirect("/Default.aspx");
else
{
#region for You can use only 30 days as Unpaid User
if (user.PaymentStatus.ToLower() == "unpaid")
{
if (!SBUtils.IsUserWorkingDaysValid(user.CreateDate))
{
//cmposecontainer.Attributes.Add("display", "none");
cmposecontainer.Attributes.CssStyle.Add("display", "none");
topbtn.Attributes.CssStyle.Add("display", "none");
}
}
#endregion
//List<Package> lstPackage = new List<Package>();
//PackageRepository packageRepo = new PackageRepository();
//lstPackage = packageRepo.getAllPackage();
//chkdate = user.CreateDate;
//DateTime curDate = DateTime.Now;
//TimeSpan ts = curDate - chkdate;
//datediff = ts.TotalDays;
//if (datediff > 30)
//{
// Response.Redirect("Settings/Billing.aspx");
//}
//UserPackageRelation obj = new UserPackageRelation();
//obj.Id = new Guid();
//obj.UserId = user.Id;
//obj.PackageId = lstPackage[1].Id;
//obj.PackageStatus = true;
//repo.AddUserPackageRelation(obj);
//This Code is used for showing user current package
UserPackageRelationRepository repoUserPackageRelationRepository = new UserPackageRelationRepository();
List<UserPackageRelation> lstUserPackageRelationRepository = new List<UserPackageRelation>();
PackageRepository objPackageRepository = new PackageRepository();
Package objPackage = new Package();
lstUserPackageRelationRepository = repoUserPackageRelationRepository.getUserPackageRelationByUserId(user);
if (lstUserPackageRelationRepository.Count > 0)
{
objPackage = objPackageRepository.getPackageDetailsbyId(lstUserPackageRelationRepository[0].PackageId);
}
//if (user.PaymentStatus == "unpaid")
//{
// daysremaining.InnerHtml = "free " + objPackage.PackageName + " " + datediff + " Days Remaining";
//}
//else if (user.PaymentStatus == "paid")
//{
// daysremaining.InnerHtml = objPackage.PackageName + " Last" + datediff + " Days";
//}
//End This Code is used for showing user current package
try
{
//if (Session["IncomingTasks"] != null)
//{
// incom_tasks.InnerHtml = Convert.ToString((int)Session["IncomingTasks"]);
// incomTasks.InnerHtml = Convert.ToString((int)Session["IncomingTasks"]);
//}
//else
//{
// TaskRepository taskRepo = new TaskRepository();
// ArrayList alst = taskRepo.getAllIncompleteTasksOfUser(user.Id);
// Session["IncomingTasks"] = alst.Count;
//}
TaskRepository taskRepo = new TaskRepository();
ArrayList alst = taskRepo.getAllIncompleteTasksOfUser(user.Id);
Session["IncomingTasks"] = alst.Count;
incom_tasks.InnerHtml = Convert.ToString((int)Session["IncomingTasks"]);
incomTasks.InnerHtml = Convert.ToString((int)Session["IncomingTasks"]);
}
catch (Exception es)
{
logger.Error(es.Message);
Console.WriteLine(es.Message);
}
try
{
if (Session["CountMessages"] != null)
{
incom_messages.InnerHtml = Convert.ToString((int)Session["CountMessages"]);
incomMessages.InnerHtml = Convert.ToString((int)Session["CountMessages"]);
}
else
{
incom_messages.InnerHtml = "0";
incomMessages.InnerHtml = "0";
}
}
catch (Exception sx)
{
logger.Error(sx.Message);
Console.WriteLine(sx.Message);
}
usernm.InnerHtml = "Hello, <a href=\"../Settings/PersonalSettings.aspx\"> " + user.UserName + "</a> ";
if (!string.IsNullOrEmpty(user.ProfileUrl))
{
//Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")";
userimg.InnerHtml = "<a href=\"../Settings/PersonalSettings.aspx\"><img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" height=\"100\" width=\"100\"/></a></a>";
//userinf.InnerHtml = Datetime;
//{
// userimg.InnerHtml = "<a href=\"../Settings/PersonalSettings.aspx\"><img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" height=\"100\" width=\"100\"/></a></a>";
if (user.TimeZone != null)
{
Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")";
userinf.InnerHtml = Datetime;
}
//if (user.TimeZone == null)
//{
// Datetime = DateTime.Now.ToString();
// userinf.InnerHtml = Datetime;
//}
else
{
Datetime = DateTime.Now.ToString();
userinf.InnerHtml = Datetime;
}
}
else
{
//Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")";
userimg.InnerHtml = "<a href=\"../Settings/PersonalSettings.aspx\"><img id=\"loggeduserimg\" src=\"../Contents/img/blank_img.png\" alt=\"" + user.UserName + "\"/></a>";
//userinf.InnerHtml = Datetime;
if (user.TimeZone != null)
{
Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")";
userinf.InnerHtml = Datetime;
}
if (user.TimeZone == null)
{
Datetime = DateTime.Now.ToString();
userinf.InnerHtml = Datetime;
}
}
try
{
GroupRepository grouprepo = new GroupRepository();
List<Groups> lstgroups = grouprepo.getAllGroups(user.Id);
string totgroups = string.Empty;
if (lstgroups.Count != 0)
{
foreach (Groups item in lstgroups)
{
totgroups += "<li><a href=\"../Settings/InviteMember.aspx?q=" + item.Id + "\" id=\"group_" + item.Id + "\"><img src=\"../Contents/img/groups_.png\" alt=\"\" style=\" margin-right:5px;\"/>" + item.GroupName + "</a></li>";
}
inviteRedirect.InnerHtml = totgroups;
}
if (user.AccountType == "SMALL BUSINESS")
tot_acc = 10;
else if (user.AccountType == "CORPORATION")
tot_acc = 20;
else if (user.AccountType == "INDIVIDUAL")
tot_acc = 50;
profileCount = objSocioRepo.getAllSocialProfilesOfUser(user.Id).Count;
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
}
}