private UnitType_ DataTableToEntity(DataTable dt)
{
UnitType_ unitType = new UnitType_();
if (Null.IsNotNull(dt) == true && dt.Rows.Count > 0)
{
if (Null.IsNotNull(dt.Rows[0]))
{
DataRow dr = dt.Rows[0];
if (Null.IsNotNull(dr["ID"]))
{
unitType.ID = Convert.ToInt32(dr["ID"]);
}
else
{
unitType.ID = 0;
}
if (Null.IsNotNull(dr["UnitTypeName"]))
{
unitType.UnitTypeName = Convert.ToString(dr["UnitTypeName"]);
}
else
{
unitType.UnitTypeName = string.Empty;
}
if (Null.IsNotNull(dr["ShortUnitTypeName"]))
{
unitType.ShortUnitTypeName = Convert.ToString(dr["ShortUnitTypeName"]);
}
else
{
unitType.ShortUnitTypeName = string.Empty;
}
if (Null.IsNotNull(dr["Status"]))
{
unitType.Status = Convert.ToString(dr["Status"]);
}
else
{
unitType.Status = string.Empty;
}
}
}
return(unitType);
}
public int Update(UnitType_ unitType)
{
UpdateCommand.Parameters["@ID"].Value = unitType.ID;
UpdateCommand.Parameters["@UnitTypeName"].Value = unitType.UnitTypeName;
UpdateCommand.Parameters["@ShortUnitTypeName"].Value = unitType.ShortUnitTypeName;
UpdateCommand.Parameters["@Status"].Value = unitType.Status;
int returnValue = -1;
try
{
UpdateCommand.Connection.Open();
returnValue = UpdateCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
Logger.Write(ex);
}
finally
{
UpdateCommand.Connection.Close();
}
return(returnValue);
}
public int Insert(UnitType_ unitType)
{
InsertCommand.Parameters["@UnitTypeName"].Value = unitType.UnitTypeName;
InsertCommand.Parameters["@ShortUnitTypeName"].Value = unitType.ShortUnitTypeName;
InsertCommand.Parameters["@Status"].Value = unitType.Status;
int returnValue = -1;
try
{
InsertCommand.Connection.Open();
returnValue = (int)InsertCommand.ExecuteScalar();
}
catch (SqlException ex)
{
Logger.Write(ex);
}
finally
{
InsertCommand.Connection.Close();
}
return(returnValue);
}
