public static List <FeedBackMasters> GetFeedBackMastersList(int userID)
{
List <FeedBackMasters> FeedBackMastersList = new List <FeedBackMasters>();
DataTable FeedBackMastersTable = FeedbackMasterDataAccess.GetInstance.GetFeedBackList(userID);
foreach (DataRow dr in FeedBackMastersTable.Rows)
{
FeedBackMasters TheFeedbackMaster = DataRowToObjectFeedBack(dr);
FeedBackMastersList.Add(TheFeedbackMaster);
}
return(FeedBackMastersList);
}
public int DeleteFeedBack(FeedBackMasters theFeedBackMasters)
{
int ReturnValue = 0;
using (SqlCommand DeleteCommand = new SqlCommand())
{
DeleteCommand.CommandType = CommandType.StoredProcedure;
DeleteCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
DeleteCommand.Parameters.Add(GetParameter("@QuestionID", SqlDbType.Int, theFeedBackMasters.FeedbackID));
DeleteCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, 1));
DeleteCommand.CommandText = "";
ExecuteStoredProcedure(DeleteCommand);
ReturnValue = int.Parse(DeleteCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public int UpdateFeedBack(FeedBackMasters theFeedBackMasters)
{
int ReturnValue = 0;
using (SqlCommand UpdateCommand = new SqlCommand())
{
UpdateCommand.CommandType = CommandType.StoredProcedure;
UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
UpdateCommand.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, 44));
UpdateCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, 1));
UpdateCommand.CommandText = "";
ExecuteStoredProcedure(UpdateCommand);
ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString());
}
return(ReturnValue);
}
public static FeedBackMasters DataRowToObjectFeedBack(DataRow dr)
{
FeedBackMasters TheFeedBackMasters = new FeedBackMasters();
TheFeedBackMasters.FeedbackID = int.Parse(dr["FeedbackID"].ToString());
TheFeedBackMasters.QuestionID = int.Parse(dr["QuestionID"].ToString());
TheFeedBackMasters.OptionValue = dr["OptionValue"].ToString();
TheFeedBackMasters.QuestionTitle = dr["QuestionTitle"].ToString();
TheFeedBackMasters.QuestionDesc = dr["QuestionDesc"].ToString();
TheFeedBackMasters.UserID = int.Parse(dr["UserID"].ToString());
TheFeedBackMasters.OfficeID = int.Parse(dr["OfficeID"].ToString());
TheFeedBackMasters.AddedBy = int.Parse(dr["AddedBy"].ToString());
TheFeedBackMasters.IsActive = bool.Parse(dr["IsActive"].ToString());
TheFeedBackMasters.IsDeleted = bool.Parse(dr["IsDeleted"].ToString());
return(TheFeedBackMasters);
}
public static int DeleteFeedBack(FeedBackMasters theFeedBackMaster)
{
return(FeedbackMasterDataAccess.GetInstance.DeleteFeedBack(theFeedBackMaster));
}
private int InsertFeedback()
{
int procreturnvalue = 0;
string OptionValue = string.Empty;
int QID = 0;
string value = string.Empty;
List <FeedBackMasters> theList = new List <FeedBackMasters>();
String QuestionNo = "";
foreach (GridViewRow row in GridView1.Rows)
{
bool DidAnswerAllQuestions = false;
OptionValue = string.Empty;
FeedBackMasters theOM = new FeedBackMasters();
QID = int.Parse(((Label)row.FindControl("lbl_QuestionID")).Text);
RadioButton radio4 = (RadioButton)row.FindControl("RadioButton4");
RadioButton radio5 = (RadioButton)row.FindControl("RadioButton5");
RadioButton radio6 = (RadioButton)row.FindControl("RadioButton6");
RadioButton radio7 = (RadioButton)row.FindControl("RadioButton7");
if (radio4.Checked)
{
OptionValue = radio4.Text;
PageVariables.str1 = PageVariables.str1 + "" + radio4.Text;
DidAnswerAllQuestions = true;
}
if (radio5.Checked)
{
OptionValue = radio5.Text;
PageVariables.str2 = PageVariables.str1 + "" + radio5.Text;
DidAnswerAllQuestions = true;
}
if (radio6.Checked)
{
OptionValue = radio6.Text;
PageVariables.str3 = PageVariables.str1 + "" + radio6.Text;
DidAnswerAllQuestions = true;
}
if (radio7.Checked)
{
OptionValue = radio7.Text;
PageVariables.str4 = PageVariables.str1 + "" + radio7.Text;
DidAnswerAllQuestions = true;
}
// Check if missed any one answer
if (DidAnswerAllQuestions == false)
{
//lbl_TheMessage.Text = "Please choose One Option";
//dialog_Message.Show();
return(-10);
}
else if (OptionValue == string.Empty)
{
//lbl_TheMessage.Text = "Please choose One Option";
//dialog_Message.Show();
return(-10);
}
else
{
theOM.QuestionID = QID;
theOM.OptionValue = OptionValue;
theList.Add(theOM);
QuestionNo = QuestionNo + theOM.QuestionID + ',';
value = value + theOM.OptionValue + ',';
}
}
if (QuestionNo.Length == 0)
{
lbl_TheMessage.Text = "Please select some values";
dialog_Message.Show();
}
else if (value.Length == 0)
{
lbl_TheMessage.Text = "Please answer all questions before submit!";
dialog_Message.Show();
}
else
{
QuestionNo = QuestionNo.Remove(QuestionNo.Length - 1);
value = value.Remove(value.Length - 1);
procreturnvalue = FeedbackMasterManagement.GetInstance.InsertFeedBack(QuestionNo, value);
}
return(procreturnvalue);
}
public int DeleteFeedBack(FeedBackMasters theFeedBackMasters)
{
return(FeedbackMasterIntegration.DeleteFeedBack(theFeedBackMasters));
}
public int UpdateFeedBack(FeedBackMasters theFeedBackMasters)
{
return(FeedbackMasterIntegration.UpdateFeedBack(theFeedBackMasters));
}
