public async Task <ActionResult> yeniSms(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 smsler as s where s.sms_grup_id = " + id; var k = db.Database.SqlQuery <KullaniciFirmaOzetModel>(query).ToListAsync(); var s = db.smsler.Where(e => e.flag == durumlar.aktif && e.sms_grup_id == intId).FirstOrDefaultAsync(); var k2 = db.Database.SqlQuery <int>(query2).ToListAsync(); await Task.WhenAll(k, s, k2); List <KullaniciFirmaOzetModel> kullaniciList = k.Result; smsler sms = s.Result; List <int> kullaniciIdList = k2.Result; nesneler.Add(kullaniciList); nesneler.Add(sms); nesneler.Add(kullaniciIdList); return(View(nesneler)); } catch (Exception ex) { return(RedirectToAction("Index")); } }
public static void smsKaydet(string mesaj, int flag, int mailHedefTur, int hedefId, string hedef_numara, int gonderenId, int smsGroupId) { LoggedUserModel lgm = GetCurrentUser.GetUser(); vrlfgysdbEntities db = new vrlfgysdbEntities(); int vid = 1; if (db.smsler.Count() != 0) { vid = db.smsler.Max(e => e.vid) + 1; } int sort = 1; if (db.smsler.Count() != 0) { sort = db.smsler.Max(e => e.sort) + 1; } smsler sms = new smsler(); sms.flag = flag; sms.date = DateTime.Now; sms.icerik = mesaj; sms.vid = vid; sms.gonderen_id = gonderenId; sms.hedef_id = hedefId; sms.hedef_numara = hedef_numara; sms.hedef_tur = mailHedefTur; sms.sms_grup_id = smsGroupId; sms.sort = sort; sms.firma_id = lgm.firma_id; string strImageName = StringFormatter.OnlyEnglishChar(Tools.OurFunctions.ourSubString(sms.icerik, 15)); string createdUrl = strImageName; string tempUrl = createdUrl; bool bulundu = false; int i = 0; smsler pg = new smsler(); do { pg = db.smsler.Where(e => e.url.Equals(tempUrl)).FirstOrDefault(); if (pg != null) { tempUrl = tempUrl + i.ToString(); } else { createdUrl = tempUrl; bulundu = true; } i++; } while (!bulundu); sms.url = createdUrl; db.smsler.Add(sms); db.SaveChanges(); }