/// <summary>
/// Daca pagina de administrare a fost deschisa din IstoricCentreCost cream functia care va face refresh la combo-ul cu centre de cost
/// </summary>
private void CreateRefreshFunction()
{
string outStr = "";
//cream scriptul care va contine functia de refresh
//ne bazam pe faptul ca se cunoaste numele selectului care contine centrele de cost
//initial se sterg toate intrarile din combo
outStr += "<script> \r\n function RefreshParentPage() \r\n" +
"{ \r\n" +
"window.opener.DeleteCentreCostCombo(); \r\n" +
" FillCentreCostCOmbo(); \r\n" +
"} \r\n";
outStr += " function FillCentreCostCOmbo() \r\n" +
"{ \r\n";
//acum se creeaza functie care adauga centrele de cost din recordset
//se foloseste o functie din parent page... FillCentruCostCombo
Salaries.Business.AdminCentreCost objAdminCentreCost = new Salaries.Business.AdminCentreCost();
foreach (DataRow dataRow in objAdminCentreCost.LoadInfoCentreCost().Tables[0].Rows)
{
outStr += "window.opener.FillCentruCostCombo('" +
dataRow["Cod"].ToString() + " - " + dataRow["Nume"].ToString() + "'," +
dataRow["CentruCostID"].ToString() + ");";
}
outStr += "} \r\n" +
"</script>";
Response.Write(outStr);
}
/// <summary>
/// Sterge un centru de cost
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDelete_Click(object sender, System.EventArgs e)
{
try
{
int centruCostId = Convert.ToInt32(txtCentruCostID.Text);
Salaries.Business.AdminCentreCost centruCost = new Salaries.Business.AdminCentreCost();
centruCost.CentruCostId = centruCostId;
int sePoateSterge = centruCost.CheckIfCentruCostCanBeDeleted();
if (sePoateSterge == 0)
{
centruCost.DeleteCentruCost();
//ListareCentreCost();
CompletareTitlu();
PopulareTabela();
}
if (sePoateSterge == 1)
{
Response.Write("<script> alert('Centrul de cost nu poate fi sters! Este inca asociat unor angajati!'); </script>");
}
if (sePoateSterge == 2)
{
Response.Write("<script> alert('Operatiunea nu a fost efectuata deoarece nomenclatoul trebuie sa contina cel putin un centru de cost.'); </script>");
}
//Daca pagina de administrare a fost deschisa din alta pagina cream functia care va face refresh la combo-ul cu centre de cost
CreateRefreshFunction();
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
/// <summary>
/// Modifica datele unui centru de cost
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnModify_Click(object sender, System.EventArgs e)
{
try
{
int centruCostId = Convert.ToInt32(txtCentruCostID.Text);
Salaries.Business.AdminCentreCost objCentruCost = new Salaries.Business.AdminCentreCost();
objCentruCost.CentruCostId = centruCostId;
objCentruCost.Nume = txtDenumire.Text;
objCentruCost.Cod = txtCod.Text;
objCentruCost.Descriere = txtDescriere.Text;
if (objCentruCost.CheckIfCentruCostCanBeAdded())
{
objCentruCost.UpdateCentruCost();
//Daca pagina de administrare a fost deschisa din alta pagina cream functia care va face refresh la combo-ul cu centre de cost
CreateRefreshFunction();
}
else
{
Response.Write("<script> alert('Mai exista un centru de cost cu acest cod!'); </script>");
}
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
//ListareCentreCost();
CompletareTitlu();
PopulareTabela();
}
/// <summary>
/// Se incarca datele unui centru de cost
/// </summary>
private void FillEditForm()
{
try
{
int centruCostId = Convert.ToInt32(txtCentruCostID.Text);
Salaries.Business.AdminCentreCost infoCentruCost = new Salaries.Business.AdminCentreCost();
infoCentruCost.CentruCostId = centruCostId;
DataRow rowCentruCost = infoCentruCost.GetCentruCostInfo().Tables[0].Rows[0];
txtCod.Text = rowCentruCost["Cod"].ToString();
txtDenumire.Text = rowCentruCost["Nume"].ToString();
txtDescriere.Text = rowCentruCost["Descriere"].ToString();
txtCentruCostID.Text = centruCostId.ToString();
td_addLine.Visible = false;
listDataGrid.Visible = false;
td_editLine.Visible = true;
add_form.Style.Add("display", "");
add_buttonLine.Visible = false;
tdTitle.InnerText = "Editare centru de cost";
//Daca pagina de administrare a fost deschisa din alta pagina cream functia care va face refresh la combo-ul cu centre de cost
//In acest caz va fi goala ...
CreateEmptyRefreshFunction();
}
catch (Exception ex)
{
litError.Text = "The following error occurred: <br>";
litError.Text += ex.Message;
}
}
/// <summary>
/// Populeaza lista cu tari
/// </summary>
public void PopulareTabela()
{
Index = listDataGrid.CurrentPageIndex * 30 + 1;
Salaries.Business.AdminCentreCost objAdminCentreCost = new Salaries.Business.AdminCentreCost();
listDataGrid.DataSource = objAdminCentreCost.LoadInfoCentreCost();
listDataGrid.DataBind();
}
/// <summary>
/// Creaza ComboBox cu centre de cost
/// </summary>
/// <param name="listObj">Lista cu centre de cost</param>
/// <remarks>
/// Oprescu Claudia
/// </remarks>
public void CreateCentruCostSelectBox(DropDownList listObj)
{
Salaries.Business.AdminCentreCost centre = new Salaries.Business.AdminCentreCost();
DataSet ds = centre.LoadInfoCentreCost();
DataTable myTable = new DataTable();
myTable = ds.Tables[0];
for (int i = 0; i < myTable.Rows.Count; i++)
{
DataRow myRow = myTable.Rows[i];
ListItem myItem = new ListItem(myRow["cod"].ToString() + " - " + myRow["nume"].ToString(), myRow["centrucostid"].ToString());
listObj.Items.Add(myItem);
}
}
/// <summary>
/// Se trece la urmatoarea pagina in lista
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void listDataGrid_PageIndexChanged(Object sender, DataGridPageChangedEventArgs e)
{
Salaries.Business.AdminCentreCost objAdminCentreCost = new Salaries.Business.AdminCentreCost();
DataSet dt = objAdminCentreCost.LoadInfoCentreCost();
CompletareTitlu();
listDataGrid.CurrentPageIndex = e.NewPageIndex;
DataView dv = dt.Tables[0].DefaultView;
listDataGrid.DataSource = dv;
Index = (e.NewPageIndex * listDataGrid.PageSize) + 1;
listDataGrid.DataBind();
}