/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of CDocumentation_user</returns>
internal List <CDocumentation_user> PopulateObjectsFromReader(IDataReader dataReader)
{
List <CDocumentation_user> list = new List <CDocumentation_user>();
while (dataReader.Read())
{
CDocumentation_user businessObject = new CDocumentation_user();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
int GetErrorValid(CDocumentation_user document_user, int expire)
{
// 1:expired, 2:into to rank
if (document_user == null)
{
return(0);
}
else
{
if ((DateTime.Now.AddMonths(expire) > document_user.Date_end))
{
return(1);
}
}
return(2);
}
/// <summary>
/// Select by primary key
/// </summary>
/// <param name="keys">primary keys</param>
/// <returns>CDocumentation_user business object</returns>
public CDocumentation_user SelectByPrimaryKey(CDocumentation_userKeys keys)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_documentation_user_SelectByPrimaryKey";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new NpgsqlParameter("p_iddocumentation_user", NpgsqlDbType.Bigint, 8, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Iddocumentation_user));
MainConnection.Open();
NpgsqlDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
CDocumentation_user businessObject = new CDocumentation_user();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("CDocumentation_user::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);
}
}
}
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(CDocumentation_user businessObject, IDataReader dataReader)
{
businessObject.Iddocumentation_user = dataReader.GetInt64(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Iddocumentation_user.ToString()));
businessObject.Iddocumentation = (short)dataReader.GetInt16(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Iddocumentation.ToString()));
businessObject.Iduser = (short)dataReader.GetInt16(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Iduser.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Date_ini.ToString())))
{
businessObject.Date_ini = dataReader.GetDateTime(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Date_ini.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Date_end.ToString())))
{
businessObject.Date_end = dataReader.GetDateTime(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Date_end.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Name_file.ToString())))
{
businessObject.Name_file = dataReader.GetString(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Name_file.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Order_file.ToString())))
{
businessObject.Order_file = dataReader.GetInt64(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Order_file.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Extension_file.ToString())))
{
businessObject.Extension_file = dataReader.GetString(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Extension_file.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Prev_authorized.ToString())))
{
businessObject.Prev_authorized = dataReader.GetBoolean(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Prev_authorized.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Rank_valid_inmonth.ToString())))
{
businessObject.Rank_valid_inmonth = dataReader.GetInt32(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Rank_valid_inmonth.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Usernew.ToString())))
{
businessObject.Usernew = dataReader.GetString(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Usernew.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Datenew.ToString())))
{
businessObject.Datenew = dataReader.GetDateTime(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Datenew.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Useredit.ToString())))
{
businessObject.Useredit = dataReader.GetString(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Useredit.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Dateedit.ToString())))
{
businessObject.Dateedit = dataReader.GetDateTime(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Dateedit.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.Status.ToString())))
{
businessObject.Status = dataReader.GetBoolean(dataReader.GetOrdinal(CDocumentation_user.CDocumentation_userFields.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_user businessObject)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_documentation_user_Insert";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.AddWithValue("p_iddocumentation_user", businessObject.Iddocumentation_user);
sqlCommand.Parameters["p_iddocumentation_user"].NpgsqlDbType = NpgsqlDbType.Bigint;
sqlCommand.Parameters["p_iddocumentation_user"].Direction = ParameterDirection.InputOutput;
sqlCommand.Parameters.AddWithValue("p_iddocumentation", businessObject.Iddocumentation);
sqlCommand.Parameters["p_iddocumentation"].NpgsqlDbType = NpgsqlDbType.Smallint;
sqlCommand.Parameters.AddWithValue("p_iduser", businessObject.Iduser);
sqlCommand.Parameters["p_iduser"].NpgsqlDbType = NpgsqlDbType.Smallint;
sqlCommand.Parameters.AddWithValue("p_date_ini", businessObject.Date_ini);
sqlCommand.Parameters["p_date_ini"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_date_end", businessObject.Date_end);
sqlCommand.Parameters["p_date_end"].NpgsqlDbType = NpgsqlDbType.Timestamp;
sqlCommand.Parameters.AddWithValue("p_name_file", businessObject.Name_file);
sqlCommand.Parameters["p_name_file"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_order_file", businessObject.Order_file);
sqlCommand.Parameters["p_order_file"].NpgsqlDbType = NpgsqlDbType.Bigint;
sqlCommand.Parameters.AddWithValue("p_extension_file", businessObject.Extension_file);
sqlCommand.Parameters["p_extension_file"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_prev_authorized", businessObject.Prev_authorized);
sqlCommand.Parameters["p_prev_authorized"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_rank_valid_inmonth", businessObject.Rank_valid_inmonth);
sqlCommand.Parameters["p_rank_valid_inmonth"].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_user = Convert.ToInt64(sqlCommand.Parameters["p_iddocumentation_user"].Value);
return(true);
}
catch (Exception ex)
{
throw new Exception("CDocumentation_user::Insert::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);
}
}
}
