public JsonpResult GetTable(string clientid, string tableid)
{
ClientServer c = new ClientServer(clientid);
Tz.Net.DataManager dataManager = new Net.DataManager(tableid, c.GetServer().ServerID, clientid);
return(new JsonpResult(dataManager.GetTable()));
}
public JsonpResult GetData(int pageSize, int currentPage, string clientid, string tbid)
{
System.Data.DataTable dt = new System.Data.DataTable();
ClientServer c = new ClientServer(clientid);
Tz.Net.DataManager dataManager = new Net.DataManager(tbid, c.GetServer().ServerID, clientid);
dt = dataManager.GetData(currentPage, pageSize);
int trecord = dataManager.GetDataCount();
string dtr = DataResult.Create(dt, pageSize, currentPage, trecord);
return(new JsonpResult(dtr));
}
/// <summary>
/// remove field from the table
/// </summary>
/// <param name="clientid"></param>
/// <param name="tbID"></param>
/// <param name="fieldID"></param>
/// <returns></returns>
public JsonpResult RemoveField(string clientid, string tbID, string fieldID)
{
try
{
ClientServer c = new ClientServer(clientid);
Tz.Net.DataManager dataManager = new Net.DataManager(tbID, c.GetServer().ServerID, clientid);
dataManager.RemoveField(fieldID);
return(new JsonpResult("true"));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// change name of the table
/// </summary>
/// <param name="clientid"></param>
/// <param name="tb"></param>
/// <returns></returns>
public JsonpResult UpdateTable(string clientid, string tb)
{
try
{
ClientServer c = new ClientServer(clientid);
Tz.BackApp.Models.Table ModalTable;
ModalTable = Newtonsoft.Json.JsonConvert.DeserializeObject <Models.Table>(tb);
Tz.Net.DataManager dataManager = new Net.DataManager(ModalTable.TableID, c.GetServer().ServerID, clientid);
dataManager.Rename(ModalTable.TableName, ModalTable.Category);
return(new JsonpResult(dataManager.getTableID()));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// update existing field
/// </summary>
/// <param name="clientid"></param>
/// <param name="tbID"></param>
/// <param name="fields"></param>
/// <returns></returns>
public JsonpResult UpdateField(string clientid, string tbID, string fields)
{
try
{
ClientServer c = new ClientServer(clientid);
Tz.Net.DataManager dataManager = new Net.DataManager(tbID, c.GetServer().ServerID, clientid);
Models.Field mField = Newtonsoft.Json.JsonConvert.DeserializeObject <Models.Field>(fields);
//if (mField.IsPrimaryKey)
//{
// // dataManager.AddPrimarykey(mField.FieldName, mField.FieldType, mField.Length);
//}
//else
//{
dataManager.ChangeField(mField.FieldID, mField.FieldName, mField.FieldType, mField.Length, mField.IsNullable, mField.IsPrimaryKey, mField.NewFieldName);
dataManager.AcceptChanges();
// }
return(new JsonpResult(dataManager.getTableID()));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// new table creation with fields
/// </summary>
/// <param name="clientid"></param>
/// <param name="tb"></param>
/// <param name="fields"></param>
/// <returns></returns>
public JsonpResult SaveTableField(string clientid, string tb, string fields)
{
try
{
ClientServer c = new ClientServer(clientid);
Tz.BackApp.Models.Table ModalTable;
ModalTable = Newtonsoft.Json.JsonConvert.DeserializeObject <Models.Table>(tb);
List <Models.Field> mFields = Newtonsoft.Json.JsonConvert.DeserializeObject <List <Models.Field> >(fields);
if (ModalTable.TableID == "")
{
Tz.Net.DataManager dataManager = new Net.DataManager(c.GetServer().ServerID, clientid);
dataManager.NewTable(ModalTable.TableName, ModalTable.Category);
foreach (Models.Field f in mFields)
{
if (f.IsPrimaryKey)
{
dataManager.AddPrimarykey(f.FieldName, f.FieldType, f.Length);
}
else
{
dataManager.AddField(f.FieldName, f.FieldType, f.Length, f.IsNullable);
}
}
dataManager.AcceptChanges();
return(new JsonpResult(dataManager.getTableID()));
}
else
{
Tz.Net.DataManager dataManager = new Net.DataManager(ModalTable.TableID, c.GetServer().ServerID, clientid);
if (ModalTable.TableName != "")
{
if (dataManager.GetTable().TableName != ModalTable.TableName)
{
dataManager.Rename(ModalTable.TableName, ModalTable.Category); // rename table
}
}
foreach (Models.Field f in mFields)
{
if (f.IsChanged || f.FieldID != "")
{
dataManager.ChangeField(f.FieldID, f.FieldName, f.FieldType, f.Length, f.IsNullable, f.IsPrimaryKey); // alter table field info & new field name
}
else
{
if (f.IsPrimaryKey)
{
dataManager.AddPrimarykey(f.FieldName, f.FieldType, f.Length);
}
else
{
dataManager.AddField(f.FieldName, f.FieldType, f.Length, f.IsNullable);
}
}
}
dataManager.AcceptChanges();
return(new JsonpResult(dataManager.getTableID()));
//dataManager
}
}
catch (System.Exception ex)
{
throw ex;
}
}
