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