public async Task <Enquiry> Update(Enquiry enquiry) { var response = await _httpClient.PostAsync("Enquiries/Update", new StringContent(JsonConvert.SerializeObject(enquiry), Encoding.UTF8, "application/json")); //await Task.Delay(10000); if (response.StatusCode == HttpStatusCode.OK) { var json = response.Content.ReadAsStringAsync().ConfigureAwait(true) .GetAwaiter() .GetResult(); var enquiries = JsonConvert.DeserializeObject <Enquiry>(json); return(enquiries); } else { var web = await response.Content.ReadAsStringAsync(); Exception ex = JsonConvert.DeserializeObject <Exception>(web); if (ex != null) { throw ex; } } throw new Exception("Failed"); }
//Should Change into ConsultationDetail Page Function public async Task <ActionResult> Cancel(Guid EID) { var DataContext = new ApplicationDbContext(); Enquiry eq = DataContext.Enquirys.SingleOrDefault(e => e.EID.Equals(EID)); //Delete files and posts directly to an enquiry var efs = eq.FilePaths.AsEnumerable().ToList(); DataContext.FilePaths.RemoveRange(efs); var eps = eq.CaseComments.AsEnumerable().ToList(); DataContext.Posts.RemoveRange(eps); //Delete files connected to answers, posts and their files in dsn, and answers to enquiry: var assignment = eq.ExpertAnswer; var aps = assignment.PostsInDsn.AsEnumerable().ToList(); foreach (Post dpost in aps) { var pfs = dpost.FilePaths.AsEnumerable().ToList(); DataContext.FilePaths.RemoveRange(pfs); } DataContext.Posts.RemoveRange(aps); DataContext.Answers.Remove(assignment); DataContext.Enquirys.Remove(eq); DataContext.SaveChanges(); return(RedirectToAction("Consult", new { page = 1 })); }
public ActionResult Index(Enquiry enq) { string connectionString = null; string sql = null; connectionString = @"Data Source=.\SQLEXPRESS; Initial Catalog=Assignment2; Trusted_Connection=True"; using (SqlConnection cnn = new SqlConnection(connectionString)) { sql = "insert into Enquiry (Email, [Message]) values (@Email, @Message)"; cnn.Open(); using (SqlCommand cmd = new SqlCommand(sql, cnn)) { cmd.Parameters.AddWithValue("@Email", enq.Email); cmd.Parameters.AddWithValue("@Message", enq.Message); if (ModelState.IsValid) { cmd.ExecuteNonQuery(); cnn.Close(); ViewBag.Message = "1"; return(RedirectToAction("Index")); } return(View(enq)); } } }
/// <summary> /// The example below shows how to Select the EnquiryId and StudentName columns for use with a with a Drop Down List, Combo Box, Checked Box List, List View, List Box, etc /// </summary> private void SelectEnquiryDropDownListData() { List <Enquiry> objEnquiryCol = Enquiry.SelectEnquiryDropDownListData(); // Example 1: directly bind to a drop down list - for ASP.NET Web Forms // DropDownList ddl1 = new DropDownList(); // ddl1.DataValueField = "EnquiryId"; // ddl1.DataTextField = "StudentName"; // ddl1.DataSource = objEnquiryCol; // ddl1.DataBind(); // Example 2: add each item through a loop - for ASP.NET Web Forms // DropDownList ddl2 = new DropDownList(); // foreach (Enquiry objEnquiry in objEnquiryCol) // { // ddl2.Items.Add(new ListItem(objEnquiry.StudentName, objEnquiry.EnquiryId.ToString())); // } // Example 3: bind to a combo box. for Windows Forms (WinForms) // ComboBox cbx1 = new ComboBox(); // foreach (Enquiry objEnquiry in objEnquiryCol) // { // cbx1.Items.Add(new ListItem(objEnquiry.StudentName, objEnquiry.EnquiryId.ToString())); // } }
public async Task <IActionResult> Edit(int id, [Bind("EnquiryId,Email,Message")] Enquiry enquiry) { if (id != enquiry.EnquiryId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(enquiry); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!EnquiryExists(enquiry.EnquiryId)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(enquiry)); }
private string makeQuery(Enquiry searchFilter) { IList <string> conditionList = new List <string>(); string query = "where "; foreach (var prop in searchFilter.GetType().GetProperties()) { if (prop.GetValue(searchFilter, null) != null) { if ((prop.PropertyType.FullName == "System.Int32") && ((int)prop.GetValue(searchFilter, null) != 0)) { conditionList.Add(prop.Name + "=" + prop.GetValue(searchFilter, null)); } else if ((prop.PropertyType.FullName == "System.String") && (prop.GetValue(searchFilter, null).ToString() != "")) { conditionList.Add(prop.Name + "='" + prop.GetValue(searchFilter, null) + "'"); } } } if (conditionList.Count > 1) { foreach (string condition in conditionList) { query += condition + " or "; } } else if (conditionList.Count == 1) { query += conditionList[0]; } string queryWithoutEnd = query.Substring(0, query.LastIndexOf(" or ")); return(queryWithoutEnd); }
public ActionResult ClientRegister(ClientRegister form) { ClientRegister details = new ClientRegister(); details = form; int enqID = Convert.ToInt32(TempData["EnquiryIdClient"]); //RegisterModel regMod = new RegisterModel(); //AccountController accController = new AccountController(); Enquiry enq = new Enquiry(); enq = enquiryRepository.Find(enqID); //regMod.UserName = enq.Contact.ContactEmail; string Password = PasswordGeneration(enq.Contact.ContactName, enq.Contact.MobileNumber); //regMod.Email = enq.Contact.ContactEmail; //accController.Register(regMod); MembershipCreateStatus createStatus; CodeFirstMembershipProvider provider = new CodeFirstMembershipProvider(); provider.CreateAccount(enq.Contact.ContactEmail, Password, enq.Contact.ContactEmail, out createStatus); CodeFirstRoleProvider roleProvider = new CodeFirstRoleProvider(); if (createStatus == MembershipCreateStatus.Success) { if (!roleProvider.RoleExists("Client")) { roleProvider.CreateRole("Client"); } string[] roles = { "Client" }; string[] users = {enq.Contact.ContactEmail.ToString()}; roleProvider.AddUsersToRoles(users, roles); } details.EnquiryID = Convert.ToInt32(TempData["EnquiryIdClient"]); details.ContactID = enq.ContactID; // Please see this--Pankaj clientRegisterRepository.InsertOrUpdate(details); clientRegisterRepository.Save(); return RedirectToAction("Details", new { id = details.EnquiryID }); }
public void Save(Enquiry enquiry) { try { Trace.TraceInformation("Entered DataAccess.Save method"); //Parse the connection string StorageConnectionString CloudStorageAccount storageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageConnectionString")); //Create the Queue Service Client CloudQueueClient queueClient = storageAccount.CreateCloudQueueClient(); //Get a reference to the queue - it must be lowercase!!!! else bad request 400 error CloudQueue queue = queueClient.GetQueueReference("enquiries"); queue.CreateIfNotExists(); string enq = JsonConvert.SerializeObject(enquiry); Trace.TraceInformation("Saving this object:" + enq); CloudQueueMessage msg = new CloudQueueMessage(enq); queue.AddMessage(msg); } catch (Exception ex) { Trace.TraceError("Error in saving the enquiry to the queue: " + ex.ToString()); } }
public async Task <IActionResult> AddNewEnquiryAsync([FromForm] CustomerEnquiryDto customerEnquiry) { string attachmentUrl = string.Empty; string fileTempPath = string.Empty; if (customerEnquiry.Attachment != null) { var fileName = $"{Guid.NewGuid()}-{customerEnquiry.Attachment.FileName}"; fileTempPath = @$ "{Path.GetTempPath()}{fileName}"; using var stream = new FileStream(fileTempPath, FileMode.Create, FileAccess.ReadWrite); await customerEnquiry.Attachment.CopyToAsync(stream); attachmentUrl = await _blobStorageService.UploadBlobAsync(stream, fileName); } var enquiry = new Enquiry { Id = Guid.NewGuid().ToString(), Title = customerEnquiry.Title, Content = customerEnquiry.Content, CustomerContactEmail = customerEnquiry.CustomerContactEmail, AttachmentUrl = attachmentUrl }; var createdEnquiry = await _enquiryRepository.AddAsync(enquiry); if (!string.IsNullOrEmpty(fileTempPath)) { System.IO.File.Delete(fileTempPath); } return(Ok(createdEnquiry)); }
public ActionResult Edit(Enquiry enquiry) { using (TranyrLogisticsDb db = new TranyrLogisticsDb()) { var currentEnquiry = db.Enquiries.Find(enquiry.ID); if (enquiry is ExistingCustomerEnquiry) { ((ExistingCustomerEnquiry)enquiry).CustomerID = ((ExistingCustomerEnquiry)currentEnquiry).CustomerID; } enquiry.VerificationSent = currentEnquiry.VerificationSent; enquiry.QuotationRequested = currentEnquiry.QuotationRequested; enquiry.QuotationSent = currentEnquiry.QuotationSent; enquiry.CreateDate = currentEnquiry.CreateDate; enquiry.CreatedBy = currentEnquiry.CreatedBy; enquiry.AssignedTo = currentEnquiry.AssignedTo; enquiry.StatusIndex = currentEnquiry.StatusIndex; } enquiry.ModifiedDate = DateTime.Now; if (ModelState.IsValid) { db.Entry(enquiry).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.OriginCountryID = new SelectList(db.Countries.OrderBy(x => x.Name), "ID", "Name"); ViewBag.DestinationCountryID = new SelectList(db.Countries.OrderBy(x => x.Name), "ID", "Name"); return(View(enquiry)); }
public ActionResult RequestQuotation(int enquiry_id, int group_id, string subject, string message_body) { Enquiry enquiry = db.Enquiries.Find(enquiry_id); var serviceProviders = db.ServiceProviders.Where(x => x.ServiceProviderGroupID == group_id); List <string> sendTo = new List <string>(); foreach (ServiceProvider serviceProvider in serviceProviders) { sendTo.Add(serviceProvider.EmailAddress); } if (sendTo.Count > 0) { try { EmailTemplate.Send(sendTo, "*****@*****.**", subject, EmailTemplate.FinalizeHtmlEmail(message_body), true); enquiry.QuotationRequested = true; } catch { return(RedirectToAction("Error")); } db.SaveChanges(); } ViewBag.group_id = new SelectList(db.ServiceProviderGroups, "ID", "Name"); return(RedirectToAction("Index")); }
/// <summary> /// Handler, updates a record. /// </summary> public IActionResult OnGetUpdate(string serializedData) { Enquiry objEnquiry = JsonConvert.DeserializeObject <Enquiry>(serializedData); EnquiryFunctions.AddOrEdit(objEnquiry, CrudOperation.Update, true); return(new JsonResult(true)); }
public void OpenBooking(Enquiry enquiries) { EnquiryBookingViewModel enquiryBookingViewModel = new EnquiryBookingViewModel(enquiries); EnquiryBooking eb = new EnquiryBooking(enquiryBookingViewModel); eb.ShowDialog(); }
public static string ReplyTranslation(long followId, long translationId, string targetContent, Manager currentManager, string filePath) { EmailFollow emailFollow = emailFollowRepository.GetById(followId); EmailTranslation emailTranslation = emailTranslationRepository.GetById(translationId); if (emailFollow != null) { emailFollow.TargetContent = targetContent; emailFollow.HandleManagerId = currentManager.Id; emailFollow.TargetFilePath = filePath; emailTranslation.ReceiverStatus = EmailStatusEnum.HasRead; emailTranslation.FollowTimes = emailTranslation.FollowTimes + 1; emailTranslation.SenderStatus = EmailStatusEnum.UnRead; emailTranslationRepository.Save(emailTranslation); emailFollowRepository.Save(emailFollow); if (emailTranslation.EnquiryId > 0) { Enquiry enquiry = enquiryRepository.GetById(emailTranslation.EnquiryId); if (enquiry != null) { enquiry.FollowUpTimes = enquiry.FollowUpTimes + 1; enquiry.EmailStatus = EmailStatusEnum.UnRead; enquiryRepository.Save(enquiry); } } return(ResponseCode.Ok); } return(ResponseCode.NotFoundData); }
/// <summary> /// Handler, deletes a record. /// </summary> public IActionResult OnGetRemove(int id) { Enquiry Enquiry = Enquiry.SelectByPrimaryKey(id); Enquiry.Delete(id); return(new JsonResult(true)); }
private string GetTechnicalCommitteeName(Enquiry src, ResolutionContext context) { var TechnicalCommitteeName = ""; if (bool.Parse(context.Options.Items["statusFlag"].ToString()) == true) { return(""); } if (!context.Options.Items.Keys.Contains("userIdFlag")) { return(""); } var userId = int.Parse(context.Options.Items["userIdFlag"].ToString()); var TechnicalCommitteNameForTender = src.Tender.TechnicalOrganization.CommitteeName; var TechnicalCommitteIdsForUser = src.Tender.TechnicalOrganization.CommitteeUsers.Any(x => x.UserProfileId == userId); if (TechnicalCommitteIdsForUser) { TechnicalCommitteeName = TechnicalCommitteNameForTender; } else { TechnicalCommitteeName = src.JoinTechnicalCommittees.Where(t => t.Committee.CommitteeUsers.Any(x => x.UserProfileId == userId) && t.IsActive == true).Select(t => t.Committee.CommitteeName).FirstOrDefault(); } return(TechnicalCommitteeName); }
public ActionResult SendQuotation(int id) { Enquiry enquiry = db.Enquiries.Find(id); if (enquiry is ExistingCustomerEnquiry) { ((ExistingCustomerEnquiry)enquiry).Customer = db.Customers.Where(x => x.CustomerNumber == ((ExistingCustomerEnquiry)enquiry).CustomerNumber).FirstOrDefault(); } Quotation quotation = new Quotation(); quotation.EnquiryID = enquiry.ID; if (enquiry is PotentialCustomerEnquiry) { ViewBag.ToCustomer = ((PotentialCustomerEnquiry)enquiry).DisplayName; ViewBag.ToEmail = ((PotentialCustomerEnquiry)enquiry).EmailAddress; } else if (enquiry is ExistingCustomerEnquiry) { ViewBag.ToCustomer = ((ExistingCustomerEnquiry)enquiry).Customer.DisplayName; ViewBag.ToEmail = ((ExistingCustomerEnquiry)enquiry).Customer.EmailAddress; } ViewBag.MessageTemplate = EmailTemplate.PerpareSendQuotationEmail(enquiry, @"~\views\EmailTemplate\SendQuotationEmail.html.cshtml"); return(View(quotation)); }
public IList <Enquiry> getAllEnquiry([FromUri] Enquiry searchFilter) { string conditons = ""; if (searchFilter != null) { conditons = makeQuery(searchFilter); } List <Enquiry> enquiryList = new List <Enquiry>(); using (MySqlConnection conn = new MySqlConnection(connection.MySQLConnectionString)) { conn.Open(); using (MySqlCommand cmd = new MySqlCommand(("SELECT * FROM myloanworld.enquiry " + conditons), conn)) { using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { enquiryList.Add(new Enquiry() { EnquiryId = Convert.ToInt16(reader["enquiryId"]), Name = reader["name"].ToString(), ContactNumber = reader["contactNumber"].ToString(), LoanAmt = ((reader["loanAmt"]) is DBNull) ? (int?)null: Convert.ToInt16(reader["loanAmt"]), Comments = reader["comments"].ToString() }); } } } conn.Close(); } return(enquiryList); }
public ActionResult SendCustomerConfirmation(int id = 0) { Enquiry enquiry = db.Enquiries.Find(id); if (enquiry is PotentialCustomerEnquiry) { return(RedirectToAction("Error")); } enquiry.OriginCountry = db.Countries.Find(enquiry.OriginCountryID); enquiry.DestinationCountry = db.Countries.Find(enquiry.DestinationCountryID); ViewBag.group_id = new SelectList(db.ServiceProviderGroups, "ID", "Name"); ViewBag.OriginCountryID = new SelectList(db.Countries.OrderBy(x => x.Name), "ID", "Name", enquiry.OriginCountryID); ViewBag.DestinationCountryID = new SelectList(db.Countries.OrderBy(x => x.Name), "ID", "Name", enquiry.DestinationCountryID); CustomerConfirmation customerTransportOrder = new CustomerConfirmation(); customerTransportOrder.EnquiryID = enquiry.ID; var customer = db.Customers.Find(((ExistingCustomerEnquiry)enquiry).CustomerID); ((ExistingCustomerEnquiry)enquiry).Customer = customer; ViewBag.ToCustomer = ((ExistingCustomerEnquiry)enquiry).Customer.DisplayName; ViewBag.ToEmail = ((ExistingCustomerEnquiry)enquiry).Customer.EmailAddress; ViewBag.MessageTemplate = EmailTemplate.PrepareCustomerConfirmationEmail(enquiry, @"~\views\EmailTemplate\CustomerConfirmationEmail.html.cshtml"); return(View(customerTransportOrder)); }
// GET: Quotes/Create public ActionResult Create(int?enquiryId) { var userId = User.Identity.GetUserId <int>(); Enquiry enquiry = db.Enquiries.Find(enquiryId); if (enquiryId == null) { if (userManager.IsInRole(userId, "Admin") || userManager.IsInRole(userId, "EnquiryManager")) { ViewBag.EnquiryList = new SelectList(db.Enquiries, "EnquiryId", "DisplayName"); } else { // send user back to the index TempData["ErrorMessage"] = "Please select an enquiry and click the link to create a quote"; return(RedirectToAction("Index", "Quotes")); } } else { Enquiry selectedEnquiry = db.Enquiries.SingleOrDefault(a => a.EnquiryId == enquiryId); ViewBag.Enquiry = selectedEnquiry; } return(View()); }
public static void ChangeEmailTranslationStatus(EmailTranslation emailTranslation, Manager currentManager) { if (emailTranslation != null) { if (emailTranslation.ReceiverStatus == EmailStatusEnum.UnRead && currentManager.ManagerType == ManagerTypeEnum.Super && emailTranslation.HandlerManagerId == currentManager.Id) { emailTranslation.ReceiverStatus = EmailStatusEnum.HasRead; } if (emailTranslation.SenderStatus == EmailStatusEnum.UnRead && currentManager.ManagerType == ManagerTypeEnum.Common && emailTranslation.FollowId == currentManager.Id) { emailTranslation.SenderStatus = EmailStatusEnum.HasRead; } emailTranslationRepository.Save(emailTranslation); if (emailTranslation.EnquiryId > 0) { Enquiry enquiry = enquiryRepository.GetById(emailTranslation.EnquiryId); if (enquiry != null) { enquiry.EmailStatus = EmailStatusEnum.HasRead; enquiryRepository.Save(enquiry); } } } }
public async Task <IActionResult> PutEnquiry(int id, Enquiry enquiry) { if (id != enquiry.EnquiryId) { return(BadRequest()); } _context.Entry(enquiry).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!EnquiryExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public static string PerpareSendQuotationEmail(Enquiry enquiry, string templatePath) { string readTemplateFile = string.Empty; using (StreamReader streamReader = new StreamReader(System.Web.HttpContext.Current.Server.MapPath(templatePath))) { readTemplateFile = streamReader.ReadToEnd(); if (enquiry is PotentialCustomerEnquiry) { readTemplateFile = readTemplateFile.Replace("$$FIRST_NAME$$", ((PotentialCustomerEnquiry)enquiry).FirstName); } else if (enquiry is ExistingCustomerEnquiry) { if (((ExistingCustomerEnquiry)enquiry).Customer is Individual) { readTemplateFile = readTemplateFile.Replace("$$FIRST_NAME$$", (((Individual)((ExistingCustomerEnquiry)enquiry).Customer)).FirstName); } else if (((ExistingCustomerEnquiry)enquiry).Customer is Company) { readTemplateFile = readTemplateFile.Replace("$$FIRST_NAME$$", "Sir/Madam"); } } } return(readTemplateFile); }
public async Task <IActionResult> Edit(Enquiry enquiry) { if (ModelState.IsValid) { // if (enquiry.CityId <= 0 || enquiry?.CityId == null) // { // ModelState.AddModelError(string.Empty, "Please select city and try again."); // ViewBag.StateId = new SelectList(_repository.States, "Id", "StateName", enquiry.StateId); // ViewBag.CityId = new SelectList(_repository.Cities, "Id", "CityName", enquiry.CityId); // return View(enquiry); // } var user = await _userManager.GetUserAsync(User); enquiry.UpdatedBy = user.UserName; enquiry.UpdatedDate = DateTime.Now; _repository.Entry(enquiry).State = EntityState.Modified; await _repository.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.StateId = new SelectList(_repository.States, "Id", "StateName", enquiry.StateId); ViewBag.CityId = new SelectList(_repository.Cities, "Id", "CityName", enquiry.CityId); return(View(enquiry)); }
public static string PerpareQuotationRequestEmail(Enquiry enquiry, string templatePath) { string readTemplateFile = string.Empty; using (StreamReader streamReader = new StreamReader(System.Web.HttpContext.Current.Server.MapPath(templatePath))) { readTemplateFile = streamReader.ReadToEnd(); readTemplateFile = readTemplateFile.Replace("$$CATEGORY$$", HtmlDropDownExtensions.GetEnumDisplay(enquiry.Category)); readTemplateFile = readTemplateFile.Replace("$$GOODS_DESCRIPTION$$", enquiry.GoodsDescription); readTemplateFile = readTemplateFile.Replace("$$PLANNED_SHIPMENT_DATE$$", enquiry.PlannedShipmentTime.ToLongDateString()); readTemplateFile = readTemplateFile.Replace("$$ORIGIN_CITYY$$", enquiry.OriginCity); readTemplateFile = readTemplateFile.Replace("$$ORIGIN_COUNTRY$$", enquiry.OriginCountry.Name); readTemplateFile = readTemplateFile.Replace("$$DESTINATION_CITY$$", enquiry.DestinationCity); readTemplateFile = readTemplateFile.Replace("$$DESTINATION_COUNTRY$$", enquiry.DestinationCountry.Name); readTemplateFile = readTemplateFile.Replace("$$NUMBER_OF_PACKAGES$$", enquiry.NumberOfPackages.ToString()); readTemplateFile = readTemplateFile.Replace("$$GROSS_WEIGHT$$", enquiry.GrossWeight.ToString()); readTemplateFile = readTemplateFile.Replace("$$VOLUMETRIC_WEIGHT$$", enquiry.VolumetricWeight.ToString()); if (enquiry.InsuranceRequired) { readTemplateFile = readTemplateFile.Replace("$$INSURANCE_REQUIRED$$", "is insured"); } } return(readTemplateFile); }
/// <summary> /// Gets the list of data for use by the jqgrid plug-in /// </summary> public IActionResult OnGetGridData(string sidx, string sord, int _page, int rows, bool isforJqGrid = true) { int totalRecords = Enquiry.GetRecordCount(); int startRowIndex = ((_page * rows) - rows); List <Enquiry> objEnquiryCol = Enquiry.SelectSkipAndTake(rows, startRowIndex, sidx + " " + sord); int totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); if (objEnquiryCol is null) { return(new JsonResult("{ total = 0, page = 0, records = 0, rows = null }")); } var jsonData = new { total = totalPages, _page, records = totalRecords, rows = ( from objEnquiry in objEnquiryCol select new { id = objEnquiry.EnquiryId, cell = new string[] { objEnquiry.EnquiryId.ToString(), objEnquiry.CourseId.ToString(), objEnquiry.StudentName, objEnquiry.ContactNo.ToString(), objEnquiry.Comments } }).ToArray() }; return(new JsonResult(jsonData)); }
//For Enquiry create partial view in index public ActionResult Enquiry() { Enquiry enq = new Enquiry(); enq.DateTime = System.DateTime.Now; return(View(enq)); }
/// <summary> /// Shows how to Select all records. It also shows how to sort, bind, and loop through records. /// </summary> private void SelectAll() { // select all records List <Enquiry> objEnquiryCol = Enquiry.SelectAll(); // Example 1: you can optionally sort the collection in ascending order by your chosen field objEnquiryCol.Sort(Enquiry.ByCourseId); // Example 2: to sort in descending order, add this line to the Sort code in Example 1 objEnquiryCol.Reverse(); // Example 3: directly bind to a GridView - for ASP.NET Web Forms // GridView grid = new GridView(); // grid.DataSource = objEnquiryCol; // grid.DataBind(); // Example 4: loop through all the Enquiry(s) foreach (Enquiry objEnquiry in objEnquiryCol) { int enquiryId = objEnquiry.EnquiryId; int courseId = objEnquiry.CourseId; string studentName = objEnquiry.StudentName; Int64 contactNo = objEnquiry.ContactNo; string comments = objEnquiry.Comments; // get the Enquiry related to EnquiryId. Enquiry objEnquiryRelatedToEnquiryId = Enquiry.SelectByPrimaryKey(enquiryId); // get the Couse related to CourseId. Couse objCouseRelatedToCourseId = objEnquiry.CourseIdNavigation; } }
private bool?IsJoinedCommittee(Enquiry src, ResolutionContext context) { bool?TechnicalCommitteeId; if (bool.Parse(context.Options.Items["statusFlag"].ToString()) == true) { return(null); } if (!context.Options.Items.Keys.Contains("userIdFlag")) { return(null); } var userId = int.Parse(context.Options.Items["userIdFlag"].ToString()); var TechnicalCommitteIdForTender = src.Tender.TechnicalOrganizationId.Value; var TechnicalCommitteIdsForUser = src.Tender.TechnicalOrganization.CommitteeUsers.Any(x => x.UserProfileId == userId); //var TechnicalCommitteIdsForUser = src.Tender.TechnicalOrganization.CommitteeUsers.Where(x => x.UserProfileId == userId).Select(x => x.CommitteeId).ToList(); if (TechnicalCommitteIdsForUser) { TechnicalCommitteeId = false; } else { TechnicalCommitteeId = true; } return(TechnicalCommitteeId); }
public ActionResult showEnquiryDetail(string EnquiryID) { Enquiry enquiry = new Enquiry(); using (DBClass context = new DBClass()) { context.AddParameter("@EnquiryID", EnquiryID); DataTable dt = context.getData("getEnquiryDetailByID", CommandType.StoredProcedure); if (dt.Rows.Count > 0) { enquiry.UserName = Convert.ToString(dt.Rows[0]["uName"]); enquiry.company = Convert.ToString(dt.Rows[0]["uCompanyName"]); enquiry.phone = Convert.ToString(dt.Rows[0]["uMobile_No"]); enquiry.emailid = Convert.ToString(dt.Rows[0]["Email_ID"]); enquiry.EnquiryID = Convert.ToString(dt.Rows[0]["ID"]); enquiry.Country = Convert.ToString(dt.Rows[0]["Country"]); enquiry.City = Convert.ToString(dt.Rows[0]["City"]); enquiry.State = Convert.ToString(dt.Rows[0]["State"]); enquiry.Enq_Category = Convert.ToString(dt.Rows[0]["EnquiryCategory"]); enquiry.Enq_Subject = Convert.ToString(dt.Rows[0]["EnquirySubject"]); enquiry.EnquiryDetail1 = Convert.ToString(dt.Rows[0]["EnquiryDetail"]); } else { ModelState.AddModelError("", "An unknown error occurred. Please verify your entry and try again. If the problem persists, please contact your system administrator."); } } return(PartialView("_showEnquiryDetail", enquiry)); }
/// <summary> /// Shows how to get a specific number of sorted records, starting from an index, based on Search Parameters. The number of records are also retrieved. /// </summary> private void SelectSkipAndTakeDynamicWhere() { int startRetrievalFromRecordIndex = 0; int numberOfRecordsToRetrieve = 10; string sortBy = "EnquiryId"; //string sortBy = "EnquiryId desc"; // search parameters, everything is nullable, only items being searched for should be filled // note: fields with String type uses a LIKE search, everything else uses an exact match // also, every field you're searching for uses the AND operator // e.g. int? productID = 1; string productName = "ch"; // will translate to: SELECT....WHERE productID = 1 AND productName LIKE '%ch%' int? enquiryId = null; int? courseId = null; string studentName = null; Int64? contactNo = null; string comments = null; // 1. select a specific number of sorted records starting from the index you specify based on Search Parameters List <Enquiry> objEnquiryCol = Enquiry.SelectSkipAndTakeDynamicWhere(enquiryId, courseId, studentName, contactNo, comments, numberOfRecordsToRetrieve, startRetrievalFromRecordIndex, sortBy); // to use objEnquiryCol please see the SelectAll() method examples // No need for Examples 1 and 2 because the Collection here is already sorted // Example 3: directly bind to a GridView - for ASP.NET Web Forms // Example 4: loop through all the Enquiry(s). The example above will only loop for 10 items. }
public Enquiry Enquire(Enquiry enquiry) { var result = _carContext.Enquiries.Add(enquiry); _carContext.SaveChanges(); Logger.Information("Saved Enquiry Successfully", JsonConvert.SerializeObject(result)); return result; }
public void InsertOrUpdate(Enquiry enquiry) { if (enquiry.EnquiryID == default(int)) { // New entity context.Enquiries.Add(enquiry); } else { // Existing entity context.Entry(enquiry).State = EntityState.Modified; } }