public RegimeModel GetRegime(string IdRegimeHora)
{
RegimeModel rm = new RegimeModel();
StringBuilder sb = new StringBuilder();
sb.AppendLine("SELECT IDRegimeHora,DSRegimeHora,TotalHoraSemana,TotalHoraDia, RegimePlantonista,PermitehoraExtra, TotalMaximoHoraExtraDia,TotalMaximoHoraExtraMes, TotalHorasFolgaPlantonista");
sb.AppendLine("FROM PontoFrequenciaPMC.dbo.TBRegimeHora");
sb.AppendLine("WHERE IdRegimeHora = " + IdRegimeHora);
SqlDataReader dr = Util.getDataReader(sb.ToString());
if (dr.Read())
{
rm.IDRegimeHora = dr["IDRegimeHora"].ToString();
rm.DSRegimeHora = dr["DSRegimeHora"].ToString();
rm.TotalHoraSemana = dr["TotalHoraSemana"].ToString();
rm.TotalHoraDia = dr["TotalHoraDia"].ToString();
rm.RegimePlantonista = dr["RegimePlantonista"].ToString();
rm.PermitehoraExtra = dr["PermitehoraExtra"].ToString();
rm.TotalMaximoHoraExtraDia = dr["TotalMaximoHoraExtraDia"].ToString();
rm.TotalMaximoHoraExtraMes = dr["TotalMaximoHoraExtraMes"].ToString();
rm.TotalHorasFolgaPlantonista = dr["TotalHorasFolgaPlantonista"].ToString();
}
dr.Close();
return(rm);
}
public void Salvar(RegimeModel item)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("");
sb.AppendLine("INSERT INTO dbo.TBRegimeHora");
sb.AppendLine("(DSRegimeHora, TotalHoraSemana, TotalHoraDia, RegimePlantonista, PermitehoraExtra, TotalMaximoHoraExtraDia, TotalMaximoHoraExtraMes, TotalHorasFolgaPlantonista)");
sb.AppendLine("VALUES");
sb.AppendLine("(" + Util.TratarStringAspas(item.DSRegimeHora) + ", " + Util.TratarNum(item.TotalHoraSemana) + ", " + Util.TratarNum(item.TotalHoraDia) + "," + Util.TratarNum(item.RegimePlantonista) +
", " + Util.TratarNum(item.PermitehoraExtra) + ", " + Util.TratarNum(item.TotalMaximoHoraExtraDia) + ", " + Util.TratarNum(item.TotalMaximoHoraExtraMes) + ", " + Util.TratarNum(item.TotalHorasFolgaPlantonista) + ")");
Util.ExecuteNonQuery(sb.ToString());
}
public void Alterar(RegimeModel item)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("");
sb.AppendLine("UPDATE dbo.TBRegimeHora");
sb.AppendLine("SET DSRegimeHora = " + Util.TratarStringAspas(item.DSRegimeHora));
sb.AppendLine(", TotalHoraSemana = " + Util.TratarNum(item.TotalHoraSemana));
sb.AppendLine(", TotalHoraDia = " + Util.TratarNum(item.TotalHoraDia));
sb.AppendLine(", RegimePlantonista = " + Util.TratarNum(item.RegimePlantonista));
sb.AppendLine(", PermitehoraExtra = " + Util.TratarNum(item.PermitehoraExtra));
sb.AppendLine(", TotalMaximoHoraExtraDia = " + Util.TratarNum(item.TotalMaximoHoraExtraDia));
sb.AppendLine(", TotalMaximoHoraExtraMes = " + Util.TratarNum(item.TotalMaximoHoraExtraMes));
sb.AppendLine(", TotalHorasFolgaPlantonista = " + Util.TratarNum(item.TotalHorasFolgaPlantonista));
sb.AppendLine("WHERE IDRegimeHora = " + Util.TratarString(item.IDRegimeHora));
Util.ExecuteNonQuery(sb.ToString());
}
protected void btSalvar_Click(object sender, EventArgs e)
{
divLista.Visible = true;
divForm.Visible = false;
RegimeModel rm = new RegimeModel();
rm.IDRegimeHora = txtCodigo.Text;
rm.DSRegimeHora = txtDescricao.Text;
rm.TotalHoraSemana = txtTotalHoraSemana.Text;
rm.TotalHoraDia = txtTotalHoraDia.Text;
rm.TotalMaximoHoraExtraDia = txtTotalMaxHoraDia.Text;
rm.TotalMaximoHoraExtraMes = txtTotalMaxHoraMes.Text;
rm.TotalHorasFolgaPlantonista = txtTotalHorasFolga.Text;
if (cbxRegime.Checked)
{
rm.RegimePlantonista = "1";
}
else
{
rm.RegimePlantonista = "0";
}
if (cbxHorasExtra.Checked)
{
rm.PermitehoraExtra = "1";
}
else
{
rm.PermitehoraExtra = "0";
}
if (string.IsNullOrEmpty(txtCodigo.Text))
{
rhd.Salvar(rm);
LimparControles();
GetDados();
}
else
{
rhd.Alterar(rm);
LimparControles();
GetDados();
}
}
