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