public static string GetUserGuidFromTmpGuid(string tmpGuid)
{
Durados.DataAccess.SqlAccess sqlAccess = new DataAccess.SqlAccess();
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("@id", tmpGuid);
parameters.Add("@userGuid", Guid.NewGuid());
return(CallValidUserGuidSP(parameters, "durados_IsValidGuid", "@userGuid"));
}
public void Remove(string key, BeforeDeleteEventHandler bfDelete, AfterDeleteEventHandler afDelete, AfterDeleteEventHandler afDeleteAndCommit)
{
//string sql = "DELETE FROM {0} WHERE [{1}]='{2}'";
//string query = string.Format(sql,view.DataTable.TableName, view.PrimaryKeyFileds[0].DatabaseNames,key);
DataAccess.SqlAccess da = new DataAccess.SqlAccess();
da.Delete(view, key, bfDelete, afDelete, afDeleteAndCommit);
}
public void Rename(string key, string name, BeforeEditEventHandler bfEdit, BeforeEditInDatabaseEventHandler bfDbEdit, AfterEditEventHandler afEdit, AfterEditEventHandler afEditAndCommit)
{
//string sql = "UPDATE {0} SET [{1}] = '{2}') WHERE [{3}]='{4}'";
//string query = string.Format(sql,view.DataTable.TableName, view.DisplayColumn, name, view.PrimaryKeyFileds[0].DatabaseNames,key);
Dictionary <string, object> values = new Dictionary <string, object>();
//values.Add(view.PrimaryKeyFileds[0].Name, key);
values.Add(view.DisplayColumn, name);
DataAccess.SqlAccess da = new DataAccess.SqlAccess();
da.Edit(view, values, key, bfEdit, bfDbEdit, afEdit, afEditAndCommit);
}
private static string CallValidUserGuidSP(Dictionary <string, object> parameters, string spName, string retParamName)
{
Durados.DataAccess.SqlAccess sqlAccess = new DataAccess.SqlAccess();
List <string> outputsParams = new List <string>();
outputsParams.Add(retParamName);
System.Data.SqlClient.SqlParameter[] sqlParameters = sqlAccess.ExecuteProcedure(Maps.Instance.ConnectionString, spName, parameters, outputsParams, null);
if (sqlParameters.Length > 0)
{
foreach (System.Data.SqlClient.SqlParameter parameter in sqlParameters)
{
if (parameter.ParameterName == retParamName)
{
return(parameter.Value == null ? null : parameter.Value.ToString());
}
}
}
return(null);
}
FROM v"; //WHERE level < 3
public string AddChild(string parentKey, string name, BeforeCreateEventHandler bfCreate, BeforeCreateInDatabaseEventHandler bfDbCreate, AfterCreateEventHandler afCreate, AfterCreateEventHandler afCreateAndCommit)
{
//string sql = "INSERT INTO {0} ([{1}],[{2}]) VALUES ('{3}','{4}')";
//string query = string.Format(sql, view.DataTable.TableName, view.TreeRelatedFieldName, view.DisplayColumn,parentKey, name);
Dictionary <string, object> values = new Dictionary <string, object>();
values.Add(view.TreeRelatedFieldName, parentKey);
values.Add(view.DisplayColumn, name);
DataAccess.SqlAccess da = new DataAccess.SqlAccess();
int?id = da.Create(view, values, null, bfCreate, bfDbCreate, afCreate, afCreateAndCommit);
if (id.HasValue && id.Value > 0)
{
return(id.Value.ToString());
}
else
{
return(string.Empty);
}
}
