private void tlbMenu_DeleteClick()
{
try
{
Cursor = Cursors.WaitCursor;
if (XtraMessageBox.Show("Be sure to delete the record?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int intIdInvoice = int.Parse(gvInvoice.GetFocusedRowCellValue("IdInvoice").ToString());
int intIdStatus = int.Parse(gvInvoice.GetFocusedRowCellValue("IdStatus").ToString());
if (intIdStatus == Parametros.intIVNDeleted)
{
XtraMessageBox.Show("It can not be canceled.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
InvoiceBL objBL_Invoice = new InvoiceBL();
objBL_Invoice.ActualizaSituacion(intIdInvoice, Parametros.intIVNDeleted);
XtraMessageBox.Show("The invoice was canceled correctly.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
Cargar();
}
}
Cursor = Cursors.Default;
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public InvoiceController(ItemDetailsBL itemDetails, StoreBL store, InvoiceBL invoice, InvoiceDetailsBL invoiceDetails)
{
this._itemDetails = itemDetails;
this._store = store;
this._invoice = invoice;
this._invoiceDetails = invoiceDetails;
}
public virtual ActionResult List()
{
var userId = 1; // only for test purpose
var list = InvoiceBL.GetList(userId);
return(View(list));
}
public async Task <IActionResult> Create(InvoiceVM obj)
{
var header = new InvoiceBL
{
InvoiceNo = obj.InvoiceNo,
StoreId = obj.StoreId,
Tax = obj.Tax
};
List <InvoiceDetailsBL> details = new List <InvoiceDetailsBL>();
foreach (var item in obj.InvoiceDetails)
{
details.Add(new InvoiceDetailsBL
{
Discount = item.Discount,
ItemId = item.ItemId,
Quantity = item.Quantity,
UnitId = item.UnitId
});
}
bool result = await _invoiceDetails.CreateInvoice(header, details);
return(Json(result));
}
public virtual List <InvoiceDto> GetList(bool isPayed)
{
var userId = 1; // for test purpose only
var result = InvoiceBL.GetList(userId, isPayed);
return(result);
}
public virtual IHttpActionResult PatchEdit(int id, Delta <InvoiceDto> invoice)
{
var userId = 1;
InvoiceBL.PatchUpdate(id, invoice, userId);
return(Ok());
}
private void SearchEvent()
{
var customerName = txtName.Text;
var mobileNo = txtMobileNo.Text;
var followUpDate = Convert.ToDateTime(dtStartDate.Text);
var status = ddlStatus.Text;
var statusItem = (ComboboxItem)ddlStatus.SelectedItem;
int statusId = Convert.ToInt32(statusItem.Value);
VehicleBookingFollowUpBL ef = new VehicleBookingFollowUpBL();
InvoiceBL iBL = new InvoiceBL();
List <VehicleBookingFollowupDTO> lst = new List <VehicleBookingFollowupDTO>();
if (_mode == "MARGIN")
{
var marginLst = iBL.GetInvoiceMarginDTOList(Convert.ToDateTime(dtStartDate.Text), Convert.ToDateTime(dtEndDate.Text), ddlInvoiceType.Text)
.Where(
efu => efu.CustomerName.ToUpper().Contains(customerName.ToUpper())
&&
efu.CustomerMobileNo.ToUpper().Contains(mobileNo.ToUpper())
).ToList();
dgFollowup.DataSource = null;
dgFollowup.DataSource = marginLst;
}
else if (_mode == "REPORTDELIVERY")
{
lst = ef.GetVehicleBookingFollowUp(Convert.ToDateTime(dtStartDate.Text), Convert.ToDateTime(dtEndDate.Text), statusId, "REPORTDELIVERY")
.Where(
efu => efu.CustomerName.ToUpper().Contains(customerName.ToUpper())
&&
efu.CustomerMobileNo.ToUpper().Contains(mobileNo.ToUpper())
&&
efu.StatusDescription.ToUpper().Contains(status.ToUpper())
).ToList();
dgFollowup.DataSource = lst;
}
else
{
lst = ef.GetVehicleBookingFollowUp(Convert.ToDateTime(dtStartDate.Text), Convert.ToDateTime(dtEndDate.Text), statusId)
.Where(
efu => efu.CustomerName.ToUpper().Contains(customerName.ToUpper())
&&
efu.CustomerMobileNo.ToUpper().Contains(mobileNo.ToUpper())
&&
efu.StatusDescription.ToUpper().Contains(status.ToUpper())
).ToList();
dgFollowup.DataSource = lst;
}
if (dgFollowup.RowCount > 0)
{
btnEDIT.Enabled = true;
}
else
{
btnEDIT.Enabled = false;
}
}
public IHttpActionResult Pay(InvoiceDto invoice)
{
invoice.UpdatedBy = new UserDto()
{
Id = 1
};
InvoiceBL.SetStatus(invoice);
return(Ok());
}
public void SaveInvocie([FromBody()] SaveInvoice saveInvoice)
{
try
{
var invoiceBL = new InvoiceBL();
invoiceBL.SaveInvoice(saveInvoice.Master, saveInvoice.DetailItem);
}
catch (Exception)
{
}
}
public void ProcessNC()
{
var transactions = new InvoiceBL();
var gpInvoice = new GPServicesREF.SOP.Invoices();
var rminvoice = new GPServicesREF.RM.Receivables();
List <TRANSACTION_INVOICE> transactionlist = transactions.GetTransactions();
var company = ConfigKey.ReadSetting("Company");
SYSFLEX_POLICY policyInfo;
List <TRANSACTION_BY_COVERAGE> TransactionCoverage;
try
{
log.WriteLog(0, "Total de Transacciones: " + transactionlist.Count.ToString());
foreach (TRANSACTION_INVOICE policyTransaction in transactionlist)
{
policyInfo = transactions.GetPolicyInfo(policyTransaction.POLICY_NUMBER.Trim());
TransactionCoverage = transactions.GetCoverageDistribution(policyTransaction.POLICY_NUMBER.Trim(), policyTransaction.TRANSACTION_SEQUENCE.GetValueOrDefault());
var channel_no_comm = ConfigKey.ReadSetting("CHANNEL_NO_COMM");
//var arrChannelNoComm = String.Join(",", channel_no_comm.ToArray());
if (policyTransaction.TRANS_TYPE == "C")
{
RMTransactionHeader header;
RMTransactionDist[] distrib;
RMDocumentTaxes[] taxes;
try
{
header = transactions.CreateRMHeader(policyInfo, policyTransaction, TransactionCoverage);
taxes = transactions.CreateRMTax(policyInfo, policyTransaction, header, TransactionCoverage, false);
distrib = transactions.CreateRMDistribution(policyInfo, policyTransaction, TransactionCoverage, taxes, header);
//Generar partida normal
transactions.SaveRenewDistribution(policyInfo.INITAL_DATE.GetValueOrDefault(), policyTransaction, distrib);
}
catch (Exception ex)
{
log.LogExeption("Ocurrió un error: ", 2, ex);
// throw;
}
}
}/////
//transactions.UpdateCommission();
}
catch (Exception ex)
{
log.LogExeption("Ocurrió un error: ", 2, ex);
throw;
}
}
public void DeleteInvoice(Guid id)
{
try
{
var invoiceBL = new InvoiceBL();
invoiceBL.DeleteInvoice(id);
}
catch (Exception)
{
throw;
}
}
public InvoiceItem GetDetailInvoice(Guid id)
{
try
{
var invoiceBL = new InvoiceBL();
return(invoiceBL.GetDetailInvoice(id));
}
catch (Exception)
{
return(null);
}
}
public List <Invoice> GetInvoicesByDate(string date)
{
try
{
var invoiceBL = new InvoiceBL();
return(invoiceBL.GetInvoicesByDate(date));
}
catch (Exception)
{
return(null);
}
}
public object InvociePaging([FromBody()] Paging pagingDate, int pageNumber)
{
try
{
var invoiceBL = new InvoiceBL();
return(invoiceBL.GetInvoicesPaging(pageNumber, pagingDate.FromDate, pagingDate.ToDate));
}
catch (Exception)
{
return(null);
}
}
public virtual ActionResult Create(InvoiceDto item)
{
var userId = 1;
item.CreatedBy = new UserDto()
{
Id = userId
}; // user for test purpose only
InvoiceBL.Create(item);
var list = InvoiceBL.GetList(userId);
return(View("List", list));
}
[HttpPost("InsertInvoice")] //API untuk menambahkan invoice baru
public IActionResult InsertInvoice([FromBody] InvoiceModel data)
{
var response = new GenericResponseModel <bool>();
var bl = new InvoiceBL();
response = bl.InsertInvoice(data);
if (!response.Status)
{
return(BadRequest(response));
}
return(Ok(response));
}
[HttpGet("GetNewInvoice")] //API untuk mendapatkan data invoice terbaru
public IActionResult GetNewInvoice()
{
var response = new GenericResponseModel <InvoiceModel>();
var bl = new InvoiceBL();
response = bl.GetInvoiceDetail();
if (!response.Status)
{
return(BadRequest(response));
}
return(Ok(response));
}
[HttpGet("GetAllProps")] //API untuk mendapatkan semua properti yang dibutuhkan UI
public IActionResult GetAllProps()
{
var response = new GenericResponseModel <InvoicePropertyModel>();
var bl = new InvoiceBL();
response = bl.GetAllProps();
if (!response.Status)
{
return(BadRequest(response));
}
return(Ok(response));
}
public List <Invoice> GetInvoiceStatistical(int type, int value)
{
try
{
var invoiceBL = new InvoiceBL();
List <Invoice> invs;
invs = invoiceBL.GetInvoiceStatistical(type, value);
return(invs);
}
catch (Exception)
{
return(null);
}
}
public JsonResult SavePartInvoice(InvoiceDTO invoiceDTO)
{
try
{
IInvoiceBL _invoiceBL = new InvoiceBL();
var invoiceID = _invoiceBL.Add(invoiceDTO);
return(new JsonResult {
Data = new { invoiceID = invoiceID }
});
}
catch (System.Exception ex)
{
ExceptionHandler exceptionHandler = new ExceptionHandler();
exceptionHandler.WrapLogException(ex);
return(null);
}
}
public ServerResponse Post([FromBody] QueryCondition queryCondition)
{
var res = new ServerResponse();
using (InvoiceBL invoiceBL = new InvoiceBL())
{
try
{
res.Data = invoiceBL.GetDataByQueryCondition(queryCondition);
}
catch (Exception ex)
{
res.Success = false;
}
}
return(res);
}
public ServerResponse GetDataByShop(string shopID)
{
var res = new ServerResponse();
using (InvoiceBL InvoiceBL = new InvoiceBL())
{
try
{
res.Data = InvoiceBL.GetDataByShop(shopID);
}
catch (Exception ex)
{
res.Success = false;
}
}
return(res);
}
public ServerResponse GetInvoiceDetail(string invoiceID)
{
var res = new ServerResponse();
using (InvoiceBL InvoiceBL = new InvoiceBL())
{
try
{
res.Data = InvoiceBL.GetInvoiceDetails(invoiceID);
}
catch (Exception ex)
{
res.Success = false;
}
}
return(res);
}
// POST: api/Unit
public ServerResponse Post([FromBody] InvoiceObject InvoiceObj)
{
var res = new ServerResponse();
using (InvoiceBL InvoiceBL = new InvoiceBL())
{
try
{
res.Data = InvoiceBL.SaveInvoice(InvoiceObj);
}
catch (Exception ex)
{
res.Success = false;
}
}
return(res);
}
// DELETE: api/Unit/5
public ServerResponse Delete(string id)
{
var res = new ServerResponse();
using (InvoiceBL InvoiceBL = new InvoiceBL())
{
try
{
res.Data = InvoiceBL.DeleteInvoice(id);
}
catch (Exception ex)
{
res.Success = false;
}
}
return(res);
}
public AjaxResult DeleteInvoice(Guid invoiceId)
{
var ajaxResult = new AjaxResult();
try
{
using (InvoiceBL invoiceBL = new InvoiceBL())
{
invoiceBL.DeleteInvoice(invoiceId);
ajaxResult.Success = true;
}
}
catch (Exception)
{
ajaxResult.Success = false;
ajaxResult.Messenger = "Có lỗi xảy ra khi xóa một hóa đơn. Vui lòng liên hệ MISA!";
}
return(ajaxResult);
}
public AjaxResult GetTotalPages(int pageSize)
{
var ajaxResult = new AjaxResult();
try
{
using (InvoiceBL invoiceBL = new InvoiceBL())
{
ajaxResult.Data = invoiceBL.GetTotalPageNumber(pageSize);
ajaxResult.Success = true;
}
}
catch (Exception)
{
ajaxResult.Success = false;
ajaxResult.Messenger = "Có lỗi xảy ra khi lấy tổng số trang. Vui lòng liên hệ MISA!";
}
return(ajaxResult);
}
public AjaxResult GetDataFilter(InvoiceDto invoiceDto)
{
var ajaxResult = new AjaxResult();
try
{
using (InvoiceBL invoiceBL = new InvoiceBL())
{
ajaxResult.Data = invoiceBL.GetDataFilter(invoiceDto);
ajaxResult.Success = true;
}
}
catch (Exception)
{
ajaxResult.Success = false;
ajaxResult.Messenger = "Có lỗi xảy ra khi lọc dữ liệu. Vui lòng liên hệ MISA!";
}
return(ajaxResult);
}
private void Reformat()
{
//Creating invoice model
DateTime now = DateTime.Now;
string date = String.Format("{0:MMMMM yyyy}", now);
//Create Receiver from
Company company = new Company();
company.Name = "Tester";
company.Email = "*****@*****.**";
company.Address1 = "59 Paisley Street";
company.Address2 = "Footscray, Victoria";
company.Postcode = "3011";
company.Country = "Australia";
//Create Transaction
Invoice invoice = new Invoice(now, 14);
invoice.Company = company;
invoice.Sender = new Sender();
invoice.InvoiceNo = "Tester";
//Create Item
Item item = new Item("Emprevo monthly subscription" + " - " + date, "55", "4");
invoice.AddItem(item);
//Saving invoice data to company
company.InvoiceNo = invoice.InvoiceNo;
company.RecentDate = invoice.InvoiceDate;
company.RecentActiveWorkers = "55";
company.RecentTotal = invoice.Total;
company.RecentRate = "4";
InvoiceBL bl = new InvoiceBL();
//Upload the content of file to cloud
GCPAdapter adapter = new GCPAdapter();
adapter.UploadObject("apiemprevo.appspot.com", "Test" + ".pdf", "application/pdf", bl.CreateInvoiceMemoryStream(invoice));
}
public AjaxResult GetNumberAutoRender()
{
var ajaxResult = new AjaxResult();
try
{
using (InvoiceBL invoiceBL = new InvoiceBL())
{
ajaxResult.Data = invoiceBL.GetNumberAutoRender();
ajaxResult.Success = true;
}
}
catch (Exception)
{
ajaxResult.Success = false;
ajaxResult.Messenger = "Có lỗi xảy ra khi lấy số phiếu nhập, phiếu chi tự động. Vui lòng liên hệ MISA!";
}
return(ajaxResult);
}
