Пример #1
0
        public ActionResult RefereralInfo(AgentReferences objData)
        {
            var data = this._reference.Find(x => x.Id == objData.ReferenceId)
                .Select(x =>
                {
                    var info = new AgentReferences()
                    {
                        ReferenceId = x.Id,
                        FirstName = x.User.FirstName,
                        LastName = x.User.LastName,
                        Email = x.User.Email,
                        Phone = x.User.MobileNumber,
                        Address = x.User.Address,
                        State = x.User.State.HasValue ? x.User.State.Value.ToString() : "0",
                        Note = x.Note,
                        IsContacted = x.IsContacted,
                        IsInstersted = x.IsIntersted.HasValue ? x.IsIntersted.Value ? 1 : 0 : 2,
                        IsAccepted = x.IsResponded,
                        IsPaid = x.IsCommissionPaid
                    };
                    return info;
                }).FirstOrDefault();

            ViewBag.Active = "liReference";
            return View(data);
        }
Пример #2
0
        private List <AgentReferences> GetAllReferals(DateTime?FromDate, DateTime?ToDate)
        {
            var objData = this._reference.FindAll().Where(x => x.CreatedDate >= (FromDate != null ? FromDate:x.CreatedDate) &&
                                                          x.CreatedDate <= (ToDate != null ? ToDate:x.CreatedDate))
                          .Select(x =>
            {
                var data = new AgentReferences()
                {
                    ReferenceId  = x.Id,
                    FirstName    = x.User.FirstName,
                    LastName     = x.User.LastName,
                    Name         = this._userRepository.FindOne(y => y.UserId == x.RefferedBy).FirstName + " " + this._userRepository.FindOne(y => y.UserId == x.RefferedBy).LastName,
                    Email        = x.User.Email,
                    Phone        = x.User.MobileNumber,
                    Address      = x.User.Address,
                    State        = x.User.State.HasValue ? x.User.State.Value.ToString() : "0",
                    Status       = x.Status,
                    IsContacted  = x.IsContacted.HasValue ? x.IsContacted.Value : false,
                    IsInstersted = x.IsIntersted.HasValue ? x.IsIntersted.Value ? 1 : 0 : 2,
                    IsAccepted   = x.IsResponded.HasValue ? x.IsResponded.Value : false,
                    IsPaid       = x.IsCommissionPaid.HasValue ? x.IsCommissionPaid.Value : false
                };
                return(data);
            }).OrderByDescending(x => x.ReferenceId).ToList();

            return(objData);
        }
Пример #3
0
        public ActionResult Reference()
        {
            var objData = this._reference.FindAll()
                .Where(x => x.RefferedBy == UserId)
                .Select(x =>
                {
                    var data = new AgentReferences()
                    {
                        ReferenceId = x.Id,
                        Name = x.User.FirstName + " " + x.User.LastName,
                        Email = x.User.Email,
                        Phone = x.User.MobileNumber,
                        State = x.User.State.ToString(),
                        Status=x.Status
                    };
                    return data;
                }).OrderByDescending(x=>x.ReferenceId).ToList();

            ViewBag.TotalReference = this._reference.FindAll().Where(x => x.RefferedBy == UserId).Count();
            ViewBag.Contacted = this._reference.FindAll().Where(x => x.RefferedBy == UserId && x.IsContacted==true).Count();
            ViewBag.DealAccepted = this._reference.FindAll().Where(x => x.RefferedBy == UserId && x.IsResponded == true).Count();
            ViewBag.Paid = this._reference.FindAll().Where(x => x.RefferedBy == UserId && x.IsCommissionPaid == true).Count();
            ViewBag.NotContacted = this._reference.FindAll().Where(x => x.RefferedBy == UserId && (x.IsContacted == null || x.IsContacted==false)).Count();
            ViewBag.Active = "liReference";
            return View(objData);
        }
