/// <summary>
/// addLenelTimeZone: Graba la definicion completa de una TimeZone(TZNum) a la base, para lo cual borra previamente la definicion anterior
/// </summary>
/// <param name="v_LNLTimeZones"></param>
/// <param name="v_OrgID"></param>
/// <param name="v_TZNum"></param>
public void addLenelTimeZone(LENELTimeZones v_LNLTimeZones, int v_OrgID, int v_TZNum)
{
SqlConnection cnn = new SqlConnection(conexion);
try
{
cnn.Open();
SqlCommand cmd = cnn.CreateCommand();
cmd.CommandText = "delete from TimeZones where idOrganizacion =" + v_OrgID.ToString() + " and TZNum = " + v_TZNum.ToString();
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
TimeZoneData TZData = v_LNLTimeZones.getTimeZoneData();
if (TZData != null)
{
if (TZData.TZDefinition.ContainsKey(v_TZNum))
{
List<TZInterval> ReaderTZDef = TZData.TZDefinition[v_TZNum];
foreach (TZInterval intervalo in ReaderTZDef)
{
string rangoini = intervalo.horaIni.ToString() + ":" + intervalo.minIni.ToString();
string rangoFin = intervalo.horaFin.ToString() + ":" + intervalo.minFin.ToString();
cmd = cnn.CreateCommand();
cmd.CommandText = "insert into TimeZones (idOrganizacion,TZNum,rangoIni,rangoFin,DOW,HOL) values (" + v_OrgID.ToString() + "," + v_TZNum.ToString() + ",'" + rangoini + "','" + rangoFin + "'," + intervalo.DOW.ToString() + "," + intervalo.HOL.ToString() + ")";
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
}
}
}
catch (Exception ex)
{
loguearString("Excepcion en addLenelTimeZone: " + ex.Message, TiposLOG.HH);
}
finally
{
cnn.Close();
}
}
