public void Insert(FeedbackDetails data)
{
try
{
List<KeyValuePair<string, object>> para = new List<KeyValuePair<string, object>>();
para.Add(new KeyValuePair<string, object>("@name", data.Name));
//para.Add(new KeyValuePair<string, object>("@emailID", data.EmailID));
para.Add(new KeyValuePair<string, object>("@category", data.Category));
para.Add(new KeyValuePair<string, object>("@title", data.Title));
para.Add(new KeyValuePair<string, object>("@description", data.Description));
para.Add(new KeyValuePair<string, object>("@domain", data.Domain));
// para.Add(new KeyValuePair<string, object>("@sentBy", data.SentBy));
// para.Add(new KeyValuePair<string, object>("@isread", data.IsRead));
// para.Add(new KeyValuePair<string, object>("@receivedOn", data.ReceivedOn));
//para.Add(new KeyValuePair<string, object>("@rating", data.Rating));
//para.Add(new KeyValuePair<string, object>("@userModuleID", data.UserModuleID));
//para.Add(new KeyValuePair<string, object>("@portalID", data.PortalID));
//para.Add(new KeyValuePair<string, object>("@cultureCode", data.CultureCode));
SQLHandler SQL = new SQLHandler();
SQL.ExecuteNonQuery("usp_Feedback_Insert", para);
}
catch
{
throw;
}
}
public List<FeedbackDetails> GetAllFeedbacks(FeedbackDetails obj)
{
try
{
List<KeyValuePair<string, object>> para = new List<KeyValuePair<string, object>>();
para.Add(new KeyValuePair<string, object>("@SortName", obj.SortName));
para.Add(new KeyValuePair<string, object>("@SortOrder", obj.SortOrder));
para.Add(new KeyValuePair<string, object>("@isread", obj.IsRead));
para.Add(new KeyValuePair<string, object>("@keyword", obj.Keyword));
para.Add(new KeyValuePair<string, object>("@PageSize", obj.PageSize));
para.Add(new KeyValuePair<string, object>("@PageNo", obj.PageNumber));
// para.Add(new KeyValuePair<string, object>("@RowNum", obj.TotalCount));
para.Add(new KeyValuePair<string, object>("@startDate", obj.StartDate));
para.Add(new KeyValuePair<string, object>("@endDate", obj.EndDate));
SQLHandler SQL = new SQLHandler();
return SQL.ExecuteAsList<FeedbackDetails>("usp_Feedback_GetAllFeedbacks", para);
}
catch (Exception ex)
{
throw ex;
}
}
public List <FeedbackDetails> GetAllFeedbacks(FeedbackDetails obj)
{
FeedbackProvider FP = new FeedbackProvider();
return(FP.GetAllFeedbacks(obj));
}
public void Insert(FeedbackDetails data)
{
FeedbackProvider FD = new FeedbackProvider();
FD.Insert(data);
}