// For Subscription public TransactionStatus AddSubscribe(SubscribeBo subscribeBo) { var transactionStatus = new TransactionStatus(); var subscirbe = BuiltSubscribeDomain(subscribeBo); CemexDb con = new CemexDb(); SqlParameter[] Params = { new SqlParameter("@Email", subscirbe.Email), //0 new SqlParameter("@Date", System.DateTime.Now), //2 new SqlParameter("@Ipaddress", subscirbe.Ipaddress), //3 new SqlParameter("@opReturnValue", SqlDbType.Int) //4 }; Params[3].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddSubscribe", Params); int isExist = Convert.ToInt32(Params[3].Value); if (isExist == 0) { transactionStatus.Status = false; } ds.Locale = CultureInfo.InvariantCulture; return(transactionStatus); }
private Subscribe BuiltSubscribeDomain(SubscribeBo subscribeBo) { return((Subscribe) new Subscribe().InjectFrom(subscribeBo)); }