public int InsertDoorOption(DoorOption pDoorOption)
{
try
{
return(_AD.InsertDoorOption(pDoorOption));
}
catch (Exception ex)
{
throw;
}
}
public bool UpdateDoorOption(DoorOption pDoorOption)
{
try
{
_AD.UpdateDoorOption(pDoorOption);
return(true);
}
catch (Exception ex)
{
throw;
}
}
public int InsertDoorOption(DoorOption pDoorOption)
{
string sql = @"[spInsertDoorOption] '{0}', '{1}', '{2}', '{3}'";
sql = string.Format(sql, pDoorOption.Description, pDoorOption.Status.Id,
pDoorOption.CreatorUser, pDoorOption.ModificationUser);
try
{
return(_MB.EjecutarSQL(_CN, sql));
}
catch (Exception err)
{
throw err;
}
}
public void UpdateDoorOption(DoorOption pDoorOption)
{
string sql = @"[spUpdateDoorOption] '{0}', '{1}', '{2}', '{3}'";
sql = string.Format(sql, pDoorOption.Id, pDoorOption.Description, pDoorOption.Status.Id,
pDoorOption.ModificationUser);
try
{
_MB.EjecutarSQL(_CN, sql);
}
catch (Exception err)
{
throw err;
}
}
public DoorOption GetDoorOptionById(int Id)
{
DoorOption pDoorOption = new DoorOption();
string sql = @"[spGetDoorOption] '{0}' ";
sql = string.Format(sql, Id);
try
{
DataSet ds = new DataSet();
ds = _MB.CreaDS(ds, "DoorOption", sql, _CN);
if (ds.Tables["DoorOption"].Rows.Count > 0)
{
foreach (DataRow item in ds.Tables["DoorOption"].Rows)
{
pDoorOption = new DoorOption()
{
Id = int.Parse(item["Id"].ToString()),
Status = new Status()
{
Id = int.Parse(item["IdStatus"].ToString()), Description = item["DescripStatus"].ToString()
},
Description = item["Description"].ToString(),
CreationDate = (item["CreationDate"].ToString() != "") ? DateTime.Parse(item["CreationDate"].ToString()) : DateTime.Parse("01/01/1900"),
ModificationDate = (item["ModificationDate"].ToString() != "") ? DateTime.Parse(item["ModificationDate"].ToString()) : DateTime.Parse("01/01/1900"),
CreatorUser = int.Parse(item["CreatorUser"].ToString()),
ModificationUser = int.Parse(item["ModificationUser"].ToString()),
};
}
}
return(pDoorOption);
}
catch (Exception)
{
throw;
}
}
private int ActivateDoor( DoorOption Action )
{
ReturnCode = GetStringBuilder();
CommandLine = "set cd door ";
switch(Action)
{
case(DoorOption.Opendoor):
ActionLine = "open";
break;
case(DoorOption.Closedoor):
ActionLine = "closed";
break;
}
CommandLine = CommandLine + " " + ActionLine;
return MciSendString( CommandLine, ReturnCode, ReturnCode.Length, new IntPtr(0) );
}
public object DeleteDoorOption(DoorOption dDoorOption)
{
throw new NotImplementedException();
}