public async Task <ActionResult> yeniMail(string id) { try { if (id == null) { id = "-200"; } int intId = Convert.ToInt32(id); List <object> nesneler = new List <object>(); string query = "select k.id, k.ad, k.soyad, k.email, k.tel, k.kullanici_turu, k.url, fm.firma_adi from kullanicilar as k " + "inner join firma_musavir as fm on fm.id = k.firma_id " + "where k.flag = " + durumlar.aktif + " and fm.flag = " + durumlar.aktif + " order by k.firma_id, k.ad;"; string query2 = "select hedef_id from mailler as m where m.mail_grup_id = " + id; var k = db.Database.SqlQuery <KullaniciFirmaOzetModel>(query).ToListAsync(); var m = db.mailler.Where(e => e.flag == durumlar.aktif && e.mail_grup_id == intId).FirstOrDefaultAsync(); var k2 = db.Database.SqlQuery <int>(query2).ToListAsync(); await Task.WhenAll(k, m, k2); List <KullaniciFirmaOzetModel> kullaniciList = k.Result; mailler mail = m.Result; List <int> kullaniciIdList = k2.Result; nesneler.Add(kullaniciList); nesneler.Add(mail); nesneler.Add(kullaniciIdList); return(View(nesneler)); } catch (Exception) { return(RedirectToAction("Index")); } }
public static void mailKaydet(string baslik, string mesaj, string kimden, string kime, int flag, int mailHedefTur, int hedefId, string gonderenMail, int gonderenId, int mailGroupId) { LoggedUserModel lgm = GetCurrentUser.GetUser(); vrlfgysdbEntities db = new vrlfgysdbEntities(); int vid = 1; if (db.mailler.Count() != 0) { vid = db.mailler.Max(e => e.vid) + 1; } int sort = 1; if (db.mailler.Count() != 0) { sort = db.mailler.Max(e => e.sort) + 1; } mailler mail = new mailler(); mail.konu = baslik; mail.flag = flag; mail.date = DateTime.Now; mail.icerik = mesaj; mail.gonderen_mail = kimden; mail.alan_mail = kime; mail.vid = vid; mail.gonderen_id = gonderenId; mail.hedef_id = hedefId; mail.hedef_tur = mailHedefTur; mail.mail_grup_id = mailGroupId; mail.sort = sort; mail.url = ""; mail.firma_id = lgm.firma_id; db.mailler.Add(mail); db.SaveChanges(); }