// POST: api/SubDomain
/// <summary>
/// It takes parameter SUB_DOMAIN model.
/// If SUB_DOMAIN.SUB_DOM_ID = 0 or NULL then it performs INSERT.
/// If SUB_DOMAIN.SUB_DOM_ID > 0 and SUB_DOMAIN.DEL_FLG=N then it performs UPDATE.
/// If SUB_DOMAIN.DEL_FLG=Y then it performs DELETE.
/// </summary>
/// <param name="sd"></param>
public void Post([FromBody] SUB_DOMAIN sd)
{
if ((sd.SUB_DOM_ID.HasValue ? sd.SUB_DOM_ID.Value : 0) == 0)
{
_logicLayer.InsertSubDomain(sd);
}
else
if (sd.SUB_DOM_ID.Value > 0 && (string.IsNullOrWhiteSpace(sd.DEL_FLG) ? "N" : sd.DEL_FLG) == "N")
{
_logicLayer.UpdateSubDomain(sd);
}
else
{
_logicLayer.DeleteSubDomain(sd.SUB_DOM_ID.Value);
}
}
internal void InsertSubDomain(SUB_DOMAIN sdm)
{
using (var connection = MySqlDbConnection.NewConnection)
{
_statement = string.Format(MySQLquery.InsertSubDomain,
sdm.DOM_ID.Value,
string.Concat("'", sdm.NAME, "'"),
string.Concat("'", sdm.DESCRIPTION, "'"),
string.Concat("'", string.IsNullOrWhiteSpace(sdm.DEL_FLG) ? "N" : sdm.DEL_FLG, "'"),
string.Concat("'", string.IsNullOrWhiteSpace(sdm.ORGL_USER) ? "ADMIN" : sdm.ORGL_USER, "'"),
"SYSDATE()"
);
using (var command = MySqlDbConnection.Command(connection, _statement))
{
command.ExecuteNonQuery();
}
}
}
internal void UpdateSubDomain(SUB_DOMAIN sdm)
{
using (var connection = MySqlDbConnection.NewConnection)
{
_statement = string.Format(MySQLquery.UpdateSubDomain,
sdm.DOM_ID.HasValue ? Convert.ToString(sdm.DOM_ID.Value) : "DOM_ID",
string.IsNullOrWhiteSpace(sdm.NAME) ? "NAME" : string.Concat("'", sdm.NAME, "'"),
string.IsNullOrWhiteSpace(sdm.DESCRIPTION) ? "DESCRIPTION" : string.Concat("'", sdm.DESCRIPTION, "'"),
string.IsNullOrWhiteSpace(sdm.UPDT_USER) ? "UPDT_USER" : string.Concat("'", sdm.UPDT_USER, "'"),
"SYSDATE()",
sdm.SUB_DOM_ID.Value
);
using (var command = MySqlDbConnection.Command(connection, _statement))
{
command.ExecuteNonQuery();
}
}
}
internal List <SUB_DOMAIN> GetSubDomain(int id)
{
var subDomains = new List <SUB_DOMAIN>();
using (var connection = MySqlDbConnection.NewConnection)
{
_statement = string.Format(MySQLquery.GetSubDomainByDomId, id);
using (var command = MySqlDbConnection.Command(connection, _statement))
{
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var subDomain = new SUB_DOMAIN();
subDomain.SUB_DOM_ID = UtilityDL.CheckNull <int>(reader["SUB_DOM_ID"]);
subDomain.DOM_ID = UtilityDL.CheckNull <int>(reader["DOM_ID"]);
subDomain.NAME = UtilityDL.CheckNull <string>(reader["NAME"]);
subDomain.DESCRIPTION = UtilityDL.CheckNull <string>(reader["DESCRIPTION"]);
subDomain.ORGL_STAMP = UtilityDL.CheckNull <DateTime>(reader["ORGL_STAMP"]);
subDomain.ORGL_USER = UtilityDL.CheckNull <string>(reader["ORGL_USER"]);
subDomain.UPDT_STAMP = UtilityDL.CheckNull <DateTime>(reader["UPDT_STAMP"]);
subDomain.UPDT_USER = UtilityDL.CheckNull <string>(reader["UPDT_USER"]);
subDomain.DEL_FLG = UtilityDL.CheckNull <string>(reader["DEL_FLG"]);
subDomains.Add(subDomain);
}
}
}
}
}
return(subDomains);
}
internal void UpdateSubDomain(SUB_DOMAIN sd)
{
_dac.UpdateSubDomain(sd);
}
internal void InsertSubDomain(SUB_DOMAIN sd)
{
_dac.InsertSubDomain(sd);
}
// PUT: api/Domain/5
public void Put([FromBody] SUB_DOMAIN sd)
{
_logicLayer.UpdateSubDomain(sd);
}
