public ValidationResult ManipulateMenuOperation(SEC_MenuOperation menuOperation, string action, out string status)
{
_menuOprtDataService.ManipulateMenuOperation(menuOperation, action, out status);
return(status.Length > 0
? new ValidationResult(status, _localizationService.GetResource(status))
: ValidationResult.Success);
}
public string ManipulateMenuOperation(SEC_MenuOperation menuOpteration, string action, out string errorNumber)
{
errorNumber = string.Empty;
try
{
var factory = new DatabaseProviderFactory();
var db = factory.CreateDefault() as SqlDatabase;
using (var dbCommandWrapper = db.GetStoredProcCommand("SetMenuOperation"))
{
// Set parameters
db.AddInParameter(dbCommandWrapper, "@MenuOperationID", SqlDbType.NVarChar, menuOpteration.MenuOperationID.Trim());
db.AddInParameter(dbCommandWrapper, "@MenuOperationTitle", SqlDbType.NVarChar, menuOpteration.MenuOperationTitle.Trim());
db.AddInParameter(dbCommandWrapper, "@DefaultValue", SqlDbType.Bit, menuOpteration.DefaultValue);
db.AddInParameter(dbCommandWrapper, "@MenuOperationSL", SqlDbType.NVarChar, menuOpteration.MenuOperationSL.Trim());
db.AddInParameter(dbCommandWrapper, "@OwnerID", SqlDbType.NVarChar, menuOpteration.OwnerID);
db.AddInParameter(dbCommandWrapper, "@UserLevel", SqlDbType.Int, menuOpteration.UserLevel);
db.AddInParameter(dbCommandWrapper, "@SetBy ", SqlDbType.NVarChar, menuOpteration.SetBy);
db.AddInParameter(dbCommandWrapper, "@ModifiedBy", SqlDbType.NVarChar, menuOpteration.ModifiedBy);
db.AddInParameter(dbCommandWrapper, "@Status", SqlDbType.Int, menuOpteration.Status);
db.AddInParameter(dbCommandWrapper, "@Action", SqlDbType.VarChar, action);
db.AddOutParameter(dbCommandWrapper, spStatusParam, SqlDbType.VarChar, 10);
// Execute SP.
db.ExecuteNonQuery(dbCommandWrapper);
// Getting output parameters and setting response details.
if (!db.GetParameterValue(dbCommandWrapper, spStatusParam).IsNullOrZero())
{
// Get the error number, if error occurred.
errorNumber = db.GetParameterValue(dbCommandWrapper, spStatusParam).PrefixErrorCode();
}
}
}
catch (Exception ex)
{
errorNumber = "E404"; // Log ex.Message Insert Log Table
}
return(errorNumber);
}
