public ActionResult ArchieveRecord(string Id)
{
// ObsoleteBidLogViewModel result = new ObsoleteBidLogViewModel();
int nId = Convert.ToInt32(Id);
QuoteLogRepository _repo = new QuoteLogRepository();
tblObsolete_Quote result = new tblObsolete_Quote();
SR_Log_DatabaseSQLEntities objdb = new SR_Log_DatabaseSQLEntities();
var quote = (from b in objdb.tblQuoteLogs
where b.Id == nId
select b).ToList();
string UID = quote[0].UID.ToString();
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.Estimator = quote[0].Estimator;
result.QuoteNumber = quote[0].QuoteNumber;
result.Notes = quote[0].Notes;
result.EngineersEstimate = quote[0].EngineersEstimate;
result.Division = quote[0].Division;
result.UID = quote[0].UID;
result.RedSheet = quote[0].RedSheet;
result.ScopeLetter = quote[0].ScopeLetter;
result.Job_Walk_Date = quote[0].JobWalkDate;
result.QADeadLineDateTime = quote[0].QADeadLineDateTime;
result.Mandatory_Job_Walk = (quote[0].MandetoryJobWalk == null ? false : true);
result.LastAddendumRecvd = quote[0].LastAddendumRecvd;
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;
_repo.AddArchiveQuoteLog(result, "F");
var act = new ActivityRepository();
act.AddActivityLog(Convert.ToString(Session["User"]), "Archive Quote", "ArchieveRecord", "Quote " + quote[0].UID + " archived by user " + Convert.ToString(Session["User"]) + ".");
foreach (var detail in quote)
{
objdb.tblQuoteLogs.Remove(detail);
}
objdb.SaveChanges();
act.AddActivityLog(Convert.ToString(Session["User"]), "Delete Quote", "ArchieveRecord ", " Quote " + UID + " deleted after archiving by user " + Convert.ToString(Session["User"]) + ".");
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
string result1 = javaScriptSerializer.Serialize(result);
return(Json(result1, JsonRequestBehavior.AllowGet));
}
public string AddArchiveQuoteLog(tblObsolete_Quote model, string FlagFollowUp)
{
// int QuoteId = 0;
string resultofquery;
using (var context = new SR_Log_DatabaseSQLEntities())
{
ObjectParameter result = new ObjectParameter("result", typeof(int));
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);
}
