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); }