public int SaveWithTransaction(GigSubscription _object)
{
_object.WithTransaction = "Y";
int _returnValue = base.SaveWithTransaction <GigSubscription>("spAddEditGigSubscription", _object);
return(_returnValue);
}
public JsonResult GigOffer(int GigSubscriptionId, string Status)
{
GigSubscription _GigSubscription = new GigSubscription();
GigSubscriptionModel _GigSubscriptionModel = new GigSubscriptionModel();
Gig _Gig = new Gig();
GigModel _GigModel = new GigModel();
_GigSubscription = _GigSubscriptionModel.GetARecord(GigSubscriptionId);
_GigSubscription.Status = Status;
_Gig = _GigModel.GetARecord(_GigSubscription.GigId);
int UserId = _Gig.UserId;
string GigTitle = _Gig.GigTitle;
if (_GigSubscriptionModel.GigOfferAcceptorDecline(_GigSubscription).FirstOrDefault().JobId > 0)
{
_GigSubscription.JobId = _GigSubscriptionModel.GigOfferAcceptorDecline(_GigSubscription).FirstOrDefault().JobId;
//objNotification.ReceiverId = UserId;
//objNotification.SenderId = Convert.ToInt32(Session["UserId"]);
//objNotification.ReadStatus = 0;
//if (Status == "A")
//{
// objNotification.Notification = "@" + Session["UserName"] + " has accepted your bid for job: " + JobTitle;
// objNotification.Header = "Bid accepted";
//}
//else
//{
// objNotification.Notification = "Your job has been cancelled as it went against the terms of this jobsite";
// objNotification.Header = "Bid cancelled";
//}
//objNotiMod.Save(objNotification);
if (MatchBxCommon.checkuseremailpreferences("2,4", UserId) == true)
{
Users objUser = new Users();
objUser = objUsersMod.GetList("*", " UserId = '" + UserId + "'").FirstOrDefault();
string seekeremail = objUser.Email;
string posterusername = "******" + Session["UserName"].ToString();
string seekerfullname = objUser.FullName != null ? objUser.FullName : objUser.UserName;
if (Status == "A")
{
//MatchBxCommon.sendBidAcceptanceEmail(fullname, username, JobTitle, JobId, email, objJobbidding.BidAmount, false);
}
else
{
MatchBxCommon.sendGigDeclineEmail(seekerfullname, posterusername, GigTitle, seekeremail, false);
}
}
}
else
{
_GigSubscription.JobId = 0;
}
return(Json(_GigSubscription, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveGigSubscription(int GigId, int JobPosterId, string Description, string JobCompletionDate, string Title, int GigSubscriptionId)
{
GigSubscription _GigSubscription = new GigSubscription();
GigSubscriptionModel _GigSubscriptionModel = new GigSubscriptionModel();
string message = "failed";
_GigSubscription.GigId = GigId;
_GigSubscription.JobPosterId = JobPosterId;
_GigSubscription.Description = Description;
_GigSubscription.GigSubscriptionId = GigSubscriptionId;
//CultureInfo culture = new CultureInfo("en-US");
//DateTime tempDate = Convert.ToDateTime(JobCompletionDate, culture);
DateTime tempDate = DateTime.ParseExact(JobCompletionDate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
_GigSubscription.JobCompletionDate = tempDate;
_GigSubscription.IsActive = "Y";
_GigSubscription.GigSubscriptionStatus = "S";
_GigSubscription.Title = Title;
List <GigSubscriptionDocument> fileList = new List <GigSubscriptionDocument>();
List <GigSubscriptionDocument> fileUpdatedList = new List <GigSubscriptionDocument>();
if (TempData["fileList"] != null)
{
fileList = (List <GigSubscriptionDocument>)TempData.Peek("fileList");
}
if (Session["GigSubDocMasterList"] != null)
{
fileUpdatedList = (List <GigSubscriptionDocument>)Session["GigSubDocMasterList"];
}
if (GigId != 0)
{
if (Convert.ToInt32(_GigSubscription.GigSubscriptionDocumentList.Count) == 0)
{
if (fileList != null)
{
foreach (var file in fileList)
{
_GigSubscription.GigSubscriptionDocumentList.Add(new GigSubscriptionDocument()
{
DocumentName = file.DocumentName.ToString(), IsActive = "Y", FileSize = file.FileSize
});
}
}
if (fileUpdatedList != null)
{
foreach (var file in fileUpdatedList)
{
_GigSubscription.GigSubscriptionDocumentList.Add(new GigSubscriptionDocument()
{
DocumentName = file.DocumentName.ToString(), IsActive = file.IsActive, FileSize = file.FileSize, GigSubscriptionDocumentId = file.GigSubscriptionDocumentId, GigSubscriptionId = file.GigSubscriptionId, CreatedDate = file.CreatedDate
});
}
}
}
}
var gigId = 0;
if ((gigId = _GigSubscriptionModel.SaveWithTransaction(_GigSubscription)) > 0)
{
Users _objuser = new Users();
UsersModel objUsersMod = new UsersModel();
if (Convert.ToInt32(Session["UserType"]) == 1)
{
_objuser.UserId = Convert.ToInt32(Session["UserId"]);
_objuser.UserType = "3";
int returnvalue = objUsersMod.ChangeUserRole(_objuser);
if (returnvalue > 0)
{
Session["UserType"] = "3";
}
}
message = "success";
if (MatchBxCommon.checkuseremailpreferences("4,5", Convert.ToInt32(Session["UserId"])) == true)
{
try
{
Gig _objGig = new Gig();
GigModel _objGigModel = new GigModel();
_objGig = _objGigModel.GetARecord(GigId);
_objuser = objUsersMod.GetList("*", " UserId = '" + _objGig.UserId + "'").FirstOrDefault();
string email = _objuser.Email;
string fullname = _objuser.FullName != null ? _objuser.FullName : _objuser.UserName;
MatchBxCommon.sendGigOfferEmail(email, false, Session["UserName"].ToString(), Title, fullname);
}
catch (Exception e)
{
}
}
Session["GigSubDocMasterList"] = null;
Session["GigSubDocList"] = null;
}
return(Json(message, JsonRequestBehavior.AllowGet));
}
public ActionResult Details(int?id, int?subid, string type = "")
{
TempData["TrendingTagsFooter"] = MatchBxCommon.GetTrendingTagsFooter();
TempData["BidMessage"] = "";
TempData["GigAmount"] = "";
TempData["AXPRFeeAmt"] = "0.00";
TempData["AXPRFeeTotAmt"] = "";
TempData["BidAmountinDollar"] = "";
TempData["GigSubscriptionId"] = 0;
TempData["GigCompletionDate"] = "";
TempData["GigTitle"] = string.Empty;
TempData["GigCompletionDate"] = "";
TempData["JobCompletionDateDisplay"] = "";
//Session["Expired"] = "N";
//Session["FromDetails"] = "Y";
Session["GigSubDocMasterList"] = null;
Session["GigSubDocList"] = null;
TempData["NoofDocuments"] = 0;
TempData["GigSubscriptionStatus"] = "S";
dynamic model = new ExpandoObject();
GigModel _GigModel = new GigModel();
GigReviewModel _GigReviewModel = new GigReviewModel();
Gig _Gig = new Gig();
int gigid = id.GetValueOrDefault();
Session["GigId"] = gigid;
Session["SubGigId"] = subid.GetValueOrDefault();
if (gigid != 0)
{
List <Gig> _GigList = MatchBxCommon.GenerateBadgeForGig(_GigModel.GetGigPost(gigid));
if (_GigList.Count() > 0)
{
_GigList.FirstOrDefault().GigSkillsMappingList = _GigModel.GetSkillsByGigId(gigid);
_GigList.FirstOrDefault().GigTrendingTagsMappingList = _GigModel.GetTagsByGigId(gigid);
_Gig = _GigList.FirstOrDefault();
Session["JobPoster"] = _Gig.UserId;
Session["JobCategory"] = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(_Gig.Category.ToLower());
Session["JobCategoryHeader"] = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(_Gig.Category.ToLower());
if (Session["JobCategoryId"] != null && Session["JobCategoryId"].ToString() == "0")
{
Session["JobCategoryName"] = CultureInfo.CurrentCulture.TextInfo.ToTitleCase("ALL SERVICES".ToLower());
}
else
{
Session["JobCategoryName"] = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(_Gig.Category.ToLower());
}
decimal exchangerate = MatchBxCommon.GetExchangeRate();
decimal bid = Convert.ToDecimal(_Gig.BudgetASP);
decimal perc = (Convert.ToDecimal(bid) * 3) / 100;
TempData["AXPRFeeAmt"] = perc.ToString("#,##0.00");
string totalfees = (bid + perc).ToString("#,##0.00");
TempData["AXPRFeeTotAmt"] = totalfees;
TempData["GigAmount"] = _Gig.BudgetASP.ToString() + " AXPR";
//TempData["BidAmountinDollar"] = (Math.Round(exchangerate * (bid + perc), 2)).ToString("#,##0.00");
TempData["BidAmountinDollar"] = (Math.Round(exchangerate * (bid), 2)).ToString("#,##0.00");
UserProfileModel objProfileMod = new UserProfileModel();
UserProfile objProfile = new UserProfile();
objProfile = objProfileMod.LoadUserProfile(_Gig.UserId).FirstOrDefault();
_Gig.ProfilePic = objProfile.ProfilePic;
if (type == "R")
{
var _SubObj = new GigSubscription();
_SubObj.GigId = Convert.ToInt32(id);
_Gig.GigSubscriptionList = new GigSubscriptionModel().GetGigSubscriptions(_SubObj);
}
else if (type == "A")
{
var _SubObj = new GigSubscription();
_SubObj.GigId = Convert.ToInt32(id);
_Gig.GigActiveOrdersList = new GigSubscriptionModel().GetActiveOrders(_SubObj);
}
else if (type == "C")
{
var _SubObj = new GigSubscription();
_SubObj.GigId = Convert.ToInt32(id);
_Gig.GigCompletedOrdersList = new GigSubscriptionModel().GetCompletedOrders(_SubObj);
}
_Gig.GigReviewList = _GigReviewModel.GetReviewForGig(gigid);
if (_Gig.GigReviewList.Count > _RecordDisplay)
{
_Gig.GigReviewList.ForEach(s => s.Isloadmore = 1);
}
else
{
_Gig.GigReviewList.ForEach(s => s.Isloadmore = 0);
}
TempData["ReviewCount"] = _Gig.GigReviewList.Count();
_Gig.GigReviewList = _Gig.GigReviewList.Take(_RecordDisplay).ToList();
try
{
string rating = Adjust(decimal.ToDouble(objProfile.Rating)).ToString();
TempData["Rating"] = rating;
TempData["RatingCount"] = Adjust(decimal.ToDouble(objProfile.RatingCount)).ToString();
if (rating.Contains('.'))
{
string[] parts = rating.Split('.');
TempData["RatingWhole"] = parts[0];
if (parts[1] != null)
{
TempData["RatingFraction"] = parts[1];
}
else
{
TempData["RatingFraction"] = 0;
}
}
else
{
TempData["RatingWhole"] = rating;
TempData["RatingFraction"] = 0;
}
}
catch (Exception ex)
{
}
if (Convert.ToInt32(Session["UserId"]) != _Gig.UserId)
{
if (subid.GetValueOrDefault() > 0)
{
GigSubscription _GigSubscription = new GigSubscription();
GigSubscriptionModel _GigSubscriptionModel = new GigSubscriptionModel();
_GigSubscription.GigSubscriptionId = subid.GetValueOrDefault();
List <GigSubscription> _GigSubscriptionList = _GigSubscriptionModel.LoadSubscriptionDetails(_GigSubscription);
if (_GigSubscriptionList.Count() > 0)
{
TempData["BidMessage"] = _GigSubscriptionList.FirstOrDefault().Description;
TempData["GigTitle"] = _GigSubscriptionList.FirstOrDefault().Title;
TempData["GigCompletionDate"] = _GigSubscriptionList.FirstOrDefault().JobCompletionDate;
TempData["GigSubscriptionId"] = _GigSubscriptionList.FirstOrDefault().GigSubscriptionId;
TempData["JobCompletionDateDisplay"] = _GigSubscriptionList.FirstOrDefault().JobCompletionDateDisplay;
TempData["NoofDocuments"] = _GigSubscriptionList.FirstOrDefault().NoofDocuments;
TempData["GigSubscriptionStatus"] = _GigSubscriptionList.FirstOrDefault().GigSubscriptionStatus;
}
}
}
}
}
return(View("Details", _Gig));
}
public List <GigSubscription> GetCompletedOrders(GigSubscription _obj)
{
return(base.GetCustomFunction <GigSubscription>("spGetCompletedGigSubscription", _obj));
}
public List <GigSubscription> GetActiveOrders(GigSubscription _obj)
{
return(base.GetCustomFunction <GigSubscription>("spGetActiveGigSubscription", _obj));
}
public List <GigSubscription> LoadSubscriptionDetails(GigSubscription _object)
{
List <GigSubscription> _list = base.GetCustomFunction <GigSubscription>("spLoadSubscriptionDetails", _object);
return(_list);
}
public List <GigSubscription> GigOfferAcceptorDecline(GigSubscription _object)
{
List <GigSubscription> _list = base.GetCustomFunction <GigSubscription>("spGigPayAccept", _object);
return(_list);
}
public int Save(GigSubscription _object)
{
int _returnValue = base.Save <GigSubscription>("spAddEditGigSubscription", _object);
return(_returnValue);
}
