public void UpdateCommand(object source, DataGridCommandEventArgs e, string[] ControlParamName, string ControlForIdName, string StoredProcedure, App_Code.Businnes.DataManager dataManager)
{
// int id = int.Parse(Dt.DataKeys[(int)e.Item.ItemIndex].ToString());
// int Result =0;
// Object controllo;
//
//
// S_ControlsCollection param=new S_ControlsCollection();
//
// try
// {
// if (e.CommandName=="Update")
// {
// foreach (string par in ControlParamName)
// {
// controllo = ((Object) e.Item.FindControl(par));
// if (controllo is S_Controls.S_TextBox)
// param.Add((S_TextBox)controllo);
// else if (controllo is S_Controls.S_ListBox)
// param.Add((S_ListBox)controllo);
// else if (controllo is S_Controls.S_ComboBox)
// param.Add((S_ComboBox)controllo);
// }
//
// SqlParameter para;
//
// para=new SqlParameter(ControlForIdName,SqlDbType.Int);
// para.Direction=ParameterDirection.Input;
// para.Value=id;
// param.Add (para);
//
//
// Result = dataManager.UpdateData(param);
//
//
// if (Result > 0)
// {
// this.Dt.EditItemIndex = -1;
// this.SetColums();
// }
// else
// {
// throw new ApplicationException("la stored procedure ha restituito valore 0");
// }
// }
// }
// catch(SqlException ex)
// {
// throw (ex);//Scateno nuovamente l'errore perchè è sconosciuto
// }
//
// finally
// {
// ;
// }
}
public void ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e, string[] ControlParamName, string ControlForIdName, string StoredProcedure, string command, App_Code.Businnes.DataManager dataManager)
{
switch (e.CommandName)
{
case "Delete":
int IdQuery = int.Parse(Dt.DataKeys[(int)e.Item.ItemIndex].ToString());
ApplicationDataLayer.OracleDataLayer _OraDl;
_OraDl = new OracleDataLayer(s_ConnStr);
S_ControlsCollection param = new S_ControlsCollection();
S_Object IdSchema;
IdSchema = new S_Object();
IdSchema.ParameterName = "pIdSchema";
IdSchema.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
IdSchema.Direction = ParameterDirection.Input;
IdSchema.Value = IdQuery;
IdSchema.Index = 0;
param.Add(IdSchema);
S_Object DirParam;
DirParam = new S_Object();
DirParam.ParameterName = "pId";
DirParam.DbType = ApplicationDataLayer.DBType.CustomDBType.Integer;
DirParam.Direction = ParameterDirection.Output;
DirParam.Value = DBNull.Value;
DirParam.Index = 1;
param.Add(DirParam);
_OraDl.ExecuteProcedure(param, "IL_PACK_INTERROGAZIONI.IL_SpDeleteSchema");
break;
default:
// Do nothing.
break;
}
}
public void ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e, string[] ControlParamName, string ControlForIdName, string StoredProcedure, string command, App_Code.Businnes.DataManager dataManager)
{
// switch(e.CommandName)
// {
// case "Delete":
// int id = int.Parse(Dt.DataKeys[(int)e.Item.ItemIndex].ToString());
//
// SqlDalCollectionParameter param=new SqlDalCollectionParameter();
//
// SqlParameter para;
// para=new SqlParameter(ControlForIdName,SqlDbType.Int);
// para.Direction=ParameterDirection.Input;
// para.Value=id;
// param.Add (para);
//
// dataManager.DeleteData(param);
// break;
//
// default:
// // Do nothing.
// break;
// }
}
public void UpdateCommand(object source, DataGridCommandEventArgs e, string[] ControlParamName, string ControlForIdName, string StoredProcedure, App_Code.Businnes.DataManager dataManager)
{
this.Dt.EditItemIndex = -1;
this.SetColums();
}
