//Service public TransactionStatus AddFeedBack(FeedBackBo feedbackBo) { var transactionStatus = new TransactionStatus(); var feedback = BuiltFeedBackDomain(feedbackBo); CemexDb con = new CemexDb(); SqlParameter[] Params = { new SqlParameter("@Name", feedback.Name), //0 new SqlParameter("@Email", feedback.EmailAddress), //0 new SqlParameter("@Mobile", feedback.Mobile), //0 new SqlParameter("@Message", feedback.Message), //3 new SqlParameter("@Date", System.DateTime.Now), //2 new SqlParameter("@opReturnValue", SqlDbType.Int) //4 }; Params[5].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_AddFeedBack]", Params); //int isExist = Convert.ToInt32(Params[6].Value); //if (isExist == 0) //{ // transactionStatus.Status = false; //} ds.Locale = CultureInfo.InvariantCulture; return(transactionStatus); }
//Feedback down public TransactionStatus AddFeedBack_Feed(FeedBackBo feedbackBo) { var transactionStatus = new TransactionStatus(); var feedback = BuiltFeedBackDomain(feedbackBo); CemexDb con = new CemexDb(); SqlParameter[] Params = { new SqlParameter("@opReturnValue", SqlDbType.Int), //4 new SqlParameter("@Name", feedback.Name), //0 new SqlParameter("@Email", feedback.EmailAddress), //0 new SqlParameter("@Message", feedback.Message), //3 new SqlParameter("@Date", System.DateTime.Now) //2 }; Params[0].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_AddFeedBack_Feed]", Params); return(transactionStatus); }
private FeedBack BuiltFeedBackDomain(FeedBackBo feedbackBo) { return((FeedBack) new FeedBack().InjectFrom(feedbackBo)); }