private void BtnElimina_Click(object sender, System.EventArgs e)
{
try
{
Classi.ManStraordinaria.Richiesta _Richiesta = new TheSite.Classi.ManStraordinaria.Richiesta();
int i_RowsAffected = 0;
S_ControlsCollection _SColl = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_id = new S_Object();
s_p_id.ParameterName = "p_Wr_Id";
s_p_id.DbType = CustomDBType.Integer;
s_p_id.Direction = ParameterDirection.Input;
s_p_id.Index = 0;
s_p_id.Value = wr_id;
_SColl.Add(s_p_id);
i_RowsAffected = _Richiesta.DeleteRdL(_SColl);
if (i_RowsAffected == -1)
{
Server.Transfer("SfogliaRdlEliminare.aspx");
}
}
catch (Exception ex)
{
string s_Err = ex.Message.ToString().ToUpper();
PanelMess.ShowError(s_Err, true);
}
}
private void BindingData()
{
if (Request.Params["ItemId"] == null)
{
return;
}
itemId = Int32.Parse(Request.Params["ItemId"]);
txtWrHidden.Text = itemId.ToString();
PageTitle1.Title = "Inserimento Richiesta di Lavoro N° " + itemId.ToString();
lblRdl.Text = string.Format("RDL n° {0} del {1}", itemId, DateTime.Now.ToShortDateString());
Classi.ManStraordinaria.Richiesta _Richiesta = new TheSite.Classi.ManStraordinaria.Richiesta();
DataSet ds = _Richiesta.GetRapportino(this.itemId);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
if (dr["ordine_lavoro"] != DBNull.Value)
{
this.Ordine = dr["ordine_lavoro"].ToString();
}
if (dr["datainizio"] != DBNull.Value)
{
this.DataIni = Convert.ToDateTime(dr["datainizio"]).ToShortDateString();
}
if (dr["datafine"] != DBNull.Value)
{
this.DataEnd = Convert.ToDateTime(dr["datafine"]).ToShortDateString();
}
if (dr["bl_id"] != DBNull.Value)
{
this.Bl_id = dr["bl_id"].ToString();
}
if (dr["comune"] != DBNull.Value)
{
this.Comune = dr["comune"].ToString();
}
if (dr["indirizzo"] != DBNull.Value)
{
this.Indirizzo = dr["indirizzo"].ToString();
}
if (dr["descrizione_ditta"] != DBNull.Value)
{
this.Ditta = dr["descrizione_ditta"].ToString();
}
if (dr["nome_edificio"] != DBNull.Value)
{
this.NomeEdificio = dr["nome_edificio"].ToString();
}
if (dr["spesa_presunta"] != DBNull.Value)
{
this.SpesaPresunta = Double.Parse(dr["spesa_presunta"].ToString()).ToString("C");
}
if (dr["descrizione_intervento"] != DBNull.Value)
{
this.DescrizioneIntervento = dr["descrizione_intervento"].ToString();
}
}
}
private void DeleteItem(string id)
{
Console.WriteLine(id);
if (id == "")
{
return;
}
S_ControlsCollection _SColl = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_wr_id = new S_Object();
s_p_wr_id.ParameterName = "p_Wr_Id";
s_p_wr_id.DbType = CustomDBType.Integer;
s_p_wr_id.Direction = ParameterDirection.Input;
s_p_wr_id.Index = 0;
s_p_wr_id.Value = int.Parse(id);
_SColl.Add(s_p_wr_id);
try
{
TheSite.Classi.ManStraordinaria.Richiesta _RichiestaElimina = new TheSite.Classi.ManStraordinaria.Richiesta();
_RichiestaElimina.DeleteRdL(_SColl);
// DataGridRicerca.CurrentPageIndex =0;
DataGridRicerca2.CurrentPageIndex = 0;
Ricerca(true);
// TheSite.Classi.AnagrafeImpianti.DatiApparecchiatura _DatiApparecchiatura = new TheSite.Classi.AnagrafeImpianti.DatiApparecchiatura(Context.User.Identity.Name);
// DataSet Ds=_DatiApparecchiatura.GetApparecchiatura(int.Parse(id));
// if (Ds.Tables[0].Rows.Count>0)
// deleteFile(Ds.Tables[0].Rows[0]);
//
// _DatiApparecchiatura.Delete(_SColl, 0);
// DataGrid1.CurrentPageIndex=0;
// Ricerca();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
this.Page.RegisterStartupScript("messaggio", "<script language'javascript'>alert(\"Impossibile cancellare l'apparecchiatura perchè è utilizzata in altre tabelle\");</script>");
}
}
// Nuova
private int GetRdlDaEliminareCount()
{
Classi.ManStraordinaria.Richiesta _Richiesta = new TheSite.Classi.ManStraordinaria.Richiesta();
S_ControlsCollection _SCollection = new S_ControlsCollection();
S_Controls.Collections.S_Object s_p_Bl_Id = new S_Controls.Collections.S_Object();
s_p_Bl_Id.ParameterName = "p_Bl_Id";
s_p_Bl_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Bl_Id.Direction = ParameterDirection.Input;
s_p_Bl_Id.Size = 50;
s_p_Bl_Id.Index = 0;
s_p_Bl_Id.Value = RicercaModulo1.TxtCodice.Text;
_SCollection.Add(s_p_Bl_Id);
S_Controls.Collections.S_Object s_p_campus = new S_Controls.Collections.S_Object();
s_p_campus.ParameterName = "p_campus";
s_p_campus.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_campus.Direction = ParameterDirection.Input;
s_p_campus.Index = 1;
s_p_campus.Size = 50;
s_p_campus.Value = RicercaModulo1.TxtRicerca.Text;
_SCollection.Add(s_p_campus);
S_Controls.Collections.S_Object s_p_Wr_Id = new S_Controls.Collections.S_Object();
s_p_Wr_Id.ParameterName = "p_Wr_Id";
s_p_Wr_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Wr_Id.Direction = ParameterDirection.Input;
s_p_Wr_Id.Index = 2;
s_p_Wr_Id.Size = 50;
s_p_Wr_Id.Value = (this.txtsRichiesta.Text == "")?0:Int32.Parse(this.txtsRichiesta.Text);
_SCollection.Add(s_p_Wr_Id);
S_Controls.Collections.S_Object s_p_Addetto = new S_Controls.Collections.S_Object();
s_p_Addetto.ParameterName = "p_Addetto";
s_p_Addetto.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Addetto.Direction = ParameterDirection.Input;
s_p_Addetto.Index = 3;
s_p_Addetto.Size = 50;
s_p_Addetto.Value = this.Addetti1.NomeCompleto;
_SCollection.Add(s_p_Addetto);
S_Controls.Collections.S_Object s_p_DataDa = new S_Controls.Collections.S_Object();
s_p_DataDa.ParameterName = "p_DataDa";
s_p_DataDa.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataDa.Direction = ParameterDirection.Input;
s_p_DataDa.Index = 4;
s_p_DataDa.Size = 10;
s_p_DataDa.Value = (CalendarPicker1.Datazione.Text == "")? "":CalendarPicker1.Datazione.Text;
_SCollection.Add(s_p_DataDa);
S_Controls.Collections.S_Object s_p_DataA = new S_Controls.Collections.S_Object();
s_p_DataA.ParameterName = "p_DataA";
s_p_DataA.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_DataA.Direction = ParameterDirection.Input;
s_p_DataA.Index = 5;
s_p_DataA.Size = 10;
s_p_DataA.Value = (CalendarPicker2.Datazione.Text == "")? "":CalendarPicker2.Datazione.Text;
_SCollection.Add(s_p_DataA);
S_Controls.Collections.S_Object s_p_Wo_Id = new S_Controls.Collections.S_Object();
s_p_Wo_Id.ParameterName = "p_Wo_Id";
s_p_Wo_Id.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Wo_Id.Direction = ParameterDirection.Input;
s_p_Wo_Id.Index = 6;
s_p_Wo_Id.Size = 50;
s_p_Wo_Id.Value = (this.txtsOrdine.Text == "")?0:Int32.Parse(this.txtsOrdine.Text);
_SCollection.Add(s_p_Wo_Id);
S_Controls.Collections.S_Object s_p_Servizio = new S_Controls.Collections.S_Object();
s_p_Servizio.ParameterName = "p_ID_Servizio";
s_p_Servizio.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Servizio.Direction = ParameterDirection.Input;
s_p_Servizio.Index = 7;
s_p_Servizio.Value = (cmbsServizio.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsServizio.SelectedValue);
_SCollection.Add(s_p_Servizio);
S_Controls.Collections.S_Object s_p_Status = new S_Controls.Collections.S_Object();
s_p_Status.ParameterName = "p_Status";
s_p_Status.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Status.Direction = ParameterDirection.Input;
s_p_Status.Index = 8;
s_p_Status.Value = (cmbsStatus.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsStatus.SelectedValue);
_SCollection.Add(s_p_Status);
S_Controls.Collections.S_Object s_p_Richiedente = new S_Controls.Collections.S_Object();
s_p_Richiedente.ParameterName = "p_Richiedente";
s_p_Richiedente.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Richiedente.Direction = ParameterDirection.Input;
s_p_Richiedente.Index = 9;
s_p_Richiedente.Size = 50;
s_p_Richiedente.Value = this.Richiedenti1.NomeCompleto;
_SCollection.Add(s_p_Richiedente);
S_Controls.Collections.S_Object s_p_Priority = new S_Controls.Collections.S_Object();
s_p_Priority.ParameterName = "p_Priority";
s_p_Priority.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Priority.Direction = ParameterDirection.Input;
s_p_Priority.Index = 10;
s_p_Priority.Value = (cmbsUrgenza.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsUrgenza.SelectedValue);
_SCollection.Add(s_p_Priority);
S_Controls.Collections.S_Object s_p_Descrizione = new S_Controls.Collections.S_Object();
s_p_Descrizione.ParameterName = "p_Descrizione";
s_p_Descrizione.DbType = ApplicationDataLayer.DBType.CustomDBType.VarChar;
s_p_Descrizione.Direction = ParameterDirection.Input;
s_p_Descrizione.Index = 11;
s_p_Descrizione.Size = 255;
s_p_Descrizione.Value = txtDescrizione.Text;
_SCollection.Add(s_p_Descrizione);
S_Controls.Collections.S_Object s_p_Gruppo = new S_Controls.Collections.S_Object();
s_p_Gruppo.ParameterName = "p_Gruppo";
s_p_Gruppo.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
s_p_Gruppo.Direction = ParameterDirection.Input;
s_p_Gruppo.Index = 12;
s_p_Gruppo.Value = (cmbsGruppo.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsGruppo.SelectedValue);
_SCollection.Add(s_p_Gruppo);
S_Controls.Collections.S_Object p_tipointerventoater = new S_Controls.Collections.S_Object();
p_tipointerventoater.ParameterName = "p_tipointerventoater";
p_tipointerventoater.DbType = CustomDBType.Integer;
p_tipointerventoater.Direction = ParameterDirection.Input;
p_tipointerventoater.Index = 13;
p_tipointerventoater.Value = (cmbsTipoIntervento.SelectedValue == string.Empty)? 0:Int32.Parse(cmbsTipoIntervento.SelectedValue);
_SCollection.Add(p_tipointerventoater);
S_Controls.Collections.S_Object p_datainizio = new S_Controls.Collections.S_Object();
p_datainizio.ParameterName = "p_datainizio";
p_datainizio.DbType = CustomDBType.VarChar;
p_datainizio.Direction = ParameterDirection.Input;
p_datainizio.Index = 14;
p_datainizio.Size = 10;
p_datainizio.Value = (CalendarPicker3.Datazione.Text == "")? "":CalendarPicker3.Datazione.Text;
_SCollection.Add(p_datainizio);
S_Controls.Collections.S_Object p_datafine = new S_Controls.Collections.S_Object();
p_datafine.ParameterName = "p_datafine";
p_datafine.DbType = CustomDBType.VarChar;
p_datafine.Direction = ParameterDirection.Input;
p_datafine.Index = 15;
p_datafine.Size = 10;
p_datafine.Value = (CalendarPicker4.Datazione.Text == "")? "":CalendarPicker4.Datazione.Text;
_SCollection.Add(p_datafine);
DataSet _MyDs = _Richiesta.GetSfogliaRDLDaEliminareCount(_SCollection).Copy();
return(int.Parse(_MyDs.Tables[0].Rows[0][0].ToString()));
}
