public int personLevelIsDuplicate(E_PersonLevel oPersonLevel)
{
SqlConnection sqlCnn = null;
SqlCommand sqlCmd = null;
int result = -1;
Util.Tools.Clear(sql);
sql.Append("SELECT COUNT(1) ")
.Append("FROM person_level ")
.Append("WHERE level_description = @Level_Description ");
System.Diagnostics.Debug.WriteLine(sql.ToString());
try
{
sqlCnn = oConn.GetConnection();
sqlCmd = new SqlCommand(sql.ToString(), sqlCnn);
sqlCmd.Parameters.AddWithValue("@Level_Description", oPersonLevel.getLevel_Description());
result = (int)sqlCmd.ExecuteScalar();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
throw ex;
}
finally {
sqlCmd.Dispose();
sqlCnn.Close();
}
return(result);
}
public static E_PersonLevel ePersonLevelDuplicate()
{
E_PersonLevel oEPersonLevel = new E_PersonLevel();
oEPersonLevel.setId_Level("0001");
oEPersonLevel.setLevel_Description("GENERAL");
oEPersonLevel.setLevel_Status(true);
oEPersonLevel.setLevel_CreateBy("psalas");
oEPersonLevel.setLevel_DateBy(DateTime.Today.ToString());
return(oEPersonLevel);
}
public static E_PersonLevel ePersonLevelNotDuplicate()
{
E_PersonLevel oEPersonLevel = new E_PersonLevel();
oEPersonLevel.setId_Level("TEST");
oEPersonLevel.setLevel_Description("TEST DESCRIPTION");
oEPersonLevel.setLevel_Status(true);
oEPersonLevel.setLevel_CreateBy("psalas");
oEPersonLevel.setLevel_DateBy(DateTime.Today.ToString());
return(oEPersonLevel);
}
public int personLevelIns(E_PersonLevel oPersonLevel)
{
SqlConnection sqlCnn = null;
SqlCommand sqlCmd = null;
int result = -1;
Util.Tools.Clear(sql);
sql.Append("INSERT INTO Person_Level( ")
.Append("id_Level, ")
.Append("Level_Description, ")
.Append("Level_status, ")
.Append("Level_CreateBy, ")
.Append("Level_DateBy ")
.Append(") ")
.Append("VALUES ( ")
.Append("@id_Level, ")
.Append("@Level_Description, ")
.Append("@Level_status, ")
.Append("@Level_CreateBy, ")
.Append("@Level_DateBy ")
.Append(") ");
System.Diagnostics.Debug.WriteLine(sql.ToString());
try {
sqlCnn = oConn.GetConnection();
sqlCmd = new SqlCommand(sql.ToString(), sqlCnn);
sqlCmd.Parameters.AddWithValue("@id_Level", oPersonLevel.getId_Level());
sqlCmd.Parameters.AddWithValue("@Level_Description", oPersonLevel.getLevel_Description());
sqlCmd.Parameters.AddWithValue("@Level_status", oPersonLevel.getLevel_Status());
sqlCmd.Parameters.AddWithValue("@Level_CreateBy", oPersonLevel.getLevel_CreateBy());
sqlCmd.Parameters.AddWithValue("@Level_DateBy", oPersonLevel.getLevel_DateBy());
result = sqlCmd.ExecuteNonQuery();
}
catch (Exception ex) {
System.Diagnostics.Debug.WriteLine(ex.Message.ToString());
throw ex;
}
finally {
sqlCmd.Dispose();
sqlCnn.Close();
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
/*DModulo moduloDao = new DModulo();
* List<String> list = new List<String>() { "AD","AUD","BBOX" };
* moduloDao.moduloLstGetByIds(list);*/
/*DModulo moduloDao = new DModulo();
* moduloDao.moduloCmb();*/
/*I_BL_Modulo oBL_Modulo = new BL_ModuloImpl();
* oBL_Modulo.moduloCmb();*/
E_PersonLevel oEPersonLevel = new E_PersonLevel();
oEPersonLevel.setId_Level("TEST");
oEPersonLevel.setLevel_Description("TEST LEVEL");
oEPersonLevel.setLevel_Status(true);
oEPersonLevel.setLevel_CreateBy("psalas");
oEPersonLevel.setLevel_DateBy(DateTime.Today.ToString());
I_DaoPersonLevel oDaoPersonLevel = new DaoPersonLevelImpl();
oDaoPersonLevel.personLevelIns(oEPersonLevel);
}
