protected override void ShowData(int ScheduleQuestionId)
{
base.ShowData(ScheduleQuestionId);
oDetailButtonPanel.SetId = SetId;
Clear();
var dataQuery = new ScheduleQuestionDataModel();
dataQuery.ScheduleQuestionId = ScheduleQuestionId;
var entityList = ScheduleQuestionDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile);
if (entityList.Count == 1)
{
foreach (var entityItem in entityList)
{
lblScheduleQuestionId.Text = entityItem.ScheduleQuestionId.ToString();
lblScheduleId.Text = entityItem.ScheduleId.ToString();
lblQuestionId.Text = entityItem.QuestionId.ToString();
lblAnswer.Text = entityItem.Answer.ToString();
oUpdateInfo.LoadText(entityItem.UpdatedDate, entityItem.UpdatedBy, entityItem.LastAction);
oHistoryList.Setup(PrimaryEntity, ScheduleQuestionId, "ScheduleQuestion");
}
}
}
public override int?Save(string action)
{
var data = new ScheduleQuestionDataModel();
data.ScheduleQuestionId = ScheduleQuestionId;
data.ScheduleId = ScheduleId;
data.QuestionId = QuestionId;
data.Answer = Answer;
if (action == "Insert")
{
var dtScheduleQuestion = ScheduleQuestionDataManager.DoesExist(data, SessionVariables.RequestProfile);
if (dtScheduleQuestion.Rows.Count == 0)
{
ScheduleQuestionDataManager.Create(data, SessionVariables.RequestProfile);
}
else
{
throw new Exception("Record with given ID already exists.");
}
}
else
{
ScheduleQuestionDataManager.Update(data, SessionVariables.RequestProfile);
}
// not correct ... when doing insert, we didn't get/change the value of ScheduleID ?
return(ScheduleQuestionId);
}
protected override void Update(Dictionary <string, string> values)
{
var data = new ScheduleQuestionDataModel();
if (values.ContainsKey(ScheduleQuestionDataModel.DataColumns.ScheduleQuestionId))
{
data.ScheduleQuestionId = int.Parse(values[ScheduleQuestionDataModel.DataColumns.ScheduleQuestionId].ToString());
}
if (values.ContainsKey(ScheduleQuestionDataModel.DataColumns.ScheduleId))
{
data.ScheduleId = int.Parse(values[ScheduleQuestionDataModel.DataColumns.ScheduleId].ToString());
}
if (values.ContainsKey(ScheduleQuestionDataModel.DataColumns.QuestionId))
{
data.QuestionId = int.Parse(values[ScheduleQuestionDataModel.DataColumns.QuestionId].ToString());
}
if (values.ContainsKey(ScheduleQuestionDataModel.DataColumns.Answer))
{
data.Answer = values[ScheduleQuestionDataModel.DataColumns.Answer].ToString();
}
ScheduleQuestionDataManager.Update(data, SessionVariables.RequestProfile);
base.Update(values);
}
public static DataTable Search(ScheduleQuestionDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 0);
var table = list.ToDataTable();
return(table);
}
public static void SyncQuestions(int scheduleId, RequestProfile requestProfile)
{
// Get all ScheduleId related records from ScheduleQuestion
var dtScheduleQuestion = ScheduleQuestionDataManager.GetBySchedule(scheduleId, requestProfile);
// Get all Question Records
var questionData = QuestionDataManager.GetList(requestProfile);
// filter question records using Question Category 'EOD Questions'
questionData.DefaultView.RowFilter = "QuestionCategory = 'EOD Questions'";
questionData = questionData.DefaultView.ToTable();
var scheduleQuestionData = new ScheduleQuestionDataModel();
// for loop for entering default answers for all questions
for (var i = 0; i < questionData.Rows.Count; i++)
{
var questionid = int.Parse(questionData.Rows[i][QuestionDataModel.DataColumns.QuestionId].ToString());
var filterExpression = QuestionDataModel.DataColumns.QuestionId + " = " + questionid;
// find if record for this question id exists in ScheduleQuestion for the particular ScheduleId
var rows = dtScheduleQuestion.Select(filterExpression);
// insert if no record found
if (rows.Length == 0)
{
scheduleQuestionData = new ScheduleQuestionDataModel();
scheduleQuestionData.ScheduleId = scheduleId;
scheduleQuestionData.QuestionId = int.Parse(questionid.ToString());
scheduleQuestionData.Answer = "No";
ScheduleQuestionDataManager.Create(scheduleQuestionData, requestProfile);
}
}
// refresh data table with newly added records
dtScheduleQuestion = ScheduleQuestionDataManager.GetBySchedule(scheduleId, requestProfile);
// for removing invalid category schedule questions
for (var i = 0; i < dtScheduleQuestion.Rows.Count; i++)
{
var questionid = int.Parse(dtScheduleQuestion.Rows[i][ScheduleQuestionDataModel.DataColumns.QuestionId].ToString());
var filterExpression = ScheduleQuestionDataModel.DataColumns.QuestionId + " = " + questionid;
// find if record for this question id exists in ScheduleQuestion for the particular ScheduleId
var rows = questionData.Select(filterExpression);
// insert if no record found, so it is invalid
if (rows.Length == 0)
{
scheduleQuestionData = new ScheduleQuestionDataModel();
scheduleQuestionData.ScheduleQuestionId = int.Parse(dtScheduleQuestion.Rows[i][ScheduleQuestionDataModel.DataColumns.ScheduleQuestionId].ToString());
ScheduleQuestionDataManager.Delete(scheduleQuestionData, requestProfile);
}
}
}
public static DataTable GetQuestionData(int?scheduleId, RequestProfile requestProfile)
{
var data = new ScheduleQuestionDataModel();
data.ScheduleId = scheduleId;
var scheduleQuestiondt = ScheduleQuestionDataManager.Search(data, requestProfile);
return(scheduleQuestiondt);
}
private System.Data.DataTable GetData()
{
// TODO: on all export pages
var data = new ScheduleQuestionDataModel();
var dt = ScheduleQuestionDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
protected override DataTable GetEntityData(int?entityKey)
{
var scheduleQuestiondata = new ScheduleQuestionDataModel();
scheduleQuestiondata.ScheduleQuestionId = entityKey;
var results = ScheduleQuestionDataManager.Search(scheduleQuestiondata, SessionVariables.RequestProfile);
return(results);
}
public static bool DoesExist(ScheduleQuestionDataModel data, RequestProfile requestProfile)
{
var doesExistRequest = new ScheduleQuestionDataModel();
doesExistRequest.ScheduleId = data.ScheduleId;
var list = GetEntityDetails(doesExistRequest, requestProfile, 0);
return(list.Count > 0);
}
protected override void Clear()
{
base.Clear();
var data = new ScheduleQuestionDataModel();
ScheduleQuestionId = data.ScheduleQuestionId;
ScheduleId = data.ScheduleId;
QuestionId = data.QuestionId;
Answer = data.Answer;
}
public static void Delete(ScheduleQuestionDataModel dataQuery, RequestProfile requestProfile)
{
const string sql = @"dbo.ScheduleQuestionDelete ";
var parameters =
new
{
AuditId = requestProfile.AuditId
,
ScheduleQuestionId = dataQuery.ScheduleQuestionId
};
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
string[] deleteIndexList = DeleteIds.Split(',');
foreach (string index in deleteIndexList)
{
var data = new ScheduleQuestionDataModel();
data.ScheduleQuestionId = int.Parse(index);
ScheduleQuestionDataManager.Delete(data, SessionVariables.RequestProfile);
}
DeleteAndRedirect();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void lbtnSubmit_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in gvScheduleQuestions.Rows)
{
var lblScheduleQuestionId = (Label)row.FindControl("lblScheduleQuestionId");
var lblQuestionId = (Label)row.FindControl("lblQuestionId");
var drpAnswer = (DropDownList)row.FindControl("drpAnswer");
var data = new ScheduleQuestionDataModel();
data.ScheduleId = (int)ViewState["SetId"];
data.QuestionId = Convert.ToInt32(lblQuestionId.Text);
data.Answer = drpAnswer.SelectedValue;
data.ScheduleQuestionId = Convert.ToInt32(lblScheduleQuestionId.Text);
ScheduleQuestionDataManager.Update(data, SessionVariables.RequestProfile);
}
GetData((int)ViewState["SetId"]);
}
public void LoadData(int scheduleQuestionId, bool showId)
{
// clear UI
Clear();
var dataQuery = new ScheduleQuestionDataModel();
dataQuery.ScheduleQuestionId = scheduleQuestionId;
var items = ScheduleQuestionDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile);
if (items.Count != 1)
{
return;
}
var item = items[0];
ScheduleQuestionId = item.ScheduleQuestionId;
ScheduleId = item.ScheduleId;
QuestionId = item.QuestionId;
Answer = item.Answer;
if (!showId)
{
txtScheduleQuestionId.Text = item.ScheduleQuestionId.ToString();
// only show Audit History in case of Update page, not for Clone.
oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.ScheduleQuestion, scheduleQuestionId, "ScheduleQuestion");
}
else
{
txtScheduleQuestionId.Text = String.Empty;
}
oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction);
}
protected override DataTable GetData()
{
try
{
SuperKey = ApplicationCommon.GetSuperKey();
SetId = ApplicationCommon.GetSetId();
var selectedrows = new DataTable();
var scheduleQuestiondata = new ScheduleQuestionDataModel();
selectedrows = ScheduleQuestionDataManager.GetDetails(scheduleQuestiondata, SessionVariables.RequestProfile).Clone();
if (!string.IsNullOrEmpty(SuperKey))
{
var systemEntityTypeId = (int)PrimaryEntity;
var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey);
foreach (var entityKey in lstEntityKeys)
{
scheduleQuestiondata.ScheduleQuestionId = entityKey;
var result = ScheduleQuestionDataManager.GetDetails(scheduleQuestiondata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
}
else
{
scheduleQuestiondata.ScheduleQuestionId = SetId;
var result = ScheduleQuestionDataManager.GetDetails(scheduleQuestiondata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
return(selectedrows);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
return(null);
}
protected override DataTable UpdateData()
{
var UpdatedData = new DataTable();
var data = new ScheduleQuestionDataModel();
UpdatedData = ScheduleQuestionDataManager.Search(data, SessionVariables.RequestProfile).Clone();
for (var i = 0; i < SelectedData.Rows.Count; i++)
{
data.ScheduleQuestionId =
Convert.ToInt32(SelectedData.Rows[i][ScheduleQuestionDataModel.DataColumns.ScheduleQuestionId].ToString());
data.ScheduleId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(ScheduleQuestionDataModel.DataColumns.ScheduleId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(ScheduleQuestionDataModel.DataColumns.ScheduleId).ToString())
: int.Parse(SelectedData.Rows[i][ScheduleQuestionDataModel.DataColumns.ScheduleId].ToString());
data.QuestionId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(ScheduleQuestionDataModel.DataColumns.QuestionId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(ScheduleQuestionDataModel.DataColumns.QuestionId).ToString())
: int.Parse(SelectedData.Rows[i][ScheduleQuestionDataModel.DataColumns.QuestionId].ToString());
data.Answer =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(ScheduleQuestionDataModel.DataColumns.Answer))
?CheckAndGetRepeaterTextBoxValue(ScheduleQuestionDataModel.DataColumns.Answer).ToString()
: SelectedData.Rows[i][ScheduleQuestionDataModel.DataColumns.Answer].ToString();
ScheduleQuestionDataManager.Update(data, SessionVariables.RequestProfile);
data = new ScheduleQuestionDataModel();
data.ScheduleQuestionId = Convert.ToInt32(SelectedData.Rows[i][ScheduleQuestionDataModel.DataColumns.ScheduleQuestionId].ToString());
var dt = ScheduleQuestionDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
UpdatedData.ImportRow(dt.Rows[0]);
}
}
return(UpdatedData);
}
public static string ToSQLParameter(ScheduleQuestionDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ScheduleQuestionDataModel.DataColumns.ScheduleQuestionId:
if (data.ScheduleQuestionId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleQuestionDataModel.DataColumns.ScheduleQuestionId, data.ScheduleQuestionId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleQuestionDataModel.DataColumns.ScheduleQuestionId);
}
break;
case ScheduleQuestionDataModel.DataColumns.ScheduleId:
if (data.ScheduleId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleQuestionDataModel.DataColumns.ScheduleId, data.ScheduleId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleQuestionDataModel.DataColumns.ScheduleId);
}
break;
case ScheduleQuestionDataModel.DataColumns.QuestionId:
if (data.QuestionId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ScheduleQuestionDataModel.DataColumns.QuestionId, data.QuestionId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleQuestionDataModel.DataColumns.QuestionId);
}
break;
case ScheduleQuestionDataModel.DataColumns.FromSearchDate:
if (data.FromSearchDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleQuestionDataModel.DataColumns.FromSearchDate, data.FromSearchDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleQuestionDataModel.DataColumns.FromSearchDate);
}
break;
case ScheduleQuestionDataModel.DataColumns.ToSearchDate:
if (data.ToSearchDate != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleQuestionDataModel.DataColumns.ToSearchDate, data.ToSearchDate);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleQuestionDataModel.DataColumns.ToSearchDate);
}
break;
case ScheduleQuestionDataModel.DataColumns.Answer:
if (data.Answer != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ScheduleQuestionDataModel.DataColumns.Answer, data.Answer);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ScheduleQuestionDataModel.DataColumns.Answer);
}
break;
default:
returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static void Update(ScheduleQuestionDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Update");
DBDML.RunSQL("ScheduleQuestion.Update", sql, DataStoreKey);
}
public static ScheduleQuestionDataModel GetDetails(ScheduleQuestionDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 1);
return(list.FirstOrDefault());
}
