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