public bool Insert(Option Option, Database db, DbTransaction transaction)
{
DbCommand command = db.GetStoredProcCommand("usp_OptionInsert");
db.AddInParameter(command, "Name", DbType.String, Option.Name);
db.AddInParameter(command, "Description", DbType.String, Option.Description);
db.AddInParameter(command, "OptionCategoryId", DbType.Int16, Option.OptionCategoryId);
db.AddInParameter(command, "ParentOptionId", DbType.Int16, Option.ParentOptionId);
db.AddInParameter(command, "IsDeleted", DbType.Boolean, Option.IsDeleted);
db.AddInParameter(command, "IsMultiSelect", DbType.Boolean, Option.IsMultiSelect);
db.AddInParameter(command, "Points", DbType.Int16, Option.Points);
db.AddOutParameter(command, "OptionId", DbType.Int16, 3);
if (transaction == null)
{
db.ExecuteNonQuery(command);
}
else
{
db.ExecuteNonQuery(command, transaction);
}
Option.OptionId = Convert.ToInt16(db.GetParameterValue(command, "OptionId").ToString());
return true;
}
public bool Delete(Option Option, Database db, DbTransaction transaction)
{
DbCommand command = db.GetStoredProcCommand("usp_OptionDelete");
db.AddInParameter(command, "OptionId", DbType.Int16, Option.OptionId);
db.AddInParameter(command, "IsDeleted", DbType.Boolean, Option.IsDeleted);
if (transaction == null)
{
db.ExecuteNonQuery(command);
}
else
{
db.ExecuteNonQuery(command, transaction);
}
return true;
}
public bool Update(Option Option)
{
Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING);
return this.Update(Option, db, null);
}
protected void gvFeatureList_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxGridView gridView = sender as ASPxGridView;
Option option = new Option();
option.OptionId = Convert.ToInt16(e.Keys[gvFeatureList.KeyFieldName]); //e.NewValues["OptionId"].ToString().Trim());
option.Name = e.NewValues["Name"].ToString().Trim();
option.Description = e.NewValues["Description"].ToString().Trim();
option.OptionCategoryId = Convert.ToInt16(e.NewValues["OptionCategoryId"].ToString().Trim());
option.Points = Convert.ToInt16(e.NewValues["Points"].ToString().Trim());
// option.IsMultiSelect = Convert.ToBoolean(e.NewValues["IsMultiSelect"]); //Convert.ToBoolean(e.NewValues["IsMultiSelect"].ToString().Trim());
option.CreatedBy = (Guid)Membership.GetUser().ProviderUserKey; //SessionManager.GetSession<User>(Constants.SESSION_LOGGED_USER).UserId.Value;
option.UpdatedBy = (Guid)Membership.GetUser().ProviderUserKey; //SessionManager.GetSession<User>(Constants.SESSION_LOGGED_USER).UserId.Value;
gridView.CancelEdit();
e.Cancel = true;
if (option.Save())
{
//Show Success message
}
else
{
//Error message
}
Session[Constants.SESSION_FEATURE_LIST] = new OptionDAO().SelectAllDataset();
LoadGrid();
}
protected void gvFeatureList_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
Option option = new Option();
int i = gvFeatureList.FindVisibleIndexByKeyValue(e.Keys[gvFeatureList.KeyFieldName]);
e.Cancel = true;
option.OptionId = Convert.ToInt16(e.Keys[gvFeatureList.KeyFieldName]);
option.UpdatedBy = (Guid)Membership.GetUser().ProviderUserKey; //SessionManager.GetSession<User>(Constants.SESSION_LOGGED_USER).UserId.Value;
option.IsDeleted = true;
if (new OptionDAO().Delete(option))
{
//Show Success message
}
else
{
//Error message
}
Session[Constants.SESSION_FEATURE_LIST] = new OptionDAO().SelectAllDataset();
LoadGrid();
}
