protected override void ShowData(int functionalityXFunctionalityImageid)
{
oDetailButtonPanel.SetId = SetId;
var data = new FunctionalityXFunctionalityImageDataModel();
data.FunctionalityXFunctionalityImageId = functionalityXFunctionalityImageid;
var items = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityImageDataManager.GetEntityDetails(data, SessionVariables.RequestProfile);
if (items.Count == 1)
{
var item = items[0];
lblFunctionalityXFunctionalityImageId.Text = item.FunctionalityXFunctionalityImageId.ToString();
lblFunctionalityId.Text = item.Functionality;
lblFunctionalityImageId.Text = item.FunctionalityImage;
lblKeyString.Text = item.KeyString;
lblTitle.Text = item.Title;
lblDescription.Text = item.Description.ToString();
lblSortOrder.Text = item.Functionality;
lblCreatedBy.Text = item.FunctionalityImage;
lblCreatedDate.Text = item.KeyString;
lblUpdatedBy.Text = item.Title;
lblUpdatedDate.Text = item.Description.ToString();
oUpdateInfo.LoadText(DateTime.Parse(item.UpdatedDate.ToString()), item.UpdatedBy.ToString(), item.LastAction);
oHistoryList.Setup(PrimaryEntity, functionalityXFunctionalityImageid, "FunctionalityXFunctionalityImage");
}
else
{
Clear();
}
}
private DataTable GetData()
{
var data = new FunctionalityXFunctionalityImageDataModel();
var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityImageDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
private static string CreateOrUpdate(FunctionalityXFunctionalityImageDataModel data, RequestProfile requestProfile, string action)
{
var sql = "EXEC ";
switch (action)
{
case "Create":
sql += "dbo.FunctionalityXFunctionalityImageInsert ";
break;
case "Update":
sql += "dbo.FunctionalityXFunctionalityImageUpdate ";
break;
default:
break;
}
sql = sql + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, FunctionalityXFunctionalityImageDataModel.DataColumns.FunctionalityXFunctionalityImageId, data.FunctionalityXFunctionalityImageId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, FunctionalityXFunctionalityImageDataModel.DataColumns.FunctionalityId, data.FunctionalityId) +
", " + ToSQLParameter(data, FunctionalityXFunctionalityImageDataModel.DataColumns.FunctionalityImageId, data.FunctionalityImageId) +
", " + ToSQLParameter(data, FunctionalityXFunctionalityImageDataModel.DataColumns.KeyString, data.KeyString) +
", " + ToSQLParameter(data, FunctionalityXFunctionalityImageDataModel.DataColumns.Title, data.Title) +
", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.Description, data.Description) +
", " + ToSQLParameter(data, StandardDataModel.StandardDataColumns.SortOrder, data.SortOrder) +
", " + ToSQLParameter(data, BaseDataModel.BaseDataColumns.CreatedDate, data.CreatedDate) +
", " + ToSQLParameter(data, FunctionalityXFunctionalityImageDataModel.DataColumns.CreatedBy, data.CreatedBy) +
", " + ToSQLParameter(data, BaseDataModel.BaseDataColumns.UpdatedDate, data.UpdatedDate) +
", " + ToSQLParameter(data, BaseDataModel.BaseDataColumns.UpdatedBy, data.UpdatedBy);
return(sql);
}
public static DataTable Search(FunctionalityXFunctionalityImageDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 0);
var table = list.ToDataTable();
return(table);
}
public static void Delete(FunctionalityXFunctionalityImageDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FunctionalityXFunctionalityImageDelete " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, FunctionalityXFunctionalityImageDataModel.DataColumns.FunctionalityXFunctionalityImageId, data.FunctionalityXFunctionalityImageId);
DBDML.RunSQL("FunctionalityXFunctionalityImage.Delete", sql, DataStoreKey);
}
protected DataTable GetAssociatedFunctionalityImageIds(int functionalityId)
{
var data = new FunctionalityXFunctionalityImageDataModel();
data.FunctionalityId = functionalityId;
var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityImageDataManager.GetByFunctionality(functionalityId, SessionVariables.RequestProfile);
return(dt);
}
public void LoadData(int functionalityXFunctionalityImageid, bool showId)
{
var data = new FunctionalityXFunctionalityImageDataModel();
data.FunctionalityXFunctionalityImageId = functionalityXFunctionalityImageid;
var items = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityImageDataManager.GetEntityDetails(data, SessionVariables.RequestProfile);
if (items.Count == 1)
{
var item = items[0];
if (!showId)
{
txtFunctionalityXFunctionalityImageId.Text = item.FunctionalityXFunctionalityImageId.ToString();
oHistoryList.Setup(PrimaryEntity, functionalityXFunctionalityImageid, PrimaryEntityKey);
}
else
{
txtFunctionalityXFunctionalityImageId.Text = String.Empty;
}
txtFunctionalityId.Text = item.FunctionalityId.ToString();
txtFunctionalityImageId.Text = item.FunctionalityImageId.ToString();
txtKeyString.Text = item.KeyString.ToString();
txtTitle.Text = item.Title.ToString();
txtDescription.Text = item.Description;
txtCreatedDate.Text = DateTime.ParseExact(item.CreatedDate.ToString(), "yyyyMMdd", DateTimeFormatInfo.InvariantInfo).ToString(SessionVariables.UserDateFormat);
txtUpdatedDate.Text = DateTime.ParseExact(item.UpdatedDate.ToString(), "yyyyMMdd", DateTimeFormatInfo.InvariantInfo).ToString(SessionVariables.UserDateFormat);
txtSortOrder.Text = item.SortOrder.ToString();
txtCreatedBy.Text = item.CreatedBy.ToString();
txtUpdatedBy.Text = item.UpdatedBy;
drpFunctionalityList.SelectedValue = item.FunctionalityId.ToString();
drpFunctionalityImageList.SelectedValue = item.FunctionalityImageId.ToString();
oUpdateInfo.LoadText(DateTime.Parse(item.UpdatedDate.ToString()), item.UpdatedBy, item.LastAction);
}
else
{
txtFunctionalityId.Text = String.Empty;
txtFunctionalityImageId.Text = String.Empty;
txtKeyString.Text = String.Empty;
txtTitle.Text = String.Empty;
txtDescription.Text = String.Empty;
txtSortOrder.Text = String.Empty;
txtCreatedBy.Text = String.Empty;
txtCreatedDate.Text = String.Empty;
txtUpdatedBy.Text = String.Empty;
txtUpdatedDate.Text = String.Empty;
drpFunctionalityList.SelectedValue = "-1";
drpFunctionalityImageList.SelectedValue = "-1";
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
var notDeletableIds = new List <int>();
string[] deleteIndexList = DeleteIds.Split(',');
//foreach (string index in deleteIndexList)
//{
// var data = new TaskTimeTracker.Components.DomainModel.Module.ApplicationDevelopment.FunctionalityXFunctionalityImage();
// data.FunctionalityXFunctionalityImageId = int.Parse(index);
// if (!TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityImage.IsDeletable(data, SessionVariables.RequestProfile.AuditId))
// {
// notDeletableIds.Add(Convert.ToInt32(data.FunctionalityXFunctionalityImageId));
// }
//}
if (notDeletableIds.Count == 0)
{
foreach (string index in deleteIndexList)
{
var data = new FunctionalityXFunctionalityImageDataModel();
data.FunctionalityXFunctionalityImageId = int.Parse(index);
TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityXFunctionalityImageDataManager.Delete(data, SessionVariables.RequestProfile);
}
Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.FunctionalityXFunctionalityImage, SessionVariables.RequestProfile);
Response.Redirect(Page.GetRouteUrl("FunctionalityXFunctionalityImageEntityRoute", new { Action = "Default", SetId = true }), false);
}
else
{
var msg = String.Empty;
foreach (var id in notDeletableIds)
{
if (!string.IsNullOrEmpty(msg))
{
msg += ", <br/>";
}
msg += "FunctionalityXFunctionalityImageId: " + id + " has detail records";
}
Response.Write(msg);
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected override DataTable GetData()
{
var dt1 = FunctionalityDataManager.Search(oSearchFilter.SearchParameters, SessionVariables.RequestProfile);
dt1.Columns.Add("FunctionalityImageId");
string str = string.Empty;
foreach (DataRow dr in dt1.Rows)
{
var functionalityId = Convert.ToInt32(dr["FunctionalityId"]);
var functionalityImageId = string.Empty;
var objFunctionalityXFunctionalityImage = new FunctionalityXFunctionalityImageDataModel();
objFunctionalityXFunctionalityImage.FunctionalityId = Convert.ToInt32(functionalityId);
var dtFunctionalityXFunctionalityImage = FunctionalityXFunctionalityImageDataManager.GetByFunctionality(functionalityId, SessionVariables.RequestProfile);
if (dtFunctionalityXFunctionalityImage != null && dtFunctionalityXFunctionalityImage.Rows.Count > 0)
{
foreach (DataRow drFunctionalityXFunctionalityImage in dtFunctionalityXFunctionalityImage.Rows)
{
if (string.IsNullOrEmpty(functionalityImageId))
{
functionalityImageId = drFunctionalityXFunctionalityImage["FunctionalityImageId"].ToString();
}
else
{
functionalityImageId += ", " + drFunctionalityXFunctionalityImage["FunctionalityImageId"].ToString();
}
}
}
dr["FunctionalityImageId"] = functionalityImageId;
}
return(dt1);
}
public static string ToSQLParameter(FunctionalityXFunctionalityImageDataModel data, string dataColumnName, object value)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case FunctionalityXFunctionalityImageDataModel.DataColumns.FunctionalityXFunctionalityImageId:
if (data.FunctionalityXFunctionalityImageId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityXFunctionalityImageDataModel.DataColumns.FunctionalityXFunctionalityImageId, data.FunctionalityXFunctionalityImageId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityImageDataModel.DataColumns.FunctionalityXFunctionalityImageId);
}
break;
case FunctionalityXFunctionalityImageDataModel.DataColumns.FunctionalityId:
if (data.FunctionalityId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityXFunctionalityImageDataModel.DataColumns.FunctionalityId, data.FunctionalityId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityImageDataModel.DataColumns.FunctionalityId);
}
break;
case FunctionalityXFunctionalityImageDataModel.DataColumns.FunctionalityImageId:
if (data.FunctionalityImageId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityXFunctionalityImageDataModel.DataColumns.FunctionalityImageId, data.FunctionalityImageId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityImageDataModel.DataColumns.FunctionalityImageId);
}
break;
case FunctionalityXFunctionalityImageDataModel.DataColumns.KeyString:
if (data.KeyString != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityXFunctionalityImageDataModel.DataColumns.KeyString, data.KeyString);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityImageDataModel.DataColumns.KeyString);
}
break;
case FunctionalityXFunctionalityImageDataModel.DataColumns.Title:
if (data.Title != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityXFunctionalityImageDataModel.DataColumns.Title, data.Title);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityImageDataModel.DataColumns.Title);
}
break;
case FunctionalityXFunctionalityImageDataModel.DataColumns.CreatedBy:
if (data.CreatedBy != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityXFunctionalityImageDataModel.DataColumns.CreatedBy, data.CreatedBy);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityXFunctionalityImageDataModel.DataColumns.CreatedBy);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static void Update(FunctionalityXFunctionalityImageDataModel data, RequestProfile requestProfile)
{
var sql = CreateOrUpdate(data, requestProfile, "Update");
DBDML.RunSQL("FunctionalityXFunctionalityImage.Update", sql, DataStoreKey);
}
public static List <FunctionalityXFunctionalityImageDataModel> GetEntityDetails(FunctionalityXFunctionalityImageDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.FunctionalityXFunctionalityImageSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationId = requestProfile.ApplicationId
, ApplicationMode = requestProfile.ApplicationModeId
, FunctionalityXFunctionalityImageId = dataQuery.FunctionalityXFunctionalityImageId
, FunctionalityId = dataQuery.FunctionalityId
, FunctionalityImageId = dataQuery.FunctionalityImageId
, ReturnAuditInfo = returnAuditInfo
};
List <FunctionalityXFunctionalityImageDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <FunctionalityXFunctionalityImageDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public static FunctionalityXFunctionalityImageDataModel GetDetails(FunctionalityXFunctionalityImageDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 1);
return(list.FirstOrDefault());
}
