public ContactSuggestions GetContact() { ContactSuggestions objContact = null; if (Session["UserDetails"] != null) { objContact = new ContactSuggestions(); ContactSuggestion.Models.Source objSource = (ContactSuggestion.Models.Source)Session["UserDetails"]; UserDetails objUserDetails = new UserDetails(); DataTable dtContact = new DataTable(); dtContact = objUserDetails.GetContacts(Convert.ToInt32(objSource.ContactId), null, ""); if (dtContact.Rows.Count > 0) { objContact.SourceId = Convert.ToInt32(dtContact.Rows[0]["SourceId"]); objContact.Source = Convert.ToString(dtContact.Rows[0]["Name"]); objContact.ContactId = Convert.ToInt32(dtContact.Rows[0]["ContactId"]); objContact.Contact = Convert.ToString(dtContact.Rows[0]["ContactName"]); objContact.Location4 = Convert.ToString(dtContact.Rows[0]["LocationId1"]); objContact.Location5 = Convert.ToString(dtContact.Rows[0]["LocationId2"]); objContact.Location6 = Convert.ToString(dtContact.Rows[0]["LocationId3"]); objContact.ContactNumber = Convert.ToString(dtContact.Rows[0]["ContactNumber"]); objContact.ContactComments = Convert.ToString(dtContact.Rows[0]["Comments"]); } ViewBag.ContactComments = objContact.ContactComments; ViewBag.Comments = objContact.Comments; } return(objContact); }
public ActionResult Suggestion(string catId, string SubCatId, string bussiness, string location, int?microCat, bool?isLocal) { ContactSuggestion.Models.Source objSource = (ContactSuggestion.Models.Source)Session["UserDetails"]; DataTable dtContact = new DataTable(); UserDetails objUserDetails = new UserDetails(); ContactSuggestions objContactSuggestions = new ContactSuggestions(); // ViewBag.MySuggesstion = GetMySuggesstion(); dtContact = objUserDetails.GetSuggestionFilters(Convert.ToInt32(catId), Convert.ToInt32(SubCatId), null, objSource.ContactId, "", null, bussiness, isLocal, location, microCat).Tables[0]; IList <ContactSuggestions> items = dtContact.AsEnumerable().Select(row => new ContactSuggestions { ContactNumber = row.Field <string>("ContactNumber"), BusinessName = row.Field <string>("BusinessName"), BusinessContact = row.Field <string>("BusinessContact"), Category = row.Field <string>("CategoryName"), SubCategory = row.Field <string>("SubCategoryName"), Microcategory = row.Field <string>("Microcategory"), SourceName = row.Field <string>("SourceName"), Location1 = row.Field <string>("LocationId1"), CitiLevelBusiness = row.Field <bool>("CitiLevelBusiness"), Comments = row.Field <string>("Comments"), ContactName = row.Field <string>("ContactName"), microcateId = row.Field <int?>("MicrocategoryId"), SubCategoryId = row.Field <int>("SubCategory") }).ToList(); // return View(items.ToList()); return(Json(items, JsonRequestBehavior.AllowGet)); }
public ActionResult SkipVedio(bool skip) { string controllerName = string.Empty; string actionName = string.Empty; ContactSuggestion.Models.Source objSource = (ContactSuggestion.Models.Source)Session["UserDetails"]; UserDetails objUserDetails = new UserDetails(); if (objUserDetails.UpdateSkipVedio(objSource.ContactId, skip)) { if (objSource.Role == 2) { controllerName = "ContactDetails"; actionName = "Create"; } else { controllerName = "ContactDetails"; actionName = "Create"; } } return(Json(new { redirectUrl = Url.Action(actionName, controllerName), isRedirect = true, Message = "" })); }
public ActionResult Index(string ContactName) { ContactSuggestion.Models.Source objSource = (ContactSuggestion.Models.Source)Session["UserDetails"]; DataTable dtLocation = new DataTable(); UserDetails objUserDetails = new UserDetails(); dtLocation = objUserDetails.GetContacts(null, Convert.ToInt32(objSource.SourceId), ""); IList <Contacts> items = dtLocation.AsEnumerable().Select(row => new Contacts { ContactName = row.Field <string>("ContactName"), ContactNumber = row.Field <string>("ContactNumber") }).ToList(); Contacts objContact = new Contacts(); if (ContactName == null) { objContact.ContactsList = items.ToList(); } else { objContact.ContactsList = items.ToList().Where(a => a.ContactName.ToUpper().Contains(ContactName.ToUpper())).ToList(); } return(View(objContact)); }
public ActionResult Create([Bind(Include = "MicroId,Name,SubCateId")] MicroCategory microCategory) { if (ModelState.IsValid) { Session["subCatId"] = null; ContactSuggestion.Models.Source objSource = (ContactSuggestion.Models.Source)Session["UserDetails"]; UserDetails objUserDetails = new UserDetails(); string[] myStrName = microCategory.Name.Split('-'); microCategory.Name = myStrName[0] + " © "; if (myStrName.Length > 1) { microCategory.Name = microCategory.Name + myStrName[1]; } if (objUserDetails.SaveMicroCategory(microCategory.SubCateId, microCategory.Name.Trim(), objSource.SourceId, microCategory.MicroId)) { TempData["Success"] = "Micro category saved successfully."; } else { TempData["Success"] = "Duplicate micro category found."; } ViewBag.MicroCategory = new MicroCategory(); ViewBag.CategoryTab = GetCate(); return(RedirectToAction("Index")); } return(View(microCategory)); }
// GET: SourceContact/Create public ActionResult Create() { Contacts objContact = new Contacts(); ContactSuggestion.Models.Source objSource = (ContactSuggestion.Models.Source)Session["UserDetails"]; if (!objSource.IsInterns) { objContact.ContactSourceId = objSource.SourceId; } ViewBag.Comments = objContact.Comments; if (TempData["Success"] == null) { TempData["Success"] = null; } return(View(objContact)); }
public ActionResult IsValid(int?id) { UserDetails objUserDetails = new UserDetails(); ContactSuggestion.Models.Source objSource = (ContactSuggestion.Models.Source)Session["UserDetails"]; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else { Guid objGuid = Guid.NewGuid(); objUserDetails.VerifySuggesion(Convert.ToInt32(id), objGuid.ToString(), objSource.ContactId); TempData["Success"] = "Validated Successfully!"; return(RedirectToAction("Index")); } }
public ActionResult Create([Bind(Include = "ContactSourceId,ContactName,ContactNumber,Location1,Location2,Location3,Comments,ContactLevelUnderstating,Notification,IsContactDetailsAdded")] Contacts contact) { if (ModelState.IsValid) { if (Session["UserDetails"] != null) { UserDetails objUserDetails = new UserDetails(); contact.ContactNumber = objUserDetails.MobileFormat(contact.ContactNumber); Int64 isNumber = 0; Int64.TryParse(contact.ContactNumber, out isNumber); if (contact.ContactNumber.Length == 10 && isNumber > 0) { if (!string.IsNullOrEmpty(contact.Location1) && !string.IsNullOrEmpty(contact.Location2) && !string.IsNullOrEmpty(contact.Location3)) { contact.IsContactDetailsAdded = true; } if (objUserDetails.SaveContact(contact.ContactSourceId, contact.ContactName, contact.ContactNumber, contact.Location1, contact.Location2, contact.Location3, contact.Comments, contact.ContactLevelUnderstating, contact.Notification, contact.IsContactDetailsAdded)) { TempData["Success"] = "Added Successfully!"; } else { TempData["Success"] = "Duplicate contact!"; } } else { TempData["Success"] = "Invalid contact number!"; return(RedirectToAction("Create", contact)); } Contacts objContact = new Contacts(); ContactSuggestion.Models.Source objSource = (ContactSuggestion.Models.Source)Session["UserDetails"]; objContact.SourceId = objSource.SourceId; return(RedirectToAction("Create", objContact)); } else { return(RedirectToAction("Index", "Login")); } } return(View()); }
public ActionResult Edit([Bind(Include = "MicroId,Name,SubCateId")] MicroCategory microCategory) { ContactSuggestion.Models.Source objSource = (ContactSuggestion.Models.Source)Session["UserDetails"]; UserDetails objUserDetails = new UserDetails(); if (ModelState.IsValid) { Session["subCatId"] = null; if (objUserDetails.SaveMicroCategory(microCategory.SubCateId, microCategory.Name, objSource.SourceId, microCategory.MicroId)) { TempData["Success"] = "Micro category updated successfully."; return(RedirectToAction("Index")); } else { TempData["Success"] = "Duplicate micro category found."; return(RedirectToAction("Index")); } } ViewBag.MicroCategory = new MicroCategory(); ViewBag.CategoryTab = GetCate(); return(View(microCategory)); }
public ActionResult Create([Bind(Include = "CatId,SubCategoryId,MicrocategoryId,ContactId,Text,NotificationType,NotificationTitle,LocationId,NotificationPhoto,ProvdReqdsuggData,ModuleName,RedirectToType")] RequestNotificationViewModel reqSug) { if (ModelState.IsValid) { ContactSuggestion.Models.Source objSource = (ContactSuggestion.Models.Source)Session["UserDetails"]; // UserDetails objUserDetails = new UserDetails(); //string deviceID = string.Empty; //string token = string.Empty; //string type = string.Empty; UserDetails objUserDetails = new UserDetails(); DataTable dtDeviceDetails = new DataTable(); DataTable dtlocation = new DataTable(); DataTable dtDeviceUIDList = new DataTable(); dtDeviceDetails = objUserDetails.GetDeviceDetails(reqSug.ContactId); for (int i = 0; i < dtDeviceDetails.Rows.Count; i++) { if (string.IsNullOrEmpty(reqSug.NotificationPhoto)) { reqSug.NotificationPhoto = "http://tagaboutit.com/Images/phone-display-round-icon.png"; } if (reqSug.NotificationType == "Ranking") { reqSug.RedirectTo = "http://tagaboutit.com/login/Ranking"; } if (reqSug.NotificationType == "ReqAddSug") { reqSug.RedirectTo = "AddSugg"; } if (reqSug.NotificationType == "ProvdReqdsugg") { reqSug.RedirectTo = reqSug.ProvdReqdsuggData; } if (reqSug.NotificationType == "Reqdsuggprovd") { reqSug.RedirectTo = "ViewSugg"; } if (reqSug.NotificationType == "MyDetail") { reqSug.RedirectTo = "MyDetail"; } if (reqSug.NotificationType == "ModYourSug") { reqSug.RedirectTo = "ViewSugg"; } if (Convert.ToInt32(reqSug.RedirectToType) == 1) { reqSug.RedirectTo = reqSug.ModuleName; } if (objUserDetails.SaveNotificationForWebSend(reqSug.UID, reqSug.SubCategoryId, reqSug.MicrocategoryId, reqSug.ContactId, Convert.ToInt32(dtDeviceDetails.Rows[i]["UID"]), reqSug.Text, reqSug.NotificationType, false, reqSug.NotificationTitle, reqSug.LocationId, reqSug.NotificationPhoto, reqSug.RedirectTo, objSource.ContactId, Convert.ToInt32(reqSug.RedirectToType))) { TempData["Success"] = "Added Successfully!"; // deviceID = Convert.ToString(dtDeviceDetails.Rows[i]["DeviceID"]); // type = Convert.ToString(dtDeviceDetails.Rows[i]["Type"]); // token = Convert.ToString(dtDeviceDetails.Rows[i]["Token"]); if (reqSug.NotificationType == "ProvdReqdsugg") { dtDeviceDetails = objUserDetails.GetSourcesToken().Tables[0]; dtDeviceUIDList = objUserDetails.GetSourcesToken().Tables[1]; } else { dtDeviceDetails = objUserDetails.GetSourcesTokenByContactId(reqSug.ContactId).Tables[0]; dtDeviceUIDList = objUserDetails.GetSourcesTokenByContactId(reqSug.ContactId).Tables[1]; } // string[] strSplit = Convert.ToString(dtDeviceDetails.Rows[0]["TokenList"]).Length > 0 ? Convert.ToString(dtDeviceDetails.Rows[0]["TokenList"]).Split('|') : null; PushAndroidNotification(Convert.ToString(dtDeviceDetails.Rows[0]["TokenList"]), reqSug.CatId, reqSug.SubCategoryId, reqSug.MicrocategoryId, reqSug.LocationId, reqSug.NotificationTitle, reqSug.Text, Convert.ToString(dtDeviceUIDList.Rows[0]["UIDList"])); } else { TempData["Success"] = "Some issue found!"; } } if (dtDeviceDetails.Rows.Count == 0) { TempData["Success"] = "No device registered for this contact."; } } RequestNotificationViewModel objRequestNotificationViewModel = new RequestNotificationViewModel(); DataTable dtContact = new DataTable(); UserDetails objUserDetailsForView = new UserDetails(); Category objCategory = new Category(); dtContact = objUserDetailsForView.GetCategory(null, null).Tables[0]; IList <Category> items = dtContact.AsEnumerable().Select(row => new Category { CatId = row.Field <int>("CatId"), Name = row.Field <string>("Name"), SubCategories = GetSubCate(row.Field <int>("CatId")) }).ToList(); FillCityDrodown(); objRequestNotificationViewModel.Categories = items; return(View(objRequestNotificationViewModel)); }
public ActionResult Edit([Bind(Include = "UID, SourceId, ContactId, Category, SubCategory, Microcategory, BusinessName, CitiLevelBusiness, BusinessContact, Location1, Comments, IsAChain, Platform, CityName,ReasonForChange")] ContactSuggestions contactSugg) { int locID = Convert.ToInt32(contactSugg.Location1); int?micorID = null; if (!string.IsNullOrEmpty(contactSugg.Microcategory)) { micorID = Convert.ToInt32(contactSugg.Microcategory); } if (ModelState.IsValid) { string message = string.Empty; // CustomResponseMessage custMessage = new CustomResponseMessage(); ContactSuggestion.Models.Source objSource = (ContactSuggestion.Models.Source)Session["UserDetails"]; UserDetails objUserDetails = new UserDetails(); try { DataTable dtDeviceDetails = objUserDetails.GetSourcesTokenByContactId(contactSugg.ContactId).Tables[0]; DataTable dtDevices = objUserDetails.GetDeviceDetails(contactSugg.ContactId); //ContactSuggestions objContactSugg = GetContact(contactSugg.contactId); contactSugg.BusinessContact = objUserDetails.MobileFormat(contactSugg.BusinessContact); DataTable dtLocation = objUserDetails.GetLocation(Convert.ToInt32(contactSugg.Location1), string.Empty, string.Empty, Convert.ToInt32(contactSugg.CityName)); contactSugg.Location1 = string.IsNullOrEmpty(Convert.ToString(dtLocation.Rows[0]["LocationName"])) ? Convert.ToString(dtLocation.Rows[0]["Suburb"]).Trim() : Convert.ToString(dtLocation.Rows[0]["LocationName"]).Trim() + " - " + Convert.ToString(dtLocation.Rows[0]["Suburb"]).Trim(); contactSugg.Location2 = Convert.ToString(dtLocation.Rows[0]["LocationId"]); contactSugg.Location3 = Convert.ToString(dtLocation.Rows[0]["AreaShortCode"]); if (!string.IsNullOrEmpty(contactSugg.BusinessContact)) { Int64 isNumber = 0; Int64.TryParse(contactSugg.BusinessContact, out isNumber); if (contactSugg.BusinessContact.Length == 10 && isNumber > 0) { if (objUserDetails.UpdateContactSuggestions(Convert.ToInt32(contactSugg.UID), contactSugg.SourceId, contactSugg.ContactId, contactSugg.Category, contactSugg.SubCategory, contactSugg.Microcategory, contactSugg.BusinessName, contactSugg.CitiLevelBusiness, contactSugg.BusinessContact, contactSugg.Location1, contactSugg.Location2, contactSugg.Location3, contactSugg.Comments, "", "", "", "", contactSugg.ContactComments, contactSugg.IsAChain, contactSugg.Platform, Convert.ToInt32(contactSugg.CityName))) { for (int i = 0; i < dtDevices.Rows.Count; i++) { objUserDetails.SaveNotificationForWebSend(0, Convert.ToInt32(contactSugg.SubCategory), micorID, contactSugg.ContactId, Convert.ToInt32(dtDevices.Rows[i]["UID"]), contactSugg.ReasonForChange, "ModYourSug", false, "Suggestion Updated", locID, "Suggestion Updated", "ViewSugg", objSource.ContactId, null); } // custMessage.action = "Success"; // custMessage.message = "Update Successfully!"; TempData["Success"] = "Update Successfully!"; PushAndroidNotification(Convert.ToString(dtDeviceDetails.Rows[0]["TokenList"]), Convert.ToInt32(contactSugg.Category), Convert.ToInt32(contactSugg.SubCategory), Convert.ToInt32(contactSugg.Microcategory), Convert.ToInt32(locID), contactSugg.ReasonForChange, "", "", contactSugg.BusinessName, contactSugg.ContactId.ToString(), contactSugg.UID, contactSugg.ReasonForChange); } else { // custMessage.action = "Failure"; // custMessage.message = "Please choose different Business Name and Location!."; // return Request.CreateResponse(HttpStatusCode.ExpectationFailed, custMessage); TempData["Success"] = "Please choose different Business Name and Location!"; } } else { //// custMessage.action = "Failure"; // custMessage.message = "Invalid Business contact number!"; //return Request.CreateResponse(HttpStatusCode.ExpectationFailed, custMessage); TempData["Success"] = "Invalid Business contact number!"; } } else { if (objUserDetails.UpdateContactSuggestions(Convert.ToInt32(contactSugg.UID), contactSugg.SourceId, contactSugg.ContactId, contactSugg.Category, contactSugg.SubCategory, contactSugg.Microcategory, contactSugg.BusinessName, contactSugg.CitiLevelBusiness, contactSugg.BusinessContact, contactSugg.Location1, contactSugg.Location2, contactSugg.Location3, contactSugg.Comments, "", "", "", "", contactSugg.ContactComments, contactSugg.IsAChain, contactSugg.Platform, Convert.ToInt32(contactSugg.CityName))) { for (int i = 0; i < dtDevices.Rows.Count; i++) { objUserDetails.SaveNotificationForWebSend(0, Convert.ToInt32(contactSugg.SubCategory), micorID, contactSugg.ContactId, Convert.ToInt32(dtDevices.Rows[i]["UID"]), contactSugg.ReasonForChange, "ModYourSug", false, "Suggestion Updated", locID, "Suggestion Updated", "ViewSugg", objSource.ContactId, null); } // custMessage.action = "Success"; // custMessage.message = "Update Successfully!"; TempData["Success"] = "Update Successfully!"; PushAndroidNotification(Convert.ToString(dtDeviceDetails.Rows[0]["TokenList"]), Convert.ToInt32(contactSugg.Category), Convert.ToInt32(contactSugg.SubCategory), Convert.ToInt32(contactSugg.Microcategory), Convert.ToInt32(locID), contactSugg.ReasonForChange, "", "", contactSugg.BusinessName, contactSugg.ContactId.ToString(), contactSugg.UID, contactSugg.ReasonForChange); } else { // custMessage.action = "Failure"; // custMessage.message = "Please choose different Business Name and Location!."; // return Request.CreateResponse(HttpStatusCode.ExpectationFailed, custMessage); TempData["Success"] = "Please choose different Business Name and Location!"; } } } catch (Exception ex) { TempData["Success"] = ex.Message; // custMessage.action = "Failure"; // custMessage.message = ex.Message; //SendEmail(ex.Message, "suggestion PUT"); // return Request.CreateResponse(HttpStatusCode.ExpectationFailed, custMessage); } } FillCategoryDrodown(Convert.ToInt32(contactSugg.Category)); FillSubCateDropdown(Convert.ToInt32(contactSugg.Category), Convert.ToInt32(contactSugg.SubCategory)); FillMicroCateDropdown(Convert.ToInt32(contactSugg.SubCategory), Convert.ToInt32(contactSugg.Microcategory)); FillCityDropdown(Convert.ToInt32(contactSugg.CityName)); FillLocationDropdown(locID, Convert.ToInt32(contactSugg.CityName)); return(View()); }