public ActionResult ActivateQuote(string Id) { int nObsoleteId = Convert.ToInt32(Id); tblQuoteLog result = new tblQuoteLog(); SR_Log_DatabaseSQLEntities objdb = new SR_Log_DatabaseSQLEntities(); var quote = (from b in objdb.tblObsolete_Quotes where b.Id == nObsoleteId select b).ToList(); var uid_quotelog = objdb.tblQuoteLogs.OrderByDescending(u => u.UID).FirstOrDefault(); var uid_obsquotelog = objdb.tblObsolete_Quotes.OrderByDescending(u => u.UID).FirstOrDefault(); string bidate = "1/1/1753"; if (quote[0].BidDate != null) { bidate = Convert.ToString(quote[0].BidDate); } result.BidDate = Convert.ToDateTime(bidate); result.BiddingAs = quote[0].BiddingAs; result.BidTo = quote[0].BidTo; result.ProjectName = quote[0].ProjectName; result.Division = quote[0].Division; result.LastAddendumRecvd = quote[0].LastAddendumRecvd; result.Estimator = quote[0].Estimator; result.QuoteNumber = quote[0].QuoteNumber; result.UID = quote[0].UID; result.EngineersEstimate = quote[0].EngineersEstimate; result.Notes = quote[0].Notes; result.JobWalkDate = quote[0].Job_Walk_Date; result.QADeadLineDateTime = quote[0].QADeadLineDateTime; result.QuoteStatus = quote[0].QuoteStatus; result.dtpLastDateFollowup = quote[0].dtpLastDateFollowup; result.LastFollowupBy = quote[0].LastFollowupBy; result.FollowupNote = quote[0].FollowupNote; result.EmailAddress = quote[0].EmailAddress; QuoteLogRepository _repo = new QuoteLogRepository(); _repo.AddActivateQuoteLog(result, "T"); var act = new ActivityRepository(); act.AddActivityLog(Convert.ToString(Session["User"]), "Archived Quote", "Activate Quote ", "Archived Quote " + quote[0].UID.ToString() + " activated by user " + Convert.ToString(Session["User"]) + "."); foreach (var detail in quote) { objdb.tblObsolete_Quotes.Remove(detail); } objdb.SaveChanges(); act.AddActivityLog(Convert.ToString(Session["User"]), "Delete Archived Quote", "Activate Quote ", "Archived Quote " + quote[0].UID.ToString() + " deleted after moving to current by user " + Convert.ToString(Session["User"]) + "."); JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); string result1 = javaScriptSerializer.Serialize(result); return(Json(result1, JsonRequestBehavior.AllowGet)); }
public string AddActivateQuoteLog(tblQuoteLog model, string FlagFollowUp) { // int QuoteId = 0; string resultofquery; using (var context = new SR_Log_DatabaseSQLEntities()) { ObjectParameter result = new ObjectParameter("result", typeof(string)); var bidlog = context.USP_TT_InsertUpdateQuote(model.BidDate, model.BiddingAs, model.BidTo, model.ProjectName, model.LastAddendumRecvd, model.Estimator , model.QuoteNumber, model.UID, model.Notes, model.EngineersEstimate, model.Division, model.MandetoryJobWalk, model.JobWalkDate, model.QADeadLineDateTime, model.QuoteStatus, model.dtpLastDateFollowup, model.LastFollowupBy, model.FollowupNote, model.EmailAddress, "A", FlagFollowUp, result).ToString(); resultofquery = Convert.ToString(result.Value); } return(resultofquery); }