private DataTable GetDataForDataCommand(string dataCommand, List <ScreenDataCommandParameter> parameters)
{
DataTable retVal = null;
if (Connection == null)
{
retVal = sql.GetDataForDataCommand(dataCommand, parameters);
}
else
{
DataCommand command = DataCommand.GetDataCommand(dataCommand);
if (command == null)
{
throw new Exception(String.Format("DataCommand {0} could not be found in configuration", dataCommand));
}
retVal = sql.GetData(null, Connection, command, parameters, command.Text);
}
return(retVal);
}
private DataTable GetData(System.Data.Common.DbTransaction tran,
string CommandName,
string WorkflowCode,
string FromWorkflowStepCode,
string ToWorkflowStepCode,
string EntityID,
string Comment,
string UserName,
string WorkflowCodeParameter,
string FromWorkflowStepCodeParameter,
string ToWorkflowStepCodeParameter,
string EntityIDParameter,
string CommentParameter,
string UsernameParameter
)
{
DataCommandService dataCommandDB = DataCommandService.GetInstance();
List <ScreenDataCommandParameter> parameters = new List <ScreenDataCommandParameter>();
ScreenDataCommandParameter parameter = null;
DataCommand command = DataCommand.GetDataCommand(CommandName);
if (command == null)
{
throw new ApplicationException(String.Format("DataCommand {0} could not be found in configuration", CommandName));
}
if (!String.IsNullOrEmpty(WorkflowCodeParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = WorkflowCodeParameter;
parameter.Value = WorkflowCode;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(FromWorkflowStepCodeParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = FromWorkflowStepCodeParameter;
parameter.Value = FromWorkflowStepCode;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(ToWorkflowStepCodeParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = ToWorkflowStepCodeParameter;
parameter.Value = ToWorkflowStepCode;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(EntityIDParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = EntityIDParameter;
parameter.Value = EntityID;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(CommentParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = CommentParameter;
parameter.Value = Comment;
parameters.Add(parameter);
}
if (!String.IsNullOrEmpty(UsernameParameter))
{
parameter = new ScreenDataCommandParameter();
parameter.Name = UsernameParameter;
parameter.Value = UserName;
parameters.Add(parameter);
}
//execute command with transaction
// CommandType type = (command.Type == DataCommandCommandType.StoredProcedure) ? CommandType.StoredProcedure : CommandType.Text;
DataTable data = dataCommandDB.GetData(tran, command, parameters, command.Text);
return(data);
}
public static void GenerateCultureTrackingCookie()
{
App app = CodeTorch.Core.Configuration.GetInstance().App;
if (app.EnableLocalization)
{
//get localization data command for retrieval
DataCommandService dataCommandDB = DataCommandService.GetInstance();
if (!String.IsNullOrEmpty(app.LocalizationCommand))
{
DataCommand command = DataCommand.GetDataCommand(app.LocalizationCommand);
if (command == null)
{
throw new ApplicationException(String.Format("DataCommand {0} could not be found in configuration - Common.GenerateCultureTrackingCookie", app.LocalizationCommand));
}
//set any parameters needed
List <ScreenDataCommandParameter> parameters = new List <ScreenDataCommandParameter>();
ScreenDataCommandParameter parameter = null;
if (!String.IsNullOrEmpty(app.LocalizationUserNameParameter))
{
parameter = new ScreenDataCommandParameter();
if (app.LocalizationUserNameParameter.StartsWith("@"))
{
parameter.Name = app.LocalizationUserNameParameter;
}
else
{
parameter.Name = "@" + app.LocalizationUserNameParameter;
}
parameter.Value = Common.UserName;
parameters.Add(parameter);
}
//execute command
DataTable retVal = dataCommandDB.GetData(null, command, parameters, command.Text);
string culture = "en-US";
//get data from culture field
if (retVal != null)
{
if (retVal.Rows.Count > 0)
{
if (retVal.Columns.Contains(app.LocalizationCultureField))
{
if (retVal.Rows[0][app.LocalizationCultureField] != DBNull.Value)
{
culture = retVal.Rows[0][app.LocalizationCultureField].ToString();
}
}
}
}
//generate culture cookie
HttpCookie c;
if (HttpContext.Current.Request.Cookies["CultureCode"] == null)
{
c = new HttpCookie("CultureCode");
}
else
{
c = HttpContext.Current.Request.Cookies["CultureCode"];
}
c.Value = culture;
c.Path = "/";
HttpContext.Current.Response.Cookies.Add(c);
}
}
}