Пример #4
0
        /// <summary>
        /// Exports the Data of Referals to the Excel between the Selected Dates. Default will be all,incase no date selected.
        /// </summary>
        /// <param name="objdata"></param>
        /// <returns></returns>
        public ActionResult ExportToExcell(AgentReferences objdata)
        {
            var objData = GetAllReferals(objdata.FromDate != null ? Convert.ToDateTime(objdata.FromDate): (DateTime?)null,
                                         objdata.ToDate != null ? Convert.ToDateTime(objdata.ToDate) : (DateTime?)null);

            System.Data.DataTable dt = new System.Data.DataTable();
            dt.Columns.Add("FirstName", typeof(string));
            dt.Columns.Add("LastName", typeof(string));
            dt.Columns.Add("ReferedBy", typeof(string));
            dt.Columns.Add("Email", typeof(string));
            dt.Columns.Add("Phone", typeof(string));
            dt.Columns.Add("Address", typeof(string));
            dt.Columns.Add("State", typeof(string));
            dt.Columns.Add("Status", typeof(string));

            foreach (var item in objData)
            {
                var rec = dt.NewRow();
                rec["FirstName"] = item.FirstName;
                rec["LastName"]  = item.LastName;
                rec["ReferedBy"] = item.Name;
                rec["Email"]     = item.Email;
                rec["Phone"]     = item.Phone.ToString();
                rec["Address"]   = item.Address;
                rec["State"]     = item.State;
                rec["Status"]    = item.Status;
                dt.Rows.Add(rec);
            }

            var grid = new System.Web.UI.WebControls.GridView();

            grid.DataSource = dt;
            grid.DataBind();

            Response.ClearContent();
            Response.Buffer = true;
            Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
            Response.ContentType = "application/ms-excel";

            Response.Charset = "";
            StringWriter sw = new StringWriter();

            System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

            grid.RenderControl(htw);

            Response.Output.Write(sw.ToString());
            Response.Flush();
            Response.Clear();
            Response.End();

            return(RedirectToAction("Referals"));
        }
Пример #5
0
 public ActionResult RefereralInfo_Post(AgentReferences objdata)
 {
     var data = this._reference.FindOne(x => x.Id == objdata.ReferenceId);
     data.User.Email = objdata.Email;
     data.User.MobileNumber = objdata.Phone;
     data.User.Address = objdata.Address;
     data.User.State =  Convert.ToInt32(objdata.State);
     this._reference.Update(data);
     AgentReferences objRef = new AgentReferences();
     objRef.ReferenceId = objdata.ReferenceId;
     return RedirectToAction("RefereralInfo", objRef);
 }
Пример #6
0
        public ActionResult AddAdminNote(AgentReferences objData)
        {
            var data = new DataAccess.ReferenceNote();

            data.Note        = objData.Note;
            data.ReferenceId = objData.ReferenceId;
            data.CreatedOn   = DateTime.Now;
            this._referenceNotes.Add(data);
            AgentReferences objAgentRef = new AgentReferences();

            objAgentRef.ReferenceId = objData.ReferenceId;
            return(RedirectToAction("RefereralInfo", objAgentRef));
        }
Пример #7
0
 public ActionResult AddReference(AgentReferences objData)
 {
     if (objData.Id!=0)
     {
         var objAgentData = this._reference.FindOne(x => x.Refferee == objData.ReferenceId);
         objData.FirstName = objAgentData.User.FirstName;
         objData.LastName = objAgentData.User.LastName;
         objData.Address = objAgentData.User.Address;
         objData.State = objAgentData.User.State.HasValue ? objAgentData.User.State.Value.ToString() : "0";
         objData.ZipCode = objAgentData.User.PinCode;
     }
     ViewBag.Active = "liReference";
     return View(objData);
 }
Пример #8
0
        public ActionResult Notifications()
        {
            var data = this._reference.FindAll()
                       .Where(x => x.Flag == false)
                       .Select(x =>
            {
                var flagdata = new AgentReferences()
                {
                    ReferenceId = x.Id,
                    ReferedBy   = this._userRepository.FindOne(y => y.UserId == x.RefferedBy).FirstName + " " + this._userRepository.FindOne(y => y.UserId == x.RefferedBy).LastName,
                    Referee     = x.User.FirstName + " " + x.User.LastName,
                    Date        = x.CreatedDate.ToString()
                };
                return(flagdata);
            }).OrderByDescending(x => x.Id).ToList();

            return(PartialView("_Notifications", data));
        }
