protected void btnAtualizar_Click(object sender, ImageClickEventArgs e)
{
string cPIS;
string cNome;
int nCodigo;
string cSenha;
string cBarras;
int nRFID;
int priv;
bool lOK;
int id = Convert.ToInt32(((sender as ImageButton).Parent as GridViewDataItemTemplateContainer).KeyValue);
TBPontoEletronicoModel pontoEletronico = new TBPontoEletronicoModel();
pontoEletronico = pontoEletronicoSrv.GetPontoEletronicoByID(id);
try
{
int ok = 0;
int erro = 0;
if (conexao(true, pontoEletronico))
{
List <TBUsuarioInfo> usuarios = pontoEletronicoSrv.GetUsuariosImportacao(id, Session["IDEmpresa"].ToString());
foreach (var usuario in usuarios)
{
cPIS = usuario.PIS_GERADO;
cNome = usuario.DSUsuario;
nCodigo = 0;
cSenha = string.Empty;
cBarras = string.Empty;
nRFID = 0;
priv = 0;
_rep.GravarUsuario(Convert.ToInt64(cPIS), cNome, nCodigo, cSenha, cBarras, nRFID, priv, out lOK);
string log;
if (!_rep.GetLastLog(out log))
{
erro++;
log = "";
}
else
{
ok++;
}
}
}
_rep.Desconectar();
this.Page.RegisterStartupScript("MSG", @"<script language='javascript'> alert('" + ok + ": atualizados, " + erro + ": não atualizados.');</script>");
}
catch (Exception ex)
{
this.Page.RegisterStartupScript("MSG", @"<script language='javascript'> alert('Erro ao atualizar Coloaboradores');</script>");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
DataRow row;
int nTotal = 0;
for (int i = 0; i < tbUsuarios.Rows.Count; i++)
{
row = tbUsuarios.Rows[i];
if (row.RowState == DataRowState.Deleted || row.RowState == DataRowState.Modified || row.RowState == DataRowState.Added)
{
nTotal++;
}
}
if (nTotal == 0)
{
return;
}
frmMain m = (frmMain)this.Owner;
stProgress.Value = 0;
stProgress.Maximum = nTotal;
stProgress.Visible = true;
nTotal = 0;
bool lOK;
RepCid _rep = m.REP;
string cPIS;
string cNome;
int nCodigo;
string cSenha;
string cBarras;
int nRFID;
int priv;
for (int i = 0; i < tbUsuarios.Rows.Count; i++)
{
row = tbUsuarios.Rows[i];
if (row.RowState == DataRowState.Modified || row.RowState == DataRowState.Added)
{
stInfo.Text = "Gravando PIS: " + row["PIS"].ToString();
stProgress.Value = ++nTotal;
cPIS = row["PIS"].ToString();
cNome = (string)row["Nome"];
if (cPIS == "" || cNome == "")
{
row.Delete();
i--;
continue;
}
if (row["Codigo"] != DBNull.Value)
{
nCodigo = Convert.ToInt32(row["Codigo"]);
}
else
{
nCodigo = 0;
}
if (row["Senha"] != DBNull.Value)
{
cSenha = row["Senha"].ToString();
}
else
{
cSenha = "";
}
if (row["Barras"] != DBNull.Value)
{
cBarras = row["Barras"].ToString();
}
else
{
cBarras = "";
}
if (row["rfID"] != DBNull.Value)
{
nRFID = Convert.ToInt32(row["rfID"]);
}
else
{
nRFID = 0;
}
if (row["PRIV"] != DBNull.Value)
{
priv = Convert.ToByte(row["PRIV"]);
}
else
{
priv = 0;
}
_rep.GravarUsuario(Convert.ToInt64(cPIS), cNome, nCodigo, cSenha, cBarras, nRFID, priv, out lOK);
string log;
if (!_rep.GetLastLog(out log))
{
log = "";
}
stInfo.Text += " OK " + log;
row.AcceptChanges();
Application.DoEvents();
}
else if (row.RowState == DataRowState.Deleted)
{
row.RejectChanges();
if (_rep.RemoverUsuario(Convert.ToInt64(row["PIS"]), out lOK))
{
stProgress.Value = ++nTotal;
string log;
if (!_rep.GetLastLog(out log))
{
log = "";
}
stInfo.Text += " REMOVIDO " + log;
row.Delete();
row.AcceptChanges();
i--;
}
}
}
_rep.Desconectar();
stInfo.Text = "Atualizado " + nTotal + " usuário" + (nTotal > 0 ? "s" : "");
if (nTotal < stProgress.Maximum)
{
stInfo.Text += " Erros: " + (stProgress.Maximum - nTotal);
}
else
{
stProgress.Visible = false;
}
}
