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); }