Пример #9
0
        public ActionResult AddReference_Post(AgentReferences objData)
        {
            DataAccess.Reference objRef = new DataAccess.Reference();
            DataAccess.User objuser = new DataAccess.User();
            //Saves the Details of Referee to the User Table
            objuser.FirstName = objData.FirstName;
            objuser.LastName = objData.LastName;
            objuser.Address = objData.Address;
            objuser.State =  Convert.ToInt32(objData.State);
            objuser.City = objData.City;
            objuser.PinCode = objData.ZipCode;
            objuser.MobileNumber = objData.Phone;
            objuser.IsDeleted = false;
            objuser.Email = objData.Email;
            objuser.IsReference = true;
            this._userRepository.Add(objuser);

            //Saves the Reference Details along with the UserID obtained into the Reference Table
            objRef.Note = objData.Note;
            objRef.RefferedBy = UserId;
            objRef.Refferee = objuser.UserId;
            objRef.IsContacted = false;
            objRef.Flag = false;
            objRef.Status = "Not Yet Contacted";
            objRef.CreatedDate = DateTime.Now;
            this._reference.Add(objRef);

            #region Mailing Asynchronously

            //Asynchronously calls the SendMailToReferences method to send Mail
            AsyncMethodCaller caller = new AsyncMethodCaller(SendMailToReferences);
            //Sends the Mail to the Referee, stating been Refered
            caller.BeginInvoke(objuser.Email, base.Email ,string.Empty,"You have been Refererd","Test Body",null,null);
            //Sends the Mail to the Admin Regarding new notification
            caller.BeginInvoke(Core.BaseModel.AdminMail, string.Empty, string.Empty, "Notification About Referance", "Test Body", null, null);

            #endregion

            ViewBag.Active = "liReference";
            return RedirectToAction("Reference");
        }
Пример #10
0
        public ActionResult RefereralInfo(AgentReferences objData)
        {
            var data = this._reference.Find(x => x.Id == objData.ReferenceId)
                       .Select(x =>
            {
                var info = new AgentReferences()
                {
                    ReferenceId  = x.Id,
                    FirstName    = x.User.FirstName,
                    LastName     = x.User.LastName,
                    Name         = this._userRepository.FindOne(y => y.UserId == x.RefferedBy).FirstName + " " + this._userRepository.FindOne(y => y.UserId == x.RefferedBy).LastName,
                    Email        = x.User.Email,
                    Phone        = x.User.MobileNumber,
                    Address      = x.User.Address,
                    State        = x.User.State.HasValue ? x.User.State.Value.ToString() : "0",
                    Status       = x.Status,
                    Note         = x.Note,
                    IsContacted  = x.IsContacted,
                    IsInstersted = x.IsIntersted.HasValue ? x.IsIntersted.Value ? 1 : 0 : 2,
                    IsAccepted   = x.IsResponded,
                    IsPaid       = x.IsCommissionPaid,
                    Notes        = this._referenceNotes.FindAll().Where(y => y.ReferenceId == x.Id).OrderByDescending(y => y.Id)
                                   .Select(y =>
                    {
                        var notedata = new AdminNotes()
                        {
                            NotesId   = y.Id,
                            CreatedOn = y.CreatedOn.ToString(),
                            Notes     = y.Note
                        };
                        return(notedata);
                    }).ToList()
                };
                return(info);
            }).FirstOrDefault();

            ViewBag.Active = "liReference";
            UpdateFlagBit(objData.ReferenceId);
            return(View(data));
        }
Пример #11
0
 /// <summary>
 /// Updates the Column in the Data Base of Referals ( IsContacted, Is Accepted, Is Paid, Is Intersted )
 /// </summary>
 /// <param name="objData"></param>
 /// <returns></returns>
 public JsonResult UpdateColumn(AgentReferences objData)
 {
     try
     {
         var data = this._reference.Find(x => x.Id == objData.ReferenceId).FirstOrDefault();
         data.IsContacted      = objData.IsContacted;
         data.IsResponded      = objData.IsAccepted;
         data.IsCommissionPaid = objData.IsPaid;
         if (objData.IsInstersted != 2)
         {
             data.IsIntersted = objData.IsInstersted == 1 ?true:false;
         }
         data.Status = objData.Status;
         //data.GetType().GetProperty(objData.Column).SetValue(data, objData.IsChecked);
         this._reference.Update(data);
         return(Json("Success"));
     }
     catch
     {
         return(Json("Fail"));
     }
 }