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