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