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