/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of CDocumentation</returns>
internal List <CDocumentation> PopulateObjectsFromReader(IDataReader dataReader)
{
List <CDocumentation> list = new List <CDocumentation>();
while (dataReader.Read())
{
CDocumentation businessObject = new CDocumentation();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
void AddParentNode()
{
// --- this method add a son node for one selected node
CDocumentation_User_File oDocUserFile =
new CDocumentation_User_File
{
Iddocumentation = -1,
Idtemplate_method = null,
Idconfiguration_folder = Convert.ToInt16(cbDocument.EditValue),
Name_doc = "Certificado",
Procedure_type = Convert.ToChar(cbProcedure.EditValue),
Type_doc = 'C',
Image_index = 0,
Id = GetNewIdNode(),
Parentid = 0,
Date_ini = DateTime.Now,
Date_end = DateTime.Now.AddMonths(12),
Rank_valid_inmonth = 12,
Prev_authorized = false
};
lstDocumentation_user_file.Add(oDocUserFile);
// --- save
CDocumentationFactory faDocumentation = new CDocumentationFactory();
CDocumentation oDocumentation = new CDocumentation();
oDocumentation.Iddocumentation = oDocUserFile.Iddocumentation;
oDocumentation.Idconfiguration_folder = oDocUserFile.Idconfiguration_folder;
oDocumentation.Idtemplate_method = oDocUserFile.Idtemplate_method;
oDocumentation.Image_index = oDocUserFile.Image_index;
oDocumentation.Name_doc = oDocUserFile.Name_doc;
oDocumentation.Procedure_type = oDocUserFile.Procedure_type;
oDocumentation.Type_doc = oDocUserFile.Type_doc;
oDocumentation.Flag_enabled = true;
oDocumentation.Id = oDocUserFile.Id;
oDocumentation.Parentid = oDocUserFile.Parentid;
oDocumentation.Usernew = Comun.GetUser();
oDocumentation.Useredit = Comun.GetUser();
oDocumentation.Datenew = DateTime.Now;
oDocumentation.Dateedit = DateTime.Now;
oDocumentation.Status = true;
treeAuthorization.DataSource = lstDocumentation_user_file;
faDocumentation.Insert(oDocumentation);
treeAuthorization.DataSource = lstDocumentation_user_file;
}
/// <summary>
/// Select by primary key
/// </summary>
/// <param name="keys">primary keys</param>
/// <returns>CDocumentation business object</returns>
public CDocumentation SelectByPrimaryKey(CDocumentationKeys keys)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_documentation_SelectByPrimaryKey";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new NpgsqlParameter("p_iddocumentation", NpgsqlDbType.Smallint, 2, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Iddocumentation));
MainConnection.Open();
NpgsqlDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
CDocumentation businessObject = new CDocumentation();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("CDocumentation::SelectByPrimaryKey::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
private void treeAuthorization_CellValueChanged(object sender, DevExpress.XtraTreeList.CellValueChangedEventArgs e)
{
if (e.Column == gcDoc_Rank_valid_inmonth ||
e.Column == gcDoc_Prev_authorized)
{
DateTime fend = Convert.ToDateTime(e.Node.GetValue("Date_ini")).AddMonths(Convert.ToInt32(e.Node.GetValue("Rank_valid_inmonth")));
e.Node.SetValue("Date_end", fend);
// --- save
CDocumentationFactory faDocumentation = new CDocumentationFactory();
CDocumentation oDocumentation =
faDocumentation
.GetByPrimaryKey(new CDocumentationKeys(Convert.ToInt16(e.Node.GetValue("Iddocumentation"))));
if (oDocumentation == null)
{
oDocumentation = new CDocumentation();
oDocumentation.Iddocumentation = 0;
}
oDocumentation.Idconfiguration_folder = Convert.ToInt16(e.Node.GetValue("Idconfiguration_folder"));
if (e.Node.GetValue("Idtemplate_method") != null)
{
oDocumentation.Idtemplate_method = Convert.ToInt32(e.Node.GetValue("Idtemplate_method"));
}
oDocumentation.Image_index = Convert.ToInt32(e.Node.GetValue("Image_index"));
oDocumentation.Name_doc = e.Node.GetValue("Name_doc").ToString();
oDocumentation.Procedure_type = Convert.ToChar(e.Node.GetValue("Procedure_type"));
oDocumentation.Type_doc = Convert.ToChar(e.Node.GetValue("Type_doc"));
oDocumentation.Flag_enabled = true;
oDocumentation.Id = Convert.ToInt32(e.Node.GetValue("Id"));
oDocumentation.Parentid = Convert.ToInt32(e.Node.GetValue("Parentid"));
oDocumentation.Usernew = Comun.GetUser();
oDocumentation.Useredit = Comun.GetUser();
oDocumentation.Datenew = DateTime.Now;
oDocumentation.Dateedit = DateTime.Now;
oDocumentation.Status = true;
treeAuthorization.DataSource = lstDocumentation_user_file;
bool result = false;
if (!(result = faDocumentation.Update(oDocumentation)))
{
result = faDocumentation.Insert(oDocumentation);
}
// --- Guardar acceso el usuario
if (result)
{
CDocumentation_userFactory faDocumentation_user = new CDocumentation_userFactory();
CDocumentation_user oDocumentation_user = new CDocumentation_user();
List <CDocumentation_user> lst = faDocumentation_user.GetAll();
if (lst.Exists(c => c.Iddocumentation == oDocumentation.Iddocumentation &&
c.Iduser == Convert.ToInt16(cbUser.EditValue)))
{
oDocumentation_user =
faDocumentation_user
.GetAll()
.Single(c => c.Iddocumentation == oDocumentation.Iddocumentation &&
c.Iduser == Convert.ToInt16(cbUser.EditValue));
}
else
{
oDocumentation_user = new CDocumentation_user();
oDocumentation_user.Iddocumentation_user = 0;
}
oDocumentation_user.Iddocumentation = oDocumentation.Iddocumentation;
oDocumentation_user.Date_ini = Convert.ToDateTime(e.Node.GetValue("Date_ini"));
oDocumentation_user.Date_end = Convert.ToDateTime(e.Node.GetValue("Date_end"));
oDocumentation_user.Rank_valid_inmonth = Convert.ToInt32(e.Node.GetValue("Rank_valid_inmonth"));
oDocumentation_user.Prev_authorized = Convert.ToBoolean(e.Node.GetValue("Prev_authorized"));
oDocumentation_user.Iduser = Convert.ToInt16(cbUser.EditValue);
if (!faDocumentation_user.Update(oDocumentation_user))
{
faDocumentation_user.Insert(oDocumentation_user);
}
}
}
}
void AddChildNode()
{
// ---
if (treeAuthorization.FocusedNode.Level == 0)
{
CDocumentation_User_File oDocUserFile =
new CDocumentation_User_File
{
Iddocumentation = -1,
Idtemplate_method = null,
Idconfiguration_folder = Convert.ToInt16(cbDocument.EditValue),
Name_doc = "Adjunto",
Procedure_type = Convert.ToChar(cbProcedure.EditValue),
Type_doc = 'E',
Id = GetNewIdNode(),
Image_index = 1,
Parentid = Convert.ToInt32(treeAuthorization.FocusedNode["Id"]),
Date_ini = DateTime.Now,
Date_end = DateTime.Now.AddMonths(12),
Rank_valid_inmonth = 12,
Prev_authorized = false
};
lstDocumentation_user_file.Add(oDocUserFile);
// --- save
CDocumentationFactory faDocumentation = new CDocumentationFactory();
CDocumentation oDocumentation = new CDocumentation();
oDocumentation.Iddocumentation = oDocUserFile.Iddocumentation;
oDocumentation.Idconfiguration_folder = oDocUserFile.Idconfiguration_folder;
oDocumentation.Idtemplate_method = oDocUserFile.Idtemplate_method;
oDocumentation.Image_index = oDocUserFile.Image_index;
oDocumentation.Name_doc = oDocUserFile.Name_doc;
oDocumentation.Procedure_type = oDocUserFile.Procedure_type;
oDocumentation.Type_doc = oDocUserFile.Type_doc;
oDocumentation.Flag_enabled = true;
oDocumentation.Id = oDocUserFile.Id;
oDocumentation.Parentid = oDocUserFile.Parentid;
oDocumentation.Usernew = Comun.GetUser();
oDocumentation.Useredit = Comun.GetUser();
oDocumentation.Datenew = DateTime.Now;
oDocumentation.Dateedit = DateTime.Now;
oDocumentation.Status = true;
treeAuthorization.DataSource = lstDocumentation_user_file;
//faDocumentation.Insert(oDocumentation);
treeAuthorization.DataSource = lstDocumentation_user_file;
treeAuthorization.FocusedNode.ExpandAll();
}
else if (treeAuthorization.FocusedNode.Level == 1)
{
CDocumentation_User_File oDocUserFile =
new CDocumentation_User_File
{
Iddocumentation = -1,
Idtemplate_method = null,
Idconfiguration_folder = Convert.ToInt16(cbDocument.EditValue),
Procedure_type = Convert.ToChar(cbProcedure.EditValue),
Type_doc = 'E',
Id = GetNewIdNode(),
Image_index = 1,
Parentid = Convert.ToInt32(treeAuthorization.FocusedNode.ParentNode["Id"]),
Date_ini = DateTime.Now,
Date_end = DateTime.Now.AddMonths(12),
Rank_valid_inmonth = 12,
Prev_authorized = false
};
lstDocumentation_user_file.Add(oDocUserFile);
// --- save
CDocumentationFactory faDocumentation = new CDocumentationFactory();
CDocumentation oDocumentation = new CDocumentation();
oDocumentation.Iddocumentation = oDocUserFile.Iddocumentation;
oDocumentation.Idconfiguration_folder = oDocUserFile.Idconfiguration_folder;
oDocumentation.Idtemplate_method = oDocUserFile.Idtemplate_method;
oDocumentation.Image_index = oDocUserFile.Image_index;
oDocumentation.Name_doc = oDocUserFile.Name_doc;
oDocumentation.Procedure_type = oDocUserFile.Procedure_type;
oDocumentation.Type_doc = oDocUserFile.Type_doc;
oDocumentation.Flag_enabled = true;
oDocumentation.Id = oDocUserFile.Id;
oDocumentation.Parentid = oDocUserFile.Parentid;
oDocumentation.Usernew = Comun.GetUser();
oDocumentation.Useredit = Comun.GetUser();
oDocumentation.Datenew = DateTime.Now;
oDocumentation.Dateedit = DateTime.Now;
oDocumentation.Status = true;
treeAuthorization.DataSource = lstDocumentation_user_file;
//faDocumentation.Insert(oDocumentation);
}
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(CDocumentation businessObject, IDataReader dataReader)
{
businessObject.Iddocumentation = (short)dataReader.GetInt16(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Iddocumentation.ToString()));
businessObject.Idconfiguration_folder = (short)dataReader.GetInt16(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Idconfiguration_folder.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Idtemplate_method.ToString())))
{
businessObject.Idtemplate_method = dataReader.GetInt32(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Idtemplate_method.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Procedure_type.ToString())))
{
businessObject.Procedure_type = dataReader.GetChar(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Procedure_type.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Code.ToString())))
{
businessObject.Code = dataReader.GetInt32(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Code.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Name_doc.ToString())))
{
businessObject.Name_doc = dataReader.GetString(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Name_doc.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Type_doc.ToString())))
{
businessObject.Type_doc = dataReader.GetChar(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Type_doc.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Id.ToString())))
{
businessObject.Id = dataReader.GetInt32(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Id.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Parentid.ToString())))
{
businessObject.Parentid = dataReader.GetInt32(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Parentid.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Flag_enabled.ToString())))
{
businessObject.Flag_enabled = dataReader.GetBoolean(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Flag_enabled.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Image_index.ToString())))
{
businessObject.Image_index = dataReader.GetInt32(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Image_index.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Usernew.ToString())))
{
businessObject.Usernew = dataReader.GetString(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Usernew.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Datenew.ToString())))
{
businessObject.Datenew = dataReader.GetDateTime(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Datenew.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Useredit.ToString())))
{
businessObject.Useredit = dataReader.GetString(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Useredit.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Dateedit.ToString())))
{
businessObject.Dateedit = dataReader.GetDateTime(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Dateedit.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Status.ToString())))
{
businessObject.Status = dataReader.GetBoolean(dataReader.GetOrdinal(CDocumentation.CDocumentationFields.Status.ToString()));
}
}
/// <summary>
/// insert new row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true of successfully insert</returns>
public bool Insert(CDocumentation businessObject)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_documentation_Insert";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.AddWithValue("p_iddocumentation", businessObject.Iddocumentation);
sqlCommand.Parameters["p_iddocumentation"].NpgsqlDbType = NpgsqlDbType.Smallint;
sqlCommand.Parameters["p_iddocumentation"].Direction = ParameterDirection.InputOutput;
sqlCommand.Parameters.AddWithValue("p_idconfiguration_folder", businessObject.Idconfiguration_folder);
sqlCommand.Parameters["p_idconfiguration_folder"].NpgsqlDbType = NpgsqlDbType.Smallint;
sqlCommand.Parameters.AddWithValue("p_idtemplate_method", businessObject.Idtemplate_method);
sqlCommand.Parameters["p_idtemplate_method"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_procedure_type", businessObject.Procedure_type);
sqlCommand.Parameters["p_procedure_type"].NpgsqlDbType = NpgsqlDbType.Char;
sqlCommand.Parameters.AddWithValue("p_code", businessObject.Code);
sqlCommand.Parameters["p_code"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_name_doc", businessObject.Name_doc);
sqlCommand.Parameters["p_name_doc"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_type_doc", businessObject.Type_doc);
sqlCommand.Parameters["p_type_doc"].NpgsqlDbType = NpgsqlDbType.Char;
sqlCommand.Parameters.AddWithValue("p_id", businessObject.Id);
sqlCommand.Parameters["p_id"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_parentid", businessObject.Parentid);
sqlCommand.Parameters["p_parentid"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_flag_enabled", businessObject.Flag_enabled);
sqlCommand.Parameters["p_flag_enabled"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_image_index", businessObject.Image_index);
sqlCommand.Parameters["p_image_index"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_usernew", businessObject.Usernew);
sqlCommand.Parameters["p_usernew"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_datenew", businessObject.Datenew);
sqlCommand.Parameters["p_datenew"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_useredit", businessObject.Useredit);
sqlCommand.Parameters["p_useredit"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_dateedit", businessObject.Dateedit);
sqlCommand.Parameters["p_dateedit"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_status", businessObject.Status);
sqlCommand.Parameters["p_status"].NpgsqlDbType = NpgsqlDbType.Boolean;
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
businessObject.Iddocumentation = Convert.ToInt16(sqlCommand.Parameters["p_iddocumentation"].Value);
return(true);
}
catch (Exception ex)
{
throw new Exception("CDocumentation::Insert::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
void AddChildNode()
{
// ---
if (treeAuthorization.FocusedNode.Level == 0)
{
CDocumentation_User_File oDocUserFile =
new CDocumentation_User_File
{
Iddocumentation = -1,
Idtemplate_method = null,
Idconfiguration_folder = Convert.ToInt16(cbDocument.EditValue),
Name_doc = "Adjunto",
Procedure_type = Convert.ToChar(cbProcedure.EditValue),
Type_doc = 'E',
Id = GetNewIdNode(),
Image_index = 1,
Parentid = Convert.ToInt32(treeAuthorization.FocusedNode["Id"]),
Date_ini = DateTime.Now,
Date_end = DateTime.Now.AddMonths(12),
Rank_valid_inmonth = 12,
Prev_authorized = false
};
lstDocumentation_user_file.Add(oDocUserFile);
// --- save
CDocumentationFactory faDocumentation = new CDocumentationFactory();
CDocumentation oDocumentation = new CDocumentation();
oDocumentation.Iddocumentation = oDocUserFile.Iddocumentation;
oDocumentation.Idconfiguration_folder = oDocUserFile.Idconfiguration_folder;
oDocumentation.Idtemplate_method = oDocUserFile.Idtemplate_method;
oDocumentation.Image_index = oDocUserFile.Image_index;
oDocumentation.Name_doc = oDocUserFile.Name_doc;
oDocumentation.Procedure_type = oDocUserFile.Procedure_type;
oDocumentation.Type_doc = oDocUserFile.Type_doc;
oDocumentation.Flag_enabled = true;
oDocumentation.Id = oDocUserFile.Id;
oDocumentation.Parentid = oDocUserFile.Parentid;
oDocumentation.Usernew = Comun.GetUser();
oDocumentation.Useredit = Comun.GetUser();
oDocumentation.Datenew = DateTime.Now;
oDocumentation.Dateedit = DateTime.Now;
oDocumentation.Status = true;
treeAuthorization.DataSource = lstDocumentation_user_file;
//faDocumentation.Insert(oDocumentation);
treeAuthorization.DataSource = lstDocumentation_user_file;
treeAuthorization.FocusedNode.ExpandAll();
}
else if (treeAuthorization.FocusedNode.Level == 1)
{
CDocumentation_User_File oDocUserFile =
new CDocumentation_User_File
{
Iddocumentation = -1,
Idtemplate_method = null,
Idconfiguration_folder = Convert.ToInt16(cbDocument.EditValue),
Procedure_type = Convert.ToChar(cbProcedure.EditValue),
Type_doc = 'E',
Id = GetNewIdNode(),
Image_index = 1,
Parentid = Convert.ToInt32(treeAuthorization.FocusedNode.ParentNode["Id"]),
Date_ini = DateTime.Now,
Date_end = DateTime.Now.AddMonths(12),
Rank_valid_inmonth = 12,
Prev_authorized = false
};
lstDocumentation_user_file.Add(oDocUserFile);
// --- save
CDocumentationFactory faDocumentation = new CDocumentationFactory();
CDocumentation oDocumentation = new CDocumentation();
oDocumentation.Iddocumentation = oDocUserFile.Iddocumentation;
oDocumentation.Idconfiguration_folder = oDocUserFile.Idconfiguration_folder;
oDocumentation.Idtemplate_method = oDocUserFile.Idtemplate_method;
oDocumentation.Image_index = oDocUserFile.Image_index;
oDocumentation.Name_doc = oDocUserFile.Name_doc;
oDocumentation.Procedure_type = oDocUserFile.Procedure_type;
oDocumentation.Type_doc = oDocUserFile.Type_doc;
oDocumentation.Flag_enabled = true;
oDocumentation.Id = oDocUserFile.Id;
oDocumentation.Parentid = oDocUserFile.Parentid;
oDocumentation.Usernew = Comun.GetUser();
oDocumentation.Useredit = Comun.GetUser();
oDocumentation.Datenew = DateTime.Now;
oDocumentation.Dateedit = DateTime.Now;
oDocumentation.Status = true;
treeAuthorization.DataSource = lstDocumentation_user_file;
//faDocumentation.Insert(oDocumentation);
}
}
private void treeAuthorization_CellValueChanged(object sender, DevExpress.XtraTreeList.CellValueChangedEventArgs e)
{
if (e.Column == gcDoc_Rank_valid_inmonth
|| e.Column == gcDoc_Prev_authorized)
{
DateTime fend = Convert.ToDateTime(e.Node.GetValue("Date_ini")).AddMonths(Convert.ToInt32(e.Node.GetValue("Rank_valid_inmonth")));
e.Node.SetValue("Date_end", fend);
// --- save
CDocumentationFactory faDocumentation = new CDocumentationFactory();
CDocumentation oDocumentation =
faDocumentation
.GetByPrimaryKey(new CDocumentationKeys(Convert.ToInt16(e.Node.GetValue("Iddocumentation"))));
if (oDocumentation == null)
{
oDocumentation = new CDocumentation();
oDocumentation.Iddocumentation = 0;
}
oDocumentation.Idconfiguration_folder = Convert.ToInt16(e.Node.GetValue("Idconfiguration_folder"));
if (e.Node.GetValue("Idtemplate_method") != null)
oDocumentation.Idtemplate_method = Convert.ToInt32(e.Node.GetValue("Idtemplate_method"));
oDocumentation.Image_index = Convert.ToInt32(e.Node.GetValue("Image_index"));
oDocumentation.Name_doc = e.Node.GetValue("Name_doc").ToString();
oDocumentation.Procedure_type = Convert.ToChar(e.Node.GetValue("Procedure_type"));
oDocumentation.Type_doc = Convert.ToChar(e.Node.GetValue("Type_doc"));
oDocumentation.Flag_enabled = true;
oDocumentation.Id = Convert.ToInt32(e.Node.GetValue("Id"));
oDocumentation.Parentid = Convert.ToInt32(e.Node.GetValue("Parentid"));
oDocumentation.Usernew = Comun.GetUser();
oDocumentation.Useredit = Comun.GetUser();
oDocumentation.Datenew = DateTime.Now;
oDocumentation.Dateedit = DateTime.Now;
oDocumentation.Status = true;
treeAuthorization.DataSource = lstDocumentation_user_file;
bool result = false;
if (!(result = faDocumentation.Update(oDocumentation)))
result = faDocumentation.Insert(oDocumentation);
// --- Guardar acceso el usuario
if (result)
{
CDocumentation_userFactory faDocumentation_user = new CDocumentation_userFactory();
CDocumentation_user oDocumentation_user = new CDocumentation_user();
List<CDocumentation_user> lst = faDocumentation_user.GetAll();
if (lst.Exists(c => c.Iddocumentation == oDocumentation.Iddocumentation
&& c.Iduser == Convert.ToInt16(cbUser.EditValue)))
{
oDocumentation_user =
faDocumentation_user
.GetAll()
.Single(c => c.Iddocumentation == oDocumentation.Iddocumentation
&& c.Iduser == Convert.ToInt16(cbUser.EditValue));
}
else
{
oDocumentation_user = new CDocumentation_user();
oDocumentation_user.Iddocumentation_user = 0;
}
oDocumentation_user.Iddocumentation = oDocumentation.Iddocumentation;
oDocumentation_user.Date_ini = Convert.ToDateTime(e.Node.GetValue("Date_ini"));
oDocumentation_user.Date_end = Convert.ToDateTime(e.Node.GetValue("Date_end"));
oDocumentation_user.Rank_valid_inmonth = Convert.ToInt32(e.Node.GetValue("Rank_valid_inmonth"));
oDocumentation_user.Prev_authorized = Convert.ToBoolean(e.Node.GetValue("Prev_authorized"));
oDocumentation_user.Iduser = Convert.ToInt16(cbUser.EditValue);
if (!faDocumentation_user.Update(oDocumentation_user))
faDocumentation_user.Insert(oDocumentation_user);
}
}
}
void AddParentNode()
{
// --- this method add a son node for one selected node
CDocumentation_User_File oDocUserFile =
new CDocumentation_User_File
{
Iddocumentation = -1,
Idtemplate_method = null,
Idconfiguration_folder = Convert.ToInt16(cbDocument.EditValue),
Name_doc = "Certificado",
Procedure_type = Convert.ToChar(cbProcedure.EditValue),
Type_doc = 'C',
Image_index = 0,
Id = GetNewIdNode(),
Parentid = 0,
Date_ini = DateTime.Now,
Date_end = DateTime.Now.AddMonths(12),
Rank_valid_inmonth = 12,
Prev_authorized = false
};
lstDocumentation_user_file.Add(oDocUserFile);
// --- save
CDocumentationFactory faDocumentation = new CDocumentationFactory();
CDocumentation oDocumentation = new CDocumentation();
oDocumentation.Iddocumentation = oDocUserFile.Iddocumentation;
oDocumentation.Idconfiguration_folder = oDocUserFile.Idconfiguration_folder;
oDocumentation.Idtemplate_method = oDocUserFile.Idtemplate_method;
oDocumentation.Image_index = oDocUserFile.Image_index;
oDocumentation.Name_doc = oDocUserFile.Name_doc;
oDocumentation.Procedure_type = oDocUserFile.Procedure_type;
oDocumentation.Type_doc = oDocUserFile.Type_doc;
oDocumentation.Flag_enabled = true;
oDocumentation.Id = oDocUserFile.Id;
oDocumentation.Parentid = oDocUserFile.Parentid;
oDocumentation.Usernew = Comun.GetUser();
oDocumentation.Useredit = Comun.GetUser();
oDocumentation.Datenew = DateTime.Now;
oDocumentation.Dateedit = DateTime.Now;
oDocumentation.Status = true;
treeAuthorization.DataSource = lstDocumentation_user_file;
faDocumentation.Insert(oDocumentation);
treeAuthorization.DataSource = lstDocumentation_user_file;
}
