public ActionResult Create([Bind(Include = "RowID,Title,Description")] GalleryVM mod) { if (ModelState.IsValid) { var file = Request.Files[0]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetExtension(file.FileName); tblGallery tbl = new tblGallery { Description = mod.Description, Title = mod.Title, Status = true, Transdate = DateTime.Now.AddHours(12), UserID = bl.GetUserID(System.Web.HttpContext.Current), ImagePath = fileName }; db.tblGalleries.Add(tbl); db.SaveChanges(); var path = Path.Combine(Server.MapPath("~/Images/"), "gal" + tbl.RowID + fileName); file.SaveAs(path); return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "No Image Found"); } } return(View(mod)); }
private void btnNewProp_Click(object sender, RoutedEventArgs e) { string make = cbMarket.Text; string type = cbTypes.Text; int area = Convert.ToInt32(tbarea.Text); int rooms = Convert.ToInt32(tbrooms.Text); string district = cbDistricts.Text; string adress = tbAdress.Text; string settlement = cbSettlemets.Text; decimal price = Convert.ToDecimal(tbPrice.Text); string owner = cbOwners.Text; byte status = 0; if (statusbox.IsChecked == true) { status = 1; } if (cbMarket.Text == string.Empty || cbTypes.Text == string.Empty || tbarea.Text == string.Empty || tbrooms.Text == string.Empty || cbDistricts.Text == string.Empty || tbAdress.Text == string.Empty || cbSettlemets.Text == string.Empty || tbPrice.Text == string.Empty || cbOwners.Text == string.Empty) { MessageBox.Show("Fill all Fields"); return; } Model.Properties add = new Model.Properties { MarketId = db.Market.FirstOrDefault(o => o.Name == make).id, TypeId = db.Types.FirstOrDefault(o => o.Name == type).id, Area = area, Rooms = rooms, DistrictId = db.District.FirstOrDefault(o => o.Name == district).id, Address = adress, Settlement = db.Settlement.FirstOrDefault(o => o.Name == settlement).id, Price = price, Owner = db.Owners.FirstOrDefault(o => o.Name == owner).id, Status = status }; db.Properties.Add(add); db.SaveChanges(); FillProperties(); cbMarket.Text = ""; cbTypes.Text = ""; tbarea.Text = ""; tbrooms.Text = ""; cbDistricts.Text = ""; tbAdress.Text = ""; cbSettlemets.Text = ""; tbPrice.Text = ""; cbOwners.Text = ""; statusbox.IsChecked = false; lblPhoneNumber.Visibility = Visibility.Hidden; }
public ActionResult Create([Bind(Include = "ID_City,City_Name,CreateBy,UpdateBy,CreateDate,UpdateDate,Status")] tbl_City tbl_City) { if (ModelState.IsValid) { tbl_City.CreateDate = DateTime.Now; db.tbl_City.Add(tbl_City); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbl_City)); }
public ActionResult Create([Bind(Include = "ID_Ward,Ward_Name,ID_District,CreateBy,UpdateBy,CreateDate,UpdateDate,Status")] tbl_Ward tbl_Ward) { if (ModelState.IsValid) { tbl_Ward.CreateDate = DateTime.Now; db.tbl_Ward.Add(tbl_Ward); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ID_District = new SelectList(db.tbl_District, "ID_District", "District_Name", tbl_Ward.ID_District); return(View(tbl_Ward)); }
public ActionResult Create([Bind(Include = "ID_Account,Account_Name,Sex,Birthday,Address,Email,Phone,ID_Position,Account,Pass,CreateBy,UpdateBy,CreateDate,UpdateDate,Status,Avarta")] tbl_Account tbl_Account) { if (ModelState.IsValid) { tbl_Account.CreateDate = DateTime.Now; db.tbl_Account.Add(tbl_Account); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ID_Position = new SelectList(db.tbl_Position, "ID_Position", "Position_Name", tbl_Account.ID_Position); return(View(tbl_Account)); }
public ActionResult Create([Bind(Include = "ID_District,District_Name,ID_City,CreateBy,UpdateBy,CreateDate,UpdateDate,Status")] tbl_District tbl_District) { if (ModelState.IsValid) { tbl_District.CreateDate = DateTime.Now; db.tbl_District.Add(tbl_District); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ID_City = new SelectList(db.tbl_City, "ID_City", "City_Name", tbl_District.ID_City); return(View(tbl_District)); }
public ActionResult CreateNewProperty(Property property) { if (property.id == 0) { db.Properties.Add(property); } else { var updateProperty = db.Properties.Find(property.id); if (updateProperty == null) { return(HttpNotFound()); } updateProperty.district = property.district; updateProperty.adress = property.adress; updateProperty.explanation = property.explanation; updateProperty.floor = property.floor; updateProperty.numberofrooms = property.numberofrooms; updateProperty.price = property.price; updateProperty.stateId = property.stateId; updateProperty.city = property.city; updateProperty.m2 = property.m2; } db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult tblProperties_Update([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <PropertyVM> tblproperties) { //ModelState["TransDate"].Errors.Clear(); //&& ModelState.IsValid var entities = new List <tblProperty>(); if (tblproperties != null) { foreach (var c in tblproperties) { var entity = db.tblProperties.Find(c.PropertyID); entity.PropertyTitle = c.PropertyTitle; entity.Purpose = c.Purpose; entity.TypeID = c.TypeID; entity.CityID = c.CityID; entity.SocietyID = c.SocietyID; entity.Description = c.Description; entity.Price = c.Price; entity.LandArea = c.LandArea; entity.UOMID = c.UOMID; entity.Status = c.Status; entity.IsFeatured = c.IsFeatured; entity.Block = c.Block; entity.ContactNo = c.ContactNo; entity.Estate = c.Estate; entity.IsDealer = c.IsDealer; entity.Owner = c.Owner; entity.PlotNo = c.PlotNo; entities.Add(entity); db.tblProperties.Attach(entity); db.Entry(entity).State = EntityState.Modified; } db.SaveChanges(); } return(Json(entities.ToDataSourceResult(request, ModelState, tblProperty => new PropertyVM { PropertyTitle = tblProperty.PropertyTitle, Purpose = tblProperty.Purpose, Description = tblProperty.Description, Price = tblProperty.Price, LandArea = tblProperty.LandArea, TransDate = tblProperty.TransDate, Status = tblProperty.Status, IsFeatured = tblProperty.IsFeatured, CityID = tblProperty.CityID, PropertyID = tblProperty.PropertyID, SocietyID = tblProperty.SocietyID, TypeID = tblProperty.TypeID, UOMID = tblProperty.UOMID, UserID = tblProperty.UserID, Block = tblProperty.Block, ContactNo = tblProperty.ContactNo, Estate = tblProperty.Estate, IsDealer = tblProperty.IsDealer, Owner = tblProperty.Owner, PlotNo = tblProperty.PlotNo, User = tblProperty.tblUser.FullName }))); }
public static bool PostData(MunicipalityTax municipality) { RealEstateEntities _context = new RealEstateEntities(); var checkTaxtype = _context.TaxTypes.Where(i => i.Id == municipality.TaxType).FirstOrDefault(); if (checkTaxtype == null) { return(false); } var municipal = _context.Municipalities.Where(i => i.MunicipalityName == municipality.MunicipalityName).FirstOrDefault(); if (municipal == null) { var t = new Data.Municipality(); t.MunicipalityName = municipality.MunicipalityName; _context.Municipalities.Add(t); _context.SaveChanges(); } var m = _context.MunicipalityTaxes.Where(i => i.Municipality.MunicipalityName == municipality.MunicipalityName && i.TaxDate == municipality.TaxDate).FirstOrDefault(); var currentValue = _context.Municipalities.Where(i => i.MunicipalityName == municipality.MunicipalityName).FirstOrDefault(); if (m == null) { var t = new Data.MunicipalityTax() { MunicipalityId = currentValue.Id, TaxDate = municipality.TaxDate, Tax = municipality.Tax, TaxType = municipality.TaxType }; _context.MunicipalityTaxes.Add(t); _context.SaveChanges(); } else { m.TaxType = municipality.TaxType; m.Tax = municipality.Tax; _context.SaveChanges(); } return(true); }
private void btnAddOwner_Click(object sender, RoutedEventArgs e) { lblOwner.Content = ""; string name = tbOwnersNameAddUpdate.Text; string phone = tbOwnersPhoneAddUpdate.Text; string email = tbOwnersEmailAddUpdate.Text; if (name == string.Empty || phone == string.Empty || email == string.Empty) { lblOwner.Content = "Error: Fill all boxes"; return; } if (name == "Name" || phone == "Phone" || email == "E-mail") { lblOwner.Content = "Error: Fill right Data"; return; } foreach (Owners item in db.Owners) { if (item.Phone == phone) { lblOwner.Content = "Owner already exists."; return; } } Owners count = new Owners { Name = name, Phone = phone, Email = email }; db.Owners.Add(count); db.SaveChanges(); FillOwners(); tbOwnersNameAddUpdate.Text = ""; tbOwnersPhoneAddUpdate.Text = ""; tbOwnersEmailAddUpdate.Text = ""; }
public bool UpdateAccount(RealEstateAccountDto model) { try { var item = _realEstateEntities.Accounts.Find(model.AccountId); item.Email = model.Email; item.FirstName = model.FirstName; item.LastName = model.LastName; item.UserName = model.UserName; item.DepartmentId = model.Department.DepartmentId; _realEstateEntities.SaveChanges(); return(true); } catch (System.Exception) { return(false); } }
public ActionResult Contact(mail mail) { db.mails.Add(mail); db.SaveChanges(); return(RedirectToAction("/")); }
static void RetrieveMailWithXOAUTH2Microsoft(string userEmail, string accessToken, string SenderContainsEmail, int AccountId) { try { // Hotmail/Outlook/LIVE Imap4 Server MailServer oServer = new MailServer("imap-mail.outlook.com", userEmail, accessToken, // use access token as password ServerProtocol.Imap4); // Set IMAP OAUTH 2.0 oServer.AuthType = ServerAuthType.AuthXOAUTH2; // Enable SSL/TLS connection, most modern email server require SSL/TLS by default oServer.SSLConnection = true; // Set IMAP4 SSL Port oServer.Port = 993; MailClient oClient = new MailClient("TryIt"); // Get new email only, if you want to get all emails, please remove this line oClient.GetMailInfosParam.GetMailInfosOptions = GetMailInfosOptionType.NewOnly; oClient.GetMailInfosParam.SenderContains = SenderContainsEmail; Console.WriteLine("Connecting {0} ...", oServer.Server); oClient.Connect(oServer); MailInfo[] infos = oClient.GetMailInfos(); Console.WriteLine("Total {0} email(s)\r\n", infos.Length); using (var db = new RealEstateEntities()) { var oLeadEmailMessage = db.tblLeadEmailMessages.Where(x => x.AccountId == AccountId && x.EmailMessageId == 0).ToList(); foreach (var item in oLeadEmailMessage) { for (int i = 0; i < infos.Length; i++) { MailInfo info = infos[i]; Console.WriteLine("Index: {0}; Size: {1}; UIDL: {2}", info.Index, info.Size, info.UIDL); // Receive email from email server Mail oMail = oClient.GetMail(info); Console.WriteLine("From: {0}", oMail.From.ToString()); Console.WriteLine("Subject: {0}\r\n", oMail.Subject); if (item.Subject.Equals(oMail.Subject.Replace("Re:", "").Replace("(Trial Version)", "").Trim())) { tblLeadEmailMessage obj = new tblLeadEmailMessage(); obj.AccountId = AccountId; obj.LeadId = item.LeadId; obj.Subject = item.Subject; obj.Body = oMail.HtmlBody; obj.IsReplay = true; obj.EmailMessageId = item.LeadEmailMessageId; obj.CreatedDate = oMail.ReceivedDate; db.tblLeadEmailMessages.Add(obj); db.SaveChanges(); } // Mark email as read to prevent retrieving this email again. oClient.MarkAsRead(info, true); // If you want to delete current email, please use Delete method instead of MarkAsRead // oClient.Delete(info); } } } // Quit and expunge emails marked as deleted from server. oClient.Quit(); Console.WriteLine("Completed!"); } catch (Exception ep) { Console.WriteLine(ep.Message); } }
static async Task Main(string[] args) { try { // List<Gmail> MailLists = GetAllEmails(Convert.ToString(ConfigurationManager.AppSettings["HostAddress"])); //Console.WriteLine("+------------------------------------------------------------------+"); //Console.WriteLine(" Sign in with Google "); //Console.WriteLine(" If you got \"This app isn't verified\" information in Web Browser, "); //Console.WriteLine(" click \"Advanced\" -> Go to ... to continue test."); //Console.WriteLine("+------------------------------------------------------------------+"); //Console.WriteLine(""); //Console.WriteLine("Press any key to sign in..."); //Console.ReadKey(); utility.log("Gmail Service Started:-" + DateTime.Now); try { using (var db = new RealEstateEntities()) { Program p = new Program(); //string response1 = await p.DoOauthAndRetrieveRefreshtokenMicrosoft("M.R3_BAY.-CYU*OTLb*bB5E02FuQWE8eH!x2c9YnijegHItUdUwGKAkq!glywkGeatDSJDZD3bEGuLUomu1IVJG8sLZQKqgQ3hZeaz2yiWltW!cXxQnhcXSd8QxuMNK!pEAZPBN!xhBc7gHfLEQCgv!DqQHxYC1ySkkdOcOgFMZUdsbgP5p6QcZ3l99qdGrqrjvRm644tv8zxnYIIQ0Qzukua3ydx5ctqUaHUpoIO8tBMqCqMatVUZOShjyG1lUR87b96v3ketEZ2vN1!acZGc6*YncgdjvB4f3NYUP98K3CKvZ5pXybpZykRESyyFR!XUQ6Gn73vxUC1rh21cZzNc45krFvQqHUg$"); //p.DoOauthAndRetrieveEmail(); int AgentRoleId = RoleType.Agent.GetHashCode(); var oAgentList = db.tblAccounts.Where(x => x.RoleId.Value == AgentRoleId && x.IsEmailConfig == true).ToList(); if (oAgentList.Count > 0) { foreach (var item in oAgentList) { //tblAccountIntegration oData = db.tblAccountIntegrations.Where(x => x.AccountId == item.AccountId).FirstOrDefault(); //var oData = item.tblAccountIntegrations.Where(x => x.AccountId == item.AccountId).FirstOrDefault(); if (item.tblAccountIntegrations.Count >= 1) { foreach (var itemAccountIntegrations in item.tblAccountIntegrations) { if (itemAccountIntegrations.AuthAccountType == AuthAccountType.GoogleAuth.GetHashCode()) { DateTime myDate1 = itemAccountIntegrations.CreatedDate.Value; DateTime myDate2 = DateTime.Now; TimeSpan difference = myDate2.Subtract(myDate1); //if (DateTime.Now.Subtract(oData.CreatedDate.Value).Hours >= 1) if (difference.TotalHours >= 1) { string response = await p.DoOauthAndRetrieveRefreshtoken(itemAccountIntegrations.RefreshToken); //OAuthResponseParser parser = new OAuthResponseParser(); //parser.Load(response); Rootobject result = JsonConvert.DeserializeObject <Rootobject>(response); if (result.access_token != "" && result.access_token != null) { utility.log("Refreshtoken Sucessfully Generated for Gmail"); itemAccountIntegrations.AccessToken = result.access_token; itemAccountIntegrations.CreatedDate = DateTime.Now; db.SaveChanges(); //var UserEmail = db.tblLeads.Where(x => x.AgentId == item.AccountId).FirstOrDefault(); //if (UserEmail != null) //{ // RetrieveMailWithXOAUTH(oData.EmailAddress, result.access_token, UserEmail.EmailAddress, (int)oData.AccountId); //} //var UserList = db.tblLeads.Where(x => x.AgentId == item.AccountId).ToList(); if (item.tblLeads1.Count >= 1) { foreach (var itemUserList in item.tblLeads1) { var oLeadEmailMessage = item.tblLeadEmailMessages.Where(x => x.LeadId == itemUserList.LeadId && x.AccountId == itemUserList.AgentId && x.IsType == MessageType.EmailMessage.GetHashCode()).FirstOrDefault(); if (oLeadEmailMessage != null) { //RetrieveMailWithXOAUTH(itemAccountIntegrations.EmailAddress, itemAccountIntegrations.AccessToken /*result.access_token*/, itemUserList.EmailAddress, (int)itemAccountIntegrations.AccountId, oLeadEmailMessage.LeadEmailMessageId); } } } } } else { //string response = await p.DoOauthAndRetrieveRefreshtoken(oData.RefreshToken); //Rootobject result = JsonConvert.DeserializeObject<Rootobject>(response); if (itemAccountIntegrations.AccessToken != "" && itemAccountIntegrations.AccessToken != null) { //RetrieveMailWithXOAUTH2(oData.EmailAddress, result.access_token); //var UserEmail = db.tblLeads.Where(x => x.AgentId == item.AccountId).FirstOrDefault(); //if (UserEmail != null) //{ // RetrieveMailWithXOAUTH(oData.EmailAddress, oData.AccessToken /*result.access_token*/, UserEmail.EmailAddress, (int)oData.AccountId); //} //var UserList = db.tblLeads.Where(x => x.AgentId == item.AccountId).ToList(); if (item.tblLeads1.Count >= 1) { foreach (var itemUserList in item.tblLeads1) { var oLeadEmailMessage = item.tblLeadEmailMessages.Where(x => x.LeadId == itemUserList.LeadId && x.AccountId == itemUserList.AgentId && x.IsReplay == false && x.EmailMessageId == 0 && x.IsType == MessageType.EmailMessage.GetHashCode()).ToList(); //if (oLeadEmailMessage != null) foreach (var itemLeadEmailMessage in oLeadEmailMessage) { RetrieveMailWithXOAUTH(itemAccountIntegrations.EmailAddress, itemAccountIntegrations.AccessToken /*result.access_token*/, itemUserList.EmailAddress, (int)itemAccountIntegrations.AccountId, /*itemLeadEmailMessage.LeadEmailMessageId*/ itemLeadEmailMessage); } } } } } } if (itemAccountIntegrations.AuthAccountType == AuthAccountType.MicrosoftAuth.GetHashCode()) { DateTime myDate1 = itemAccountIntegrations.CreatedDate.Value; DateTime myDate2 = DateTime.Now; TimeSpan difference = myDate2.Subtract(myDate1); //if (DateTime.Now.Subtract(oData.CreatedDate.Value).Hours >= 1) if (difference.TotalHours >= 1) { string response = await p.DoOauthAndRetrieveRefreshtokenMicrosoft(itemAccountIntegrations.RefreshToken); RootobjectMicrosoft result = JsonConvert.DeserializeObject <RootobjectMicrosoft>(response); if (result.access_token != "" && result.access_token != null) { itemAccountIntegrations.AccessToken = result.access_token; itemAccountIntegrations.CreatedDate = DateTime.Now; db.SaveChanges(); var UserEmail = db.tblLeads.Where(x => x.AgentId == item.AccountId).FirstOrDefault(); if (UserEmail != null) { RetrieveMailWithXOAUTH2Microsoft(itemAccountIntegrations.EmailAddress, result.access_token, UserEmail.EmailAddress, (int)itemAccountIntegrations.AccountId); } } } else { //string response = await p.DoOauthAndRetrieveRefreshtoken(oData.RefreshToken); //Rootobject result = JsonConvert.DeserializeObject<Rootobject>(response); if (itemAccountIntegrations.AccessToken != "" && itemAccountIntegrations.AccessToken != null) { //RetrieveMailWithXOAUTH2(oData.EmailAddress, result.access_token); var UserEmail = db.tblLeads.Where(x => x.AgentId == item.AccountId).FirstOrDefault(); if (UserEmail != null) { RetrieveMailWithXOAUTH2Microsoft(itemAccountIntegrations.EmailAddress, itemAccountIntegrations.AccessToken /*result.access_token*/, UserEmail.EmailAddress, (int)itemAccountIntegrations.AccountId); } } } } } } else { utility.log("Gmail Or Office 365 account is not linked for this agent."); } } } else { utility.log("No Agent have configure mail service."); } } } catch (Exception ex) { utility.log(ex.ToString()); //Console.WriteLine(ep.ToString()); } //Console.ReadKey(); } catch (Exception ex) { utility.log(ex.ToString()); //Console.WriteLine("Error: " + ex); } }
static void RetrieveMailWithXOAUTH(string userEmail, string accessToken, string SenderContainsEmail, int AccountId, /*int LeadEmailMessageId*/ tblLeadEmailMessage itemLeadEmailMessage) { try { //// Create a folder named "inbox" under current directory //// to save the email retrieved. //string localInbox = string.Format("{0}\\inbox", Directory.GetCurrentDirectory()); //// If the folder is not existed, create it. //if (!Directory.Exists(localInbox)) //{ // Directory.CreateDirectory(localInbox); //} MailServer oServer = new MailServer("imap.gmail.com", userEmail, accessToken, // use access token as password ServerProtocol.Imap4); // Set IMAP OAUTH 2.0 oServer.AuthType = ServerAuthType.AuthXOAUTH2; // Enable SSL/TLS connection, most modern email server require SSL/TLS by default oServer.SSLConnection = true; // Set IMAP4 SSL Port oServer.Port = 993; MailClient oClient = new MailClient("TryIt"); // Get new email only, if you want to get all emails, please remove this line oClient.GetMailInfosParam.GetMailInfosOptions = GetMailInfosOptionType.NewOnly; oClient.GetMailInfosParam.SenderContains = SenderContainsEmail; Console.WriteLine("Connecting {0} ...", oServer.Server); utility.log("Connecting Gmail {0} ..." + oServer.Server); oClient.Connect(oServer); MailInfo[] infos = oClient.GetMailInfos(); //MailInfo[] infos = oClient.SearchMail("ALL FROM \"Constro\""); Console.WriteLine("Total {0} email(s)\r\n", infos.Length); utility.log("Total number of new email found from Gmail:-" + infos.Length); using (var db = new RealEstateEntities()) { //var oLeadEmailMessage = db.tblLeadEmailMessages.Where(x => x.AccountId == AccountId && x.EmailMessageId == 0).ToList(); //foreach (var item in itemLeadEmailMessage) //{ for (int i = 0; i < infos.Length; i++) { MailInfo info = infos[i]; Console.WriteLine("Index: {0}; Size: {1}; UIDL: {2}; Flags: {3}", info.Index, info.Size, info.UIDL, info.Flags); // Receive email from email server Mail oMail = oClient.GetMail(info); Console.WriteLine("From: {0}", oMail.From.ToString()); Console.WriteLine("To: {0}", oMail.To.ToString()); Console.WriteLine("Subject: {0}\r\n", oMail.Subject); utility.log("From:-" + oMail.From.ToString()); utility.log("To:-" + oMail.To[0].ToString()); utility.log("Subject:-" + oMail.Subject); utility.log("Subject1:-" + oMail.Subject.Replace("Re:", "").Replace("(Trial Version)", "").Trim()); //Console.WriteLine("Body: {0}\r\n", oMail.HtmlBody); //Console.WriteLine("Text Body: {0}\r\n", oMail.TextBody); string oRepSubj = oMail.Subject.Replace("Re:", "").Replace("(Trial Version)", "").Trim(); if (itemLeadEmailMessage.Subject.Equals(oRepSubj)) // && LeadEmailMessageId == item.LeadEmailMessageId { utility.log(itemLeadEmailMessage.Subject + "----" + oMail.Subject + "---Matched"); foreach (var itemAttachment in oMail.Attachments) { if (itemAttachment.ContentID != "") { string matchString = Regex.Match(oMail.HtmlBody, "<img.+?src=[\"'](.+?)[\"'].+?>", RegexOptions.IgnoreCase).Groups[0].Value; if (matchString != "") { if (matchString.Contains(itemAttachment.ContentID)) { if (!Directory.Exists(MailReadImgPath)) { Directory.CreateDirectory(MailReadImgPath); } string fileName = Guid.NewGuid().ToString("N").Substring(0, 8) + Path.GetExtension(itemAttachment.Name); File.WriteAllBytes(MailReadImgPath + "\\" + fileName, itemAttachment.Content); // Requires System.IO oMail.HtmlBody = Regex.Replace(oMail.HtmlBody, matchString, @"<img src='../../mail-read-img/" + fileName + @"'/>"); } } } } tblLeadEmailMessage obj = new tblLeadEmailMessage(); obj.AccountId = AccountId; obj.LeadId = itemLeadEmailMessage.LeadId; foreach (var itemTo in oMail.To) { obj.ToName = itemTo.Name == "" ? itemTo.Address.Split('@')[0] : itemTo.Name; } obj.FromName = oMail.From.Name; obj.Subject = itemLeadEmailMessage.Subject; obj.Body = oMail.HtmlBody; obj.IsReplay = true; obj.IsRead = false; obj.EmailMessageId = itemLeadEmailMessage.LeadEmailMessageId; obj.CreatedDate = oMail.ReceivedDate; db.tblLeadEmailMessages.Add(obj); db.SaveChanges(); var oLeadEmailMessage = db.tblLeadEmailMessages.Where(x => x.AccountId == AccountId && x.LeadEmailMessageId == itemLeadEmailMessage.LeadEmailMessageId && x.IsType == MessageType.EmailMessage.GetHashCode()).FirstOrDefault(); if (oLeadEmailMessage != null) { oLeadEmailMessage.IsRead = false; db.SaveChanges(); } foreach (var itemAttachment in oMail.Attachments) { if (itemAttachment.ContentID == "") { string fileName = Guid.NewGuid().ToString("N").Substring(0, 8) + Path.GetExtension(itemAttachment.Name); //FileStream filestream = new FileStream(ImagePath + "\\" + item.AccountId + "\\" + item.LeadId + "\\" + fileName, FileMode.Create); //var streamwriter = new StreamWriter(filestream); //streamwriter.AutoFlush = true; //Console.SetOut(streamwriter); //Console.SetError(streamwriter); File.WriteAllBytes(ImagePath + "\\" + itemLeadEmailMessage.AccountId + "\\" + itemLeadEmailMessage.LeadId + "\\" + fileName, itemAttachment.Content); // Requires System.IO tblLeadEmailMessageAttachment oData = new tblLeadEmailMessageAttachment(); //oData.LeadEmailMessageId = item.LeadEmailMessageId; oData.LeadEmailMessageId = obj.LeadEmailMessageId; oData.Attachement = string.IsNullOrEmpty(fileName) ? string.Empty : fileName; oData.CreatedDate = DateTime.Now; db.tblLeadEmailMessageAttachments.Add(oData); db.SaveChanges(); } } // Mark email as read to prevent retrieving this email again. oClient.MarkAsRead(info, true); } // If you want to delete current email, please use Delete method instead of MarkAsRead // oClient.Delete(info); } //} } // Quit and expunge emails marked as deleted from server. oClient.Quit(); utility.log("Gmail Service completed:-" + DateTime.Now); utility.log("==================="); //Console.WriteLine("Completed!"); } catch (Exception ep) { Console.WriteLine(ep.Message); } }
public ActionResult Create(PropertyVM mod) { if (ModelState.IsValid) { try { if (mod.SocietyID <= 0) { tblSociety soc = new tblSociety { CityID = mod.CityID, Society = mod.OtherSociety, Status = true }; db.tblSocieties.Add(soc); db.SaveChanges(); mod.SocietyID = soc.SocietyID; } tblProperty tbl = new tblProperty { CityID = mod.CityID, Description = mod.Description, IsFeatured = mod.IsFeatured, LandArea = mod.LandArea, Price = mod.Price, PropertyTitle = mod.PropertyTitle, Purpose = mod.Purpose, SocietyID = mod.SocietyID, Status = "H", TransDate = DateTime.Now.AddHours(12), TypeID = mod.TypeID, UOMID = mod.UOMID, UserID = bl.GetUserID(System.Web.HttpContext.Current), Block = mod.Block, ContactNo = mod.ContactNo, Estate = mod.Estate, IsDealer = mod.IsDealer, Owner = mod.Owner, PlotNo = mod.PlotNo }; db.tblProperties.Add(tbl); db.SaveChanges(); var coun = Request.Files.Count; for (int i = 0; i < coun; i++) { var file = Request.Files[i]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetExtension(file.FileName); tblImage img = new tblImage { PropertyID = tbl.PropertyID, ImagePath = fileName, Status = true }; db.tblImages.Add(img); db.SaveChanges(); var path = Path.Combine(Server.MapPath("~/Images/"), img.ImageID + fileName); file.SaveAs(path); } } return(RedirectToAction("Create")); } catch (Exception) { } } return(View(mod)); }