/// <summary> /// Deletes the specified object. /// </summary> /// <param name="invoiceFormNumberEntity">The invoice form number entity.</param> /// <returns></returns> /// <exception cref="System.NotImplementedException"></exception> public string DeleteInvoiceFormNumber(InvoiceFormNumberEntity invoiceFormNumberEntity) { const string sql = @"uspDelete_InvoiceFormNumber"; object[] parms = { "@InvoiceFormNumberID", invoiceFormNumberEntity.InvoiceFormNumberId }; return(Db.Delete(sql, true, parms)); }
/// <summary> /// Takes the specified invoice form number entity. /// </summary> /// <param name="invoiceFormNumberEntity">The invoice form number entity.</param> /// <returns></returns> private static object[] Take(InvoiceFormNumberEntity invoiceFormNumberEntity) { return(new object[] { "@InvoiceFormNumberID", invoiceFormNumberEntity.InvoiceFormNumberId, "@InvoiceFormNumberCode", invoiceFormNumberEntity.InvoiceFormNumberCode, "@InvoiceFormNumberName", invoiceFormNumberEntity.InvoiceFormNumberName, "@InvoiceTypeID", invoiceFormNumberEntity.InvoiceType, "@IsSystem", invoiceFormNumberEntity.IsSystem, "@IsActive", invoiceFormNumberEntity.IsActive }); }
/// <summary> /// Updates the account category. /// </summary> /// <param name="invoiceFormNumberEntity">The invoice form number entity.</param> /// <returns> /// AccountCategoryResponse. /// </returns> public InvoiceFormNumberResponse UpdateInvoiceFormNumber(InvoiceFormNumberEntity invoiceFormNumberEntity) { var response = new InvoiceFormNumberResponse { Acknowledge = AcknowledgeType.Success }; try { if (!invoiceFormNumberEntity.Validate()) { foreach (string error in invoiceFormNumberEntity.ValidationErrors) { response.Message += error + Environment.NewLine; } response.Acknowledge = AcknowledgeType.Failure; return(response); } var voucherList = InvoiceFormNumberDao.GetInvoiceFormNumbersByCode(invoiceFormNumberEntity.InvoiceFormNumberCode.Trim()); if (voucherList != null) { if (voucherList.InvoiceFormNumberId != invoiceFormNumberEntity.InvoiceFormNumberId) { response.Acknowledge = AcknowledgeType.Failure; response.Message = @"Mẫu số hóa đơn mã " + invoiceFormNumberEntity.InvoiceFormNumberCode.Trim() + @" đã tồn tại !"; return(response); } } response.Message = InvoiceFormNumberDao.UpdateInvoiceFormNumber(invoiceFormNumberEntity); if (!string.IsNullOrEmpty(response.Message)) { response.Acknowledge = AcknowledgeType.Failure; return(response); } response.InvoiceFormNumberId = invoiceFormNumberEntity.InvoiceFormNumberId; return(response); } catch (Exception ex) { response.Message = ex.Message; return(response); } }
public List <InvoiceFormNumberEntity> GetInvoiceFormNumber(string connectionString) { List <InvoiceFormNumberEntity> listInvoiceFormNumber = new List <InvoiceFormNumberEntity>(); using (var context = new MISAEntity(connectionString)) { var categories = context.InvoiceFormNumbers.ToList(); foreach (var result in categories) { var invoiceFormNumber = new InvoiceFormNumberEntity(); invoiceFormNumber.InvoiceFormNumberId = result.InvoiceFormNumberID.ToString(); invoiceFormNumber.InvoiceFormNumberCode = result.InvoiceFormNumberCode; invoiceFormNumber.InvoiceFormNumberName = result.InvoiceFormNumberName; invoiceFormNumber.InvoiceType = result.InvoiceType; invoiceFormNumber.IsSystem = result.IsSystem; invoiceFormNumber.IsActive = result.InActive == true?false:true; listInvoiceFormNumber.Add(invoiceFormNumber); } } return(listInvoiceFormNumber); }
/// <summary> /// Updates the specified object. /// </summary> /// <param name="invoiceFormNumberEntity">The invoice form number entity.</param> /// <returns></returns> /// <exception cref="System.NotImplementedException"></exception> public string UpdateInvoiceFormNumber(InvoiceFormNumberEntity invoiceFormNumberEntity) { const string sql = @"uspUpdate_InvoiceFormNumber"; return(Db.Insert(sql, true, Take(invoiceFormNumberEntity))); }