public JsonNetResult SaveReceipt(ReceiptInfoModel receipt) { if (receipt == null) { throw new ArgumentNullException("The receipt is null."); } if (!this.ValidateReceipt(receipt)) { return(JsonNet(new ResponseResult(false, "The receipt is invalid.", ErrorCodes.RequireField))); } var entity = new ReceiptInfoEntity { Id = receipt.Id, Title = receipt.Title, Tax = receipt.Tax, HospitalId = receipt.HospitalId }; new ReceiptInfoService().Save(entity); receipt.Id = entity.Id; return(JsonNet(new ResponseResult(true, receipt))); }
public void Save(ReceiptInfoEntity entity) { if (string.IsNullOrEmpty(entity.Id)) { entity.Id = Guid.NewGuid().ToString(); ReceiptInfoRepository.Add(entity); } else { ReceiptInfoRepository.Update(entity); } }
public static void Update(ReceiptInfoEntity receipt) { var sql = string.Format(@"UPDATE receipt_info SET title = @p_title, tax = @p_tax, updated_id = @p_updated_id, updated_time = @p_updated_time WHERE id=@p_id", COLUMN_SQL); var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_id", DbType.String, receipt.Id); db.AddInParameter(dc, "p_title", DbType.String, receipt.Title); db.AddInParameter(dc, "p_tax", DbType.String, receipt.Tax); db.AddInParameter(dc, "p_updated_id", DbType.String, receipt.UpdatedId); db.AddInParameter(dc, "p_updated_time", DbType.DateTime, receipt.UpdatedTime); db.ExecuteNonQuery(dc); }
public static void Add(ReceiptInfoEntity receipt) { var sql = string.Format(@"INSERT INTO receipt_info({0}) VALUES(@p_id, @p_hospital_id, @p_title, @p_tax, @p_created_id, @p_created_time, @p_updated_id, @p_updated_time)", COLUMN_SQL); var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_id", DbType.String, receipt.Id); db.AddInParameter(dc, "p_hospital_id", DbType.String, receipt.HospitalId); db.AddInParameter(dc, "p_title", DbType.String, receipt.Title); db.AddInParameter(dc, "p_tax", DbType.String, receipt.Tax); db.AddInParameter(dc, "p_created_id", DbType.String, receipt.CreatedId); db.AddInParameter(dc, "p_created_time", DbType.DateTime, receipt.CreatedTime); db.AddInParameter(dc, "p_updated_id", DbType.String, receipt.UpdatedId); db.AddInParameter(dc, "p_updated_time", DbType.DateTime, receipt.UpdatedTime); db.ExecuteNonQuery(dc); }
public static ReceiptInfoEntity Get(string id) { var sql = string.Format(@"SELECT {0} FROM receipt_info WHERE id = @p_id ", COLUMN_SQL); var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_id", DbType.String, id); var list = new List <ReceiptInfoEntity>(); using (var reader = db.ExecuteReader(dc)) { while (reader.Read()) { var entity = new ReceiptInfoEntity(); entity.Init(reader); return(entity); } return(null); } }
public static IList <ReceiptInfoEntity> GetByHospital(string hospitalId) { var sql = string.Format(@"SELECT {0} FROM receipt_info WHERE hospital_id = @p_hospital_id ORDER BY TITLE", COLUMN_SQL); var db = DatabaseFactory.CreateDatabase(); var dc = db.GetSqlStringCommand(sql); db.AddInParameter(dc, "p_hospital_id", DbType.String, hospitalId); var list = new List <ReceiptInfoEntity>(); using (var reader = db.ExecuteReader(dc)) { while (reader.Read()) { var entity = new ReceiptInfoEntity(); entity.Init(reader); list.Add(entity); } } return(list); }