//Lungu Andreea - 20.09.2010
public string ImportFisierSincronizare(string fileName)
{
ErrHandler.MyErrHandler.WriteError("SincronizareDateAngajati.ascx - start - ImportFisierSincronizare() - " + fileName);
string marca = "", numePrenume = "", birou = "";
Salaries.Data.ImportFisier imp = new Salaries.Data.ImportFisier();
DataTable dt = imp.GetDataTableFromImport(fileName);
string mesajImport = "";
foreach (DataRow dr in dt.Rows)
{
#region preiau datele din row-ul respectiv
try
{
marca = dr["Marca"].ToString();
numePrenume = dr["Nume si Prenume"].ToString();
birou = dr["Birou"].ToString();
}
catch (Exception exc)
{
mesajImport += "Fisierul nu este in formatul corespunzator";
ErrHandler.MyErrHandler.WriteError("SincronizareDateAngajati.ascx - error - ImportFisierSincronizare() - 'Fisierul nu este in formatul corespunzator' ");
break;
}
#endregion
#region determin id-ul angajatului pe baza marcii
//determin id-ul angajatului pe baza marcii
Salaries.Business.Angajat ang = new Salaries.Business.Angajat();
ang.Marca = marca;
int idAngajat = ang.GetAngajatIDByMarca(marca);
ang.AngajatId = idAngajat;
ang.LoadAngajat();
// ang.LoadAngajat();
// bool esteLichidat = true;
// if ((ang.DataLichidare == DateTime.MinValue) || (ang.DataLichidare>dataStartLunaActiva))
// esteLichidat = false;
#endregion
//if ((idAngajat != -1) && (!esteLichidat))
if (idAngajat != -1)
{
ang.Birou = birou;
ang.UpdateAngajat();
}
else
{
if (!dr["Marca"].ToString().Equals(""))
{
mesajImport += "Nu exista angajatul cu marca " + dr["Marca"].ToString() + Environment.NewLine;
}
//ar trebui sa scriu intr-un fisier ca sa pot da un feedback
//if (esteLichidat)
// mesajImport += "Angajatul " + dr["Nume si Prenume"].ToString() + " este lichidat.";
}
}
ErrHandler.MyErrHandler.WriteError("SincronizareDateAngajati.ascx - end - ImportFisierSincronizare() - " + fileName);
if (mesajImport.Equals(""))
{
mesajImport = "Sincronizarea datelor a fost realizata.";
}
return(mesajImport);
}
/// <summary>
/// Salveaza datele unui angajat
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void butSaveAngajat_Click(object sender, System.EventArgs e)
{
try
{
DTaraHidden.Value = DTaraHidden.Value == "" ? lstDTara.SelectedValue : DTaraHidden.Value;
RTaraHidden.Value = RTaraHidden.Value == "" ? lstRTara.SelectedValue : RTaraHidden.Value;
TaraNastereHidden.Value = TaraNastereHidden.Value == "" ? lstTaraNastere.SelectedValue : TaraNastereHidden.Value;
DJudetSectorHidden.Value = DJudetSectorHidden.Value == "" ? lstDJudetSector.SelectedValue : DJudetSectorHidden.Value;
RJudetSectorHidden.Value = RJudetSectorHidden.Value == "" ? lstRJudetSector.SelectedValue : RJudetSectorHidden.Value;
JudetNastereHidden.Value = JudetNastereHidden.Value == "" ? lstJudetNastere.SelectedValue : JudetNastereHidden.Value;
lstDTara.SelectedValue = DTaraHidden.Value;
lstRTara.SelectedValue = RTaraHidden.Value;
lstTaraNastere.SelectedValue = TaraNastereHidden.Value;
BindLstDJudetDDL();
BindLstRJudetDDL();
BindLstJudetNastereDDL();
lstDJudetSector.SelectedValue = DJudetSectorHidden.Value;
lstRJudetSector.SelectedValue = RJudetSectorHidden.Value;
lstJudetNastere.SelectedValue = JudetNastereHidden.Value;
//Date personale
objAngajat.Nume = txtNume.Text;
objAngajat.Prenume = txtPrenume.Text;
objAngajat.NumeAnterior = txtNumeAnterior.Text;
objAngajat.DataSchimbariiNumelui = Utilities.ConvertText2DateTime(txtDataSchimbariiNumelui.Text);
objAngajat.StareCivila = Convert.ToByte(lstStareCivila.SelectedValue, 10);
objAngajat.NrCopii = Convert.ToByte(txtNrCopii.Text, 10);
objAngajat.Sex = lstSex.SelectedValue;
objAngajat.Nationalitate = int.Parse(lstNationalitate.SelectedValue);
objAngajat.TitluId = Convert.ToInt32(lstTitlu.SelectedValue, 10);
objAngajat.StudiuId = Convert.ToInt32(lstStudiu.SelectedValue, 10);
if (txtAnAbsolvire.Text != "")
{
objAngajat.AnAbsolvire = int.Parse(txtAnAbsolvire.Text);
}
objAngajat.NrDiploma = txtNrDiploma.Text;
objAngajat.Telefon = txtTelefon.Text;
objAngajat.Descriere = txtDescriere.Text;
if ((filePozaAngajat.PostedFile.FileName != "") || (filePozaAngajat.PostedFile.ContentLength != 0))
{
string contentFile = filePozaAngajat.PostedFile.ContentType.ToString();
if (contentFile.Substring(0, 5) == "image")
{
//Modificat: Oprescu Claudia
//Descriere: Se incearca copierea. Daca poza depaseste dimensiunea se arunca o exceptie
try
{
objAngajat.PozaAngajat = CopiazaPozaPeServer();
}
catch (Exception ex)
{
Response.Write("<script>alert('" + ex.Message + "');</script>");
}
}
else
{
Response.Write("<script>alert('Se pot salva numai fisiere de tip image (gif, jpg, jpeg...)!');</script>");
}
}
//Domiciliul - Resedinta
objAngajat.DTara = Convert.ToInt32(lstDTara.SelectedValue, 10);
objAngajat.DJudetSectorId = Convert.ToInt32(lstDJudetSector.SelectedValue, 10);
objAngajat.DLocalitate = txtDLocalitate.Text;
objAngajat.DStrada = txtDStrada.Text;
objAngajat.DNumar = txtDNumar.Text;
objAngajat.DCodPostal = long.Parse(txtDCodPostal.Text);
objAngajat.DScara = txtDScara.Text;
objAngajat.DBloc = txtDBloc.Text;
objAngajat.DEtaj = txtDEtaj.Text;
objAngajat.DApartament = txtDApartament.Text;
objAngajat.RTara = Convert.ToInt32(lstRTara.SelectedValue, 10);
objAngajat.RJudetSectorId = Convert.ToInt32(lstRJudetSector.SelectedValue, 10);
objAngajat.RLocalitate = txtRLocalitate.Text;
objAngajat.RApartament = txtRApartament.Text;
objAngajat.RBloc = txtRBloc.Text;
objAngajat.RCodPostal = long.Parse(txtRCodPostal.Text);
objAngajat.REtaj = txtREtaj.Text;
objAngajat.RNumar = txtRNumar.Text;
objAngajat.RScara = txtRScara.Text;
objAngajat.RStrada = txtRStrada.Text;
//Buletin pasaport
objAngajat.CNP = Convert.ToInt64(txtCNP.Text, 10);
objAngajat.DataNasterii = Utilities.ConvertText2DateTime(txtDataNasterii.Text);
objAngajat.TaraNastereId = Convert.ToInt32(lstTaraNastere.SelectedValue, 10);
objAngajat.JudetNastereId = Convert.ToInt32(lstJudetNastere.SelectedValue, 10);
objAngajat.LocalitateNastere = txtLocalitateNastere.Text;
objAngajat.PrenumeMama = txtPrenumeMama.Text;
objAngajat.PrenumeTata = txtPrenumeTata.Text;
objAngajat.CIDataEliberarii = Utilities.ConvertText2DateTime(txtCIDataEliberarii.Text);
objAngajat.CIEliberatDe = txtCIEliberatDe.Text;
objAngajat.CINumar = txtCINumar.Text;
objAngajat.CISerie = txtCISerie.Text;
if (txtCIValabilPanaLa.Text != "")
{
objAngajat.CIValabilPanaLa = Utilities.ConvertText2DateTime(txtCIValabilPanaLa.Text);
}
objAngajat.PASDataEliberarii = Utilities.ConvertText2DateTime(txtPASDataEliberarii.Text);
objAngajat.PASEliberatDe = txtPASEliberatDe.Text;
objAngajat.PASNumar = txtPASNumar.Text;
objAngajat.PASSerie = txtPASSerie.Text;
objAngajat.PASValabilPanaLa = Utilities.ConvertText2DateTime(txtPASValabilPanaLa.Text);
objAngajat.Invaliditate = short.Parse(chkLstInvalid.SelectedValue);
// added by Anca Holostencu:
// NIF nu poate avea valoarea NULL
objAngajat.NIF = "";
objAngajat.UpdateAngajat();
DTaraHidden.Value = "";
RTaraHidden.Value = "";
TaraNastereHidden.Value = "";
DJudetSectorHidden.Value = "";
RJudetSectorHidden.Value = "";
JudetNastereHidden.Value = "";
long idAng = objAngajat.AngajatId;
objAngajat = new Salaries.Business.Angajat();
objAngajat.AngajatId = idAng;
objAngajat.LoadAngajat();
CreateVarTipNationalitateDomiciliu(objAngajat);
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
