public void UpdateUdt(ActionParams actionparams)
{
System.Diagnostics.Debug.WriteLine("UpdateUDT Start:" + DateTime.Now.ToString("hh:mm:ss ffff"));
if (actionparams.NeedRefresh)
{
RefreshUdt(CnctArgs.Udtname);
}
System.Diagnostics.Debug.WriteLine("UpdateUDT Start 1:" + DateTime.Now.ToString("hh:mm:ss ffff"));
DataTable dtTable = CurrentDataSet.Tables[actionparams.TableIndex];
DataRow[] dr = dtTable.Select(actionparams.PrimaryColumn + "='" + actionparams.PrimaryValue + "'");
for (int i = 0; i < actionparams.Columns.Count(); i++)
{
dr[0][actionparams.Columns[i]] = actionparams.Values[i];
}
UdtArgs args = new UdtArgs();
UpdateRowRespArgs respargs = new UpdateRowRespArgs();
respargs.TableName = dr[0].Table.TableName;
respargs.Data = Array.ConvertAll(dr[0].ItemArray, x => x.ToString());
args.Action = "updaterow";
UdtParams udtparams = new UdtParams();
udtparams.UpdateRowParams = respargs;
args.ActionParams = new UdtParams[1] {
udtparams
};
args.Udtid = _mudtinfo.UdtId;
args.UserName = Environment.UserName;
System.Diagnostics.Debug.WriteLine("UpdateUDT End 0:" + DateTime.Now.ToString("hh:mm:ss ffff"));
_mObjUdtDataHandler.UpdateRow(args);
System.Diagnostics.Debug.WriteLine("UpdateUDT End:" + DateTime.Now.ToString("hh:mm:ss ffff"));
}
public void InsertUdt(ActionParams actionparams)
{
System.Diagnostics.Debug.WriteLine("InsertUDTData Start:" + DateTime.Now.ToString("hh:mm:ss ffff"));
if (actionparams.NeedRefresh)
{
RefreshUdt(CnctArgs.Udtname);
}
System.Diagnostics.Debug.WriteLine("InsertUDTData Start 1:" + DateTime.Now.ToString("hh:mm:ss ffff"));
DataTable dtTable = CurrentDataSet.Tables[actionparams.TableIndex];
DataRow dr = dtTable.NewRow();
for (int i = 0; i < actionparams.Columns.Count(); i++)
{
dr[actionparams.Columns[i]] = actionparams.Values[i];
}
if (dr.Table.Columns.Count > 1 && dr.Table.Columns[1].ColumnName.Contains("_ID") && dtTable.Rows.Count > 0)
{
var parentkey = dtTable.Rows[0][1];
string parentTable = string.Empty;
if (string.IsNullOrEmpty(Convert.ToString(parentkey)))
{
for (int i = 0; i < CurrentDataSet.Relations.Count; i++)
{
if (CurrentDataSet.Relations[i].ChildTable.TableName == dr.Table.TableName)
{
parentTable = CurrentDataSet.Relations[i].ParentTable.TableName;
break;
}
}
if (!string.IsNullOrEmpty(parentTable))
{
DataTable dtParent = CurrentDataSet.Tables[parentTable];
string columnName = "T" + parentTable + "_ID";
if (dtParent != null && dtParent.Rows.Count > 0 && dtParent.Columns.Contains(columnName))
{
parentkey = dtParent.Rows[0][columnName];
}
}
}
dr[1] = parentkey;
}
if (dr.Table.Columns.Contains("Visibility") && string.IsNullOrEmpty(Convert.ToString(dr["Visibility"])))
{
dr["Visibility"] = true;
}
if (!actionparams.Columns.Contains("ID") && dtTable.Columns.Contains("ID"))
{
DataRow drlast = dtTable.Rows[dtTable.Rows.Count - 1];
int id = 0;
if (drlast != null && drlast["ID"] != null)
{
int.TryParse(Convert.ToString(drlast["ID"]), out id);
}
id++;
dr["ID"] = id;
}
UdtArgs args = new UdtArgs();
AddRowRespArgs respargs = new AddRowRespArgs();
respargs.TableName = dr.Table.TableName;
respargs.Data = Array.ConvertAll(dr.ItemArray, x => x.ToString());
args.Action = "addrow";
UdtParams udtparams = new UdtParams();
udtparams.AddRowParams = respargs;
args.ActionParams = new UdtParams[1] {
udtparams
};
args.Udtid = _mudtinfo.UdtId;
args.UserName = Environment.UserName;
System.Diagnostics.Debug.WriteLine("InsertUDTData End 0:" + DateTime.Now.ToString("hh:mm:ss ffff"));
_mObjUdtDataHandler.AddRow(args);
//Testing merging at same time
//sreenath added
System.Diagnostics.Debug.WriteLine("InsertUDTData End:" + DateTime.Now.ToString("hh:mm:ss ffff"));
}
public void UpdateUdt(ActionParams actionparams)
{
System.Diagnostics.Debug.WriteLine("UpdateUDT Start:" + DateTime.Now.ToString("hh:mm:ss ffff"));
if (actionparams.NeedRefresh)
{
RefreshUdt(CnctArgs.Udtname);
}
System.Diagnostics.Debug.WriteLine("UpdateUDT Start 1:" + DateTime.Now.ToString("hh:mm:ss ffff"));
DataTable dtTable = CurrentDataSet.Tables[actionparams.TableIndex];
DataRow[] dr = dtTable.Select(actionparams.PrimaryColumn + "='" + actionparams.PrimaryValue + "'");
for (int i = 0; i < actionparams.Columns.Count(); i++)
{
dr[0][actionparams.Columns[i]] = actionparams.Values[i];
}
UdtArgs args = new UdtArgs();
UpdateRowRespArgs respargs = new UpdateRowRespArgs();
respargs.TableName = dr[0].Table.TableName;
respargs.Data = Array.ConvertAll(dr[0].ItemArray, x => x.ToString());
args.Action = "updaterow";
UdtParams udtparams = new UdtParams();
udtparams.UpdateRowParams = respargs;
args.ActionParams = new UdtParams[1] { udtparams };
args.Udtid = _mudtinfo.UdtId;
args.UserName = Environment.UserName;
System.Diagnostics.Debug.WriteLine("UpdateUDT End 0:" + DateTime.Now.ToString("hh:mm:ss ffff"));
_mObjUdtDataHandler.UpdateRow(args);
System.Diagnostics.Debug.WriteLine("UpdateUDT End:" + DateTime.Now.ToString("hh:mm:ss ffff"));
}
public void InsertUdt(ActionParams actionparams)
{
System.Diagnostics.Debug.WriteLine("InsertUDTData Start:" + DateTime.Now.ToString("hh:mm:ss ffff"));
if (actionparams.NeedRefresh)
{
RefreshUdt(CnctArgs.Udtname);
}
System.Diagnostics.Debug.WriteLine("InsertUDTData Start 1:" + DateTime.Now.ToString("hh:mm:ss ffff"));
DataTable dtTable = CurrentDataSet.Tables[actionparams.TableIndex];
DataRow dr = dtTable.NewRow();
for (int i = 0; i < actionparams.Columns.Count(); i++)
{
dr[actionparams.Columns[i]] = actionparams.Values[i];
}
if (dr.Table.Columns.Count > 1 && dr.Table.Columns[1].ColumnName.Contains("_ID") && dtTable.Rows.Count > 0)
{
var parentkey = dtTable.Rows[0][1];
dr[1] = parentkey;
}
if (dr.Table.Columns.Contains("Visibility") && string.IsNullOrEmpty(Convert.ToString(dr["Visibility"])))
{
dr["Visibility"] = true;
}
if (!actionparams.Columns.Contains("ID") && dtTable.Columns.Contains("ID"))
{
DataRow drlast = dtTable.Rows[dtTable.Rows.Count - 1];
int id = 0;
if (drlast != null && drlast["ID"] != null)
{
int.TryParse(Convert.ToString(drlast["ID"]), out id);
}
id++;
dr["ID"] = id;
}
UdtArgs args = new UdtArgs();
AddRowRespArgs respargs = new AddRowRespArgs();
respargs.TableName = dr.Table.TableName;
respargs.Data = Array.ConvertAll(dr.ItemArray, x => x.ToString());
args.Action = "addrow";
UdtParams udtparams = new UdtParams();
udtparams.AddRowParams = respargs;
args.ActionParams = new UdtParams[1] { udtparams };
args.Udtid = _mudtinfo.UdtId;
args.UserName = Environment.UserName;
System.Diagnostics.Debug.WriteLine("InsertUDTData End 0:" + DateTime.Now.ToString("hh:mm:ss ffff"));
_mObjUdtDataHandler.AddRow(args);
//Testing merging at same time
//sreenath added
System.Diagnostics.Debug.WriteLine("InsertUDTData End:" + DateTime.Now.ToString("hh:mm:ss ffff"));
}
