public virtual CouponStore UpdateCouponStore(CouponStore entity) { if (entity.IsTransient()) { return(entity); } CouponStore other = GetCouponStore(entity.CouponId); if (entity.Equals(other)) { return(entity); } string sql = @"Update CouponStore set [ID]=@ID , [StoreID]=@StoreID , [CreatedOn]=@CreatedOn where CouponID=@CouponID" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@CouponID", entity.CouponId) , new SqlParameter("@ID", entity.Id) , new SqlParameter("@StoreID", entity.StoreId) , new SqlParameter("@CreatedOn", entity.CreatedOn) }; SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray); return(GetCouponStore(entity.CouponId)); }
public virtual CouponStore InsertCouponStore(CouponStore entity) { CouponStore other = new CouponStore(); other = entity; if (entity.IsTransient()) { string sql = @"Insert into CouponStore ( [CouponID] ,[ID] ,[StoreID] ,[CreatedOn] ) Values ( @CouponID , @ID , @StoreID , @CreatedOn ); Select scope_identity()" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@CouponID", entity.CouponId) , new SqlParameter("@ID", entity.Id) , new SqlParameter("@StoreID", entity.StoreId) , new SqlParameter("@CreatedOn", entity.CreatedOn) }; var identity = SqlHelper.ExecuteScalar(this.ConnectionString, CommandType.Text, sql, parameterArray); if (identity == DBNull.Value) { throw new DataException("Identity column was null as a result of the insert operation."); } return(GetCouponStore(Convert.ToInt32(identity))); } return(entity); }