public ActionResult EditQuote(string id)
{
SRLogRepository objdata = new SRLogRepository();
QuoteLogRepository _repos = new QuoteLogRepository();
int QuoteId = Convert.ToInt32(id);
QuoteLogViewModel objcre = _repos.GetQuoteRecords(QuoteId);
objcre.CustomerList = objdata.GetCustomer();
objcre.GroupUsersList = objdata.GetGroupUser();
bool bExistEstimator = false;
foreach (var i in objcre.GroupUsersList)
{
if (i.UserName == objcre.Estimator)
{
bExistEstimator = true;
}
}
if (bExistEstimator == false)
{
tblGroupUser g = new tblGroupUser();
g.UserName = objcre.Estimator;
g.Userid = objcre.Estimator;
g.Group_Name = "";
objcre.GroupUsersList.Add(g);
}
objcre.emailids = _repos.GetEmailInfo();
ViewBag.UpdateDisable = false;
if (Convert.ToString(Session["SR_Log_ReadOnly"]) == "True" && Convert.ToString(Session["Bid_Log_ReadOnly"]) == "True")
{
ViewBag.UpdateDisable = true;
}
objcre.Id = QuoteId;
ViewBag.UId = objcre.UID;
ViewBag.QuoteId = objcre.Id;
return(View("Create", objcre));
}
public ActionResult Create()
{
QuoteLogRepository _mainrepo = new QuoteLogRepository();
QuoteLogViewModel objcre = new QuoteLogViewModel();
// QuoteLogRepository objdata = new QuoteLogRepository();
SRLogRepository objdata = new SRLogRepository();
objcre.CustomerList = objdata.GetCustomer();
objcre.GroupUsersList = objdata.GetGroupUser();
objcre.emailids = _mainrepo.GetEmailInfo();
ViewBag.UpdateDisable = false;
objcre.Id = 0;
if (Convert.ToString(Session["SR_Log_ReadOnly"]) == "True" && Convert.ToString(Session["Bid_Log_ReadOnly"]) == "True")
{
ViewBag.UpdateDisable = true;
}
return(View(objcre));
}
public ActionResult Create(QuoteLogViewModel model, FormCollection form)
{
QuoteLogRepository _repo = new QuoteLogRepository();
SRLogRepository objdata = new SRLogRepository();
ModelState.Remove("Id");
if (ModelState.IsValid)
{
SR_Log_DatabaseSQLEntities objdb1 = new SR_Log_DatabaseSQLEntities();
string hdnCustomer = "";
if (string.IsNullOrEmpty(form["hdnCustomer"]) == false)
{
hdnCustomer = Convert.ToString(form["hdnCustomer"]).ToUpper();
}
else
{
hdnCustomer = Convert.ToString(form["hdnCustomer"]);
}
string hdnCustUpdate = Convert.ToString(form["hdnCustUpdate"]);
if (!string.IsNullOrEmpty(hdnCustUpdate))
{
//Add or Update Customer
tblCustomer cu = (from cust in objdb1.tblCustomers
where cust.CustomerName == hdnCustomer
select cust).FirstOrDefault();
CommonFunctions c = new CommonFunctions();
if (cu == null)
{
tblCustomer custad = new tblCustomer();
custad.CustomerName = hdnCustomer;
custad.DateAdded = c.GetCurrentDate();
custad.IsInActive = false;
custad.Notes = null;
objdb1.tblCustomers.Add(custad);
objdb1.SaveChanges();
}
}
model.BidTo = "";
if (string.IsNullOrEmpty(form["hdnCustomer"]) == false)
{
model.BidTo = Convert.ToString(form["hdnCustomer"]).ToUpper();
}
else
{
model.BidTo = Convert.ToString(form["hdnCustomer"]);
}
string strBidAs = "";
if (model.BiddingAsIandC == true)
{
strBidAs = "0#";
}
if (model.BiddingAsElectircal == true)
{
strBidAs = strBidAs + "1#";
}
if (model.BiddingAsPrime == true)
{
strBidAs = strBidAs + "2#";
}
if (model.BiddingAsUnKnown == true)
{
strBidAs = strBidAs + "3#";
}
if (model.BiddingAsNotBidding == true)
{
strBidAs = strBidAs + "4#";
}
if (model.BiddingAsNotQualified == true)
{
strBidAs = strBidAs + "5#";
}
if (model.BiddingAsMechanical == true)
{
strBidAs = strBidAs + "6#";
}
model.BiddingAs = strBidAs;
if (model.DivisionConcord == true)
{
model.Division = "Concord";
}
else if (model.DivisionHanford == true)
{
model.Division = "Hanford";
}
else if (model.DivisionSacramento == true)
{
model.Division = "Sacramento";
}
if (string.IsNullOrEmpty(model.ProjectName) == false)
{
model.ProjectName = model.ProjectName.ToUpper();
}
if (string.IsNullOrEmpty(model.QuoteStatus) == false)
{
model.QuoteStatus = model.QuoteStatus.ToUpper();
}
if (string.IsNullOrEmpty(model.LastFollowupBy) == false)
{
model.LastFollowupBy = model.LastFollowupBy.ToUpper();
}
if (string.IsNullOrEmpty(model.FollowupNote) == false)
{
model.FollowupNote = model.FollowupNote.ToUpper();
}
if (string.IsNullOrEmpty(model.EngineersEstimate) == false)
{
model.EngineersEstimate = model.EngineersEstimate.ToUpper();
}
if (string.IsNullOrEmpty(model.Notes) == false)
{
model.Notes = model.Notes.ToUpper();
}
_repo.UpdateQuoteLog(model);
ViewBag.UId = model.UID;
ViewBag.ID = model.Id;
string dtpLastDateFollowup = "";
if (model.dtpLastDateFollowup == null)
{
dtpLastDateFollowup = "";
}
else
{
dtpLastDateFollowup = Convert.ToDateTime(model.dtpLastDateFollowup).ToString("MM-dd-yyyy");
}
string bidDate = "";
if (model.BidDate == null)
{
bidDate = "";
}
else
{
bidDate = Convert.ToDateTime(model.BidDate).ToString("MM-dd-yyyy");
}
SendQuoteModifyMailSMTP(dtpLastDateFollowup, model.Email, model.BidTo, model.ProjectName, bidDate, model.QuoteStatus, model.LastFollowupBy, model.FollowupNote);
var act = new ActivityRepository();
act.AddActivityLog(Convert.ToString(Session["User"]), "Update Quote", "Create", "Quote " + model.UID + " updated by user " + Convert.ToString(Session["User"]) + ".");
ViewBag.Message = "Record Updated Successfully And Quote Modified Status Mail Sent Succesfully";
}
//BidLogViewModel objcre = new BidLogViewModel();
objdata = new SRLogRepository();
model.CustomerList = objdata.GetCustomer();
model.GroupUsersList = objdata.GetGroupUser();
bool bExistEstimator = false;
foreach (var i in model.GroupUsersList)
{
if (i.UserName == model.Estimator)
{
bExistEstimator = true;
}
}
if (bExistEstimator == false)
{
tblGroupUser g = new tblGroupUser();
g.UserName = model.Estimator;
g.Userid = model.Estimator;
g.Group_Name = "";
model.GroupUsersList.Add(g);
}
ViewBag.UpdateDisable = false;
if (Convert.ToString(Session["SR_Log_ReadOnly"]) == "True" && Convert.ToString(Session["Bid_Log_ReadOnly"]) == "True")
{
ViewBag.UpdateDisable = true;
}
model.emailids = _repo.GetEmailInfo();
return(View("Create", model));
}