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