public static string Template(string Tipe, string Identity, string Satuan, decimal Waktu, string Database, string IP, string User, string Pass, string Project)
{
int ada = Db.SingleInteger("SELECT COUNT(*) FROM SmsFormat WHERE Project = '" + Project + "' AND Tipe = '" + Tipe + "'");
if (ada == 0)
{
return("");
}
// Ambil bahan2 yang diperlukan
DataTable source = Db.RsAll(query(Tipe, Identity, Satuan, Waktu, Project), Database, IP, User, Pass);
DataTable Param = parameter(Tipe);
string SMS = Regex.Replace(SMSEditor(Tipe, Project), @"\n", ""); // Replace whitespace. kalau ngga di giniin, ga bisa buat looping table
// Perulangan
SMS = Perulangan(SMS, source, Param);
// Seleksi kondisi
SMS = Kondisi(SMS);
string output = HitungRumus(SMS).Replace("<!--", "").Replace("-->", "").Replace("$StartLooping", "").Replace("$EndLooping", "")
.Replace("$StartIF", "").Replace("$EndIF", "");
return(output);
}
