public IHttpActionResult deletedata(DataParnew par)
{
try
{
dbOAMSEntities db = new dbOAMSEntities();
string tablename = par.Tablename;
tablename = CryptData.querydecrypt(tablename);
string ID = par.id.checkIsNull();
var rfun = db.Database.SqlQuery <tbFunction>("select f.* from bnle.tbFunction f where f.MAFUNC = @MAFUNC and KICHTHOAT = 1"
, new SqlParameter("@MAFUNC", tablename)).FirstOrDefault();
if (rfun != null)
{
if (ID != "")
{
StringBuilder sqlcom = new StringBuilder("");
sqlcom.Append("delete " + rfun.TABLENAME + " where " + rfun.IDKEY + " = @" + rfun.IDKEY);
var vrs = db.Database.SqlQuery <tbFORMFUNC>("select f.* from bnle.tbFORMFUNC f where f.MAFUNC = @MAFUNC and MATRUONG = @MATRUONG "
, new SqlParameter("@MAFUNC", tablename), new SqlParameter("@MATRUONG", rfun.IDKEY)).ToList();
string keytype = "";
for (int i = 0; i < vrs.Count; i++)
{
if (rfun.IDKEY == vrs[i].MATRUONG)
{
keytype = vrs[i].KIEUDULIEU; break;
}
}
SqlParameter parsql;
switch (keytype)
{
case "text": parsql = new SqlParameter("@" + rfun.IDKEY, ID); break;
case "number": parsql = new SqlParameter("@" + rfun.IDKEY, Convert.ToInt32(ID)); break;
default: parsql = new SqlParameter("@" + rfun.IDKEY, ID); break;
}
db.Database.ExecuteSqlCommand(sqlcom.ToString(), parsql);
}
}
return(Ok(1));
}
catch
{
return(BadRequest());
}
}
public IEnumerable <DataControl> getnewdatatable(DataParnew par)
{
try
{
dbOAMSEntities db = new dbOAMSEntities();
string tablename = par.Tablename;
tablename = CryptData.querydecrypt(tablename);
string ID = par.id.checkIsNull();
var rfun = db.Database.SqlQuery <tbFunction>("select f.* from bnle.tbFunction f where f.MAFUNC = @MAFUNC and KICHTHOAT = 1"
, new SqlParameter("@MAFUNC", tablename)).FirstOrDefault();
if (rfun != null)
{
int numcoll = rfun.NUMCOL.Value;
string widthlabel = "";
widthlabel = string.Format("col-md-{0} col-sm-{0} col-xs-3", rfun.WITHDLABEL.Value);
var vrs = db.Database.SqlQuery <tbFORMFUNC>("select f.* from bnle.tbFORMFUNC f where f.MAFUNC = @MAFUNC and HIENTHI = 1 order by THUTUNHAP"
, new SqlParameter("@MAFUNC", tablename)).ToList();
List <DataControl> hsc = new List <DataControl>();
bool newrow = false;
string keytype = "";
int cur = 0;
bool idkey = false;
for (int i = 0; i < vrs.Count; i++)
{
if (vrs[i].MATRUONG == rfun.IDKEY)
{
idkey = true;
}
DataControl h = new DataControl();
h.widthlabel = widthlabel;
h.id = "idvb_" + vrs[i].ID;
h.label = vrs[i].TENTRUONG;
h.namecol = vrs[i].MATRUONG;
h.ctype = vrs[i].KIEUDULIEU;
h.width = string.Format("col-md-{0} col-sm-{0} col-xs-12", vrs[i].WITHDFORM.Value);
if (vrs[i].WITHDFORM.Value > 0)
{
if (cur == 0)
{
h.viewed = "0";
cur = vrs[i].WITHDFORM.Value + rfun.WITHDLABEL.Value;
}
else if (vrs[i].WITHDFORM.Value + rfun.WITHDLABEL.Value + cur > 12)
{
h.viewed = "0";
cur = 0;
}
else
{
h.viewed = "1";
cur += vrs[i].WITHDFORM.Value + rfun.WITHDLABEL.Value;
}
}
else
{
h.width = "0";
}
h.required = vrs[i].BATBUOC == 1 ? true : false;
if (vrs[i].RANGBUOC.checkIsNull() != "")
{
string wheredir = "";
if (vrs[i].TUDIEN.checkIsNull() != "")
{
wheredir = "where " + vrs[i].TUDIEN;
}
string sqldir = string.Format("select {0} as [CODE],{1} as [VALUENAME] from {2} {3}",
vrs[i].KEYFOR, vrs[i].NAMEFOR, vrs[i].RANGBUOC, wheredir);
var dirs = db.Database.SqlQuery <DataDirControl>(sqldir).ToList();
h.dictionary = dirs;
}
else
{
if (vrs[i].TUDIEN.checkIsNull() != "")
{
var dirs = db.Database.SqlQuery <DataDirControl>("select [CODE], [VALUENAME] from [adm].[tbDanhmuc] where LOAIDM = @LOAIDM"
, new SqlParameter("@LOAIDM", vrs[i].TUDIEN)).ToList();
h.dictionary = dirs;
}
else
{
h.dictionary = new List <DataDirControl>();
}
}
h.values = vrs[i].MACDINH;
if (rfun.IDKEY == vrs[i].MATRUONG)
{
keytype = h.ctype;
}
h.disable = false;
hsc.Add(h);
}
if (!idkey)
{
DataControl h = new DataControl();
h.widthlabel = widthlabel;
h.id = "IDKEY";
h.label = rfun.IDKEY;
h.namecol = rfun.IDKEY;
h.ctype = rfun.IDKEY;
}
if (ID != "")
{
StringBuilder sqlcom = new StringBuilder("select *");
sqlcom.Append(" from " + rfun.TABLENAME + " where " + rfun.IDKEY + " = @" + rfun.IDKEY);
var dt = new DataTable();
var conn = db.Database.Connection;
var connectionState = conn.State;
try
{
if (connectionState != ConnectionState.Open)
{
conn.Open();
}
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = sqlcom.ToString();
cmd.CommandType = CommandType.Text;
switch (keytype)
{
case "text": cmd.Parameters.Add(new SqlParameter("@" + rfun.IDKEY, ID)); break;
case "number": cmd.Parameters.Add(new SqlParameter("@" + rfun.IDKEY, Convert.ToInt32(ID))); break;
default: cmd.Parameters.Add(new SqlParameter("@" + rfun.IDKEY, ID)); break;
}
using (var reader = cmd.ExecuteReader())
{
dt.Load(reader);
}
}
}
catch (Exception ex)
{
if (connectionState != ConnectionState.Closed)
{
conn.Close();
}
}
finally
{
if (connectionState != ConnectionState.Closed)
{
conn.Close();
}
}
if (dt.Rows.Count > 0)
{
DataControlCols item = new DataControlCols();
item.items = new List <DataControlRow>();
foreach (var j in hsc)
{
j.values = dt.Rows[0][j.namecol].ToString();
j.disable = false;
if (rfun.IDKEY == j.namecol)
{
j.disable = true;
}
}
}
}
return(hsc.AsEnumerable());
}
return((new List <DataControl>()).AsEnumerable());
}
catch
{
return((new List <DataControl>()).AsEnumerable());
}
}
