private Boolean canBeRefunded(BillTable bill)
{
List <Parameter> parameters = new List <Parameter>();
parameters.Add(new Parameter("@bill_id", bill.id));
return(Convert.ToBoolean(StoreManager.getInstance().getStoreProcedureResult("sp_bill_can_be_refunded", parameters)));
}
private void gridBill_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0 || e.ColumnIndex < 0)
{
return;
}
string columnName = this.gridBill.Columns[e.ColumnIndex].Name;
BillTable selected = ((BillTable)gridBill.Rows[e.RowIndex].DataBoundItem);
if ("colEdit".Equals(columnName))
{
List <Parameter> parameters = new List <Parameter>();
parameters.Add(new Parameter("@bill_id", selected.id));
Boolean canEdit = Convert.ToBoolean(StoreManager.getInstance().getStoreProcedureResult("sp_can_edit_bill", parameters));
if (!canEdit)
{
MessageBox.Show("La factura no se puede editar porque posee una rendicion y/o un pago", "Info");
return;
}
Bill bill = StoreManager.getInstance().executeReadSingleResult <Bill>("sp_get_bill", new BillMapper(), parameters);
(new CUBill(this, bill)).Show();
}
}
public IHttpActionResult PostBillDetail([FromBody] BillTable billtable)
{
using (DBEntities entities = new DBEntities())
{
try
{
billtable = entities.BillTables.Add(billtable);
entities.SaveChanges();
return(Ok(billtable));
}
catch (Exception)
{
return(BadRequest());
}
}
}
private void gridBill_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0 || e.ColumnIndex < 0)
{
return;
}
string columnName = this.gridBill.Columns[e.ColumnIndex].Name;
BillTable selected = ((BillTable)gridBill.Rows[e.RowIndex].DataBoundItem);
if ("colRefund".Equals(columnName))
{
if (canBeRefunded(selected))
{
new ReasonForm(selected.id, this).Show();
}
else
{
MessageBox.Show("No se puede reembolsar una factura ya rendida.", "Error");
return;
}
}
}
public IHttpActionResult PutPurchaseTable(int id, BillTable billTable)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != billTable.BilID)
{
return(BadRequest());
}
db.Entry(billTable).State = EntityState.Modified;
try
{
db.SaveChanges();
return(Ok(billTable));
}
catch (Exception ex)
{
return(NotFound());
}
}
private BillTable[] ExtractBillTable(byte[] Data)
{
BillTable[] billtable = new BillTable[24];
//if (Data != null && Data.Length == 125)
//{
// int p = 0;
// for (int i = 3; i < 122; i++)
// {
// billtable[p].CountryCode = null;
// billtable[p].CountryCode += Encoding.ASCII.GetString(Data, i + 1, 3);
// switch (Data[i + 4])
// {
// case 0x00:
// billtable[p].DigitBillType = Data[i];
// billtable[p].BillType = p;
// break;
// case 0x01:
// billtable[p].DigitBillType = Data[i] * 10;
// billtable[p].BillType = p;
// break;
// case 0x02:
// billtable[p].DigitBillType = Data[i] * 100;
// billtable[p].BillType = p;
// break;
// case 0x03:
// billtable[p].DigitBillType = Data[i] * 1000;
// billtable[p].BillType = p;
// break;
// case 0x04:
// billtable[p].DigitBillType = Data[i] * 10000;
// billtable[p].BillType = p;
// break;
// case 0x05:
// billtable[p].DigitBillType = Data[i] * 100000;
// billtable[p].BillType = p;
// break;
// case 0x06:
// billtable[p].DigitBillType = Data[i] * 1000000;
// billtable[p].BillType = p;
// break;
// default:
// break;
// }
// i = i + 4;
// p++;
// }
//}
//else
//{
// if (Data != null)
// {
// for (int i = 0; i < 24; i++)
// {
// billtable[i].CountryCode = null;
// billtable[i].DigitBillType = 0;
// billtable[i].BillType = 0;
// }
// }
//}
if (Data != null && Data.Length == 120)
{
int p = 0;
for (int i = 0; i < 120; i++)
{
billtable[p].CountryCode = null;
billtable[p].CountryCode += Encoding.ASCII.GetString(Data, i + 1, 3);
switch (Data[i + 4])
{
case 0x00:
billtable[p].DigitBillType = Data[i];
billtable[p].BillType = p;
break;
case 0x01:
billtable[p].DigitBillType = Data[i] * 10;
billtable[p].BillType = p;
break;
case 0x02:
billtable[p].DigitBillType = Data[i] * 100;
billtable[p].BillType = p;
break;
case 0x03:
billtable[p].DigitBillType = Data[i] * 1000;
billtable[p].BillType = p;
break;
case 0x04:
billtable[p].DigitBillType = Data[i] * 10000;
billtable[p].BillType = p;
break;
case 0x05:
billtable[p].DigitBillType = Data[i] * 100000;
billtable[p].BillType = p;
break;
case 0x06:
billtable[p].DigitBillType = Data[i] * 1000000;
billtable[p].BillType = p;
break;
default:
break;
}
i = i + 4;
p++;
}
}
else
{
if (Data != null)
{
for (int i = 0; i < 24; i++)
{
billtable[i].CountryCode = null;
billtable[i].DigitBillType = 0;
billtable[i].BillType = 0;
}
}
}
return(billtable);
}
public JsonResult Proceeds(int Id, string Status)
{
MvcPurchaseModel PurchaseModel = new MvcPurchaseModel();
List <MvcPurchaseViewModel> _PurcchaseDetailList = new List <MvcPurchaseViewModel>();
InvoiceTable InvoiceTable = new InvoiceTable();
MVCInvoiceModel mvcInvoiceModel = new MVCInvoiceModel();
PurchaseOrderTable purchasemodel = new PurchaseOrderTable();
try
{
PurchaseModel = GetPurchasae(Id);
_PurcchaseDetailList = GetPurchaseDetail(Id);
if (PurchaseModel != null)
{
BillTable billtable = new BillTable();
billtable.CompanyId = PurchaseModel.CompanyId;
billtable.UserId = Convert.ToInt32(Session["LoginUserID"]);
billtable.Bill_ID = PurchaseModel.PurchaseID.ToString();
billtable.PurchaseId = PurchaseModel.PurchaseOrderID;
billtable.VenderId = PurchaseModel.VenderId;
billtable.RefNumber = PurchaseModel.PurchaseRefNumber;
billtable.BillDate = Convert.ToDateTime(PurchaseModel.PurchaseDate);
billtable.BillDueDate = Convert.ToDateTime(PurchaseModel.PurchaseDueDate);
billtable.SubTotal = PurchaseModel.PurchaseSubTotal;
billtable.DiscountAmount = PurchaseModel.PurchaseTotoalAmount;
billtable.TotalAmount = PurchaseModel.PurchaseTotoalAmount;
billtable.CustomerNote = PurchaseModel.PurchaseVenderNote;
billtable.TotalVat6 = PurchaseModel.Vat6;
billtable.TotalVat21 = PurchaseModel.Vat21;
billtable.Status = "accepted";
billtable.Type = StatusEnum.Goods.ToString();
// bill Api
HttpResponseMessage response = GlobalVeriables.WebApiClient.PostAsJsonAsync("AddBill", billtable).Result;
BillTable billviewmodel = response.Content.ReadAsAsync <BillTable>().Result;
if (response.StatusCode == System.Net.HttpStatusCode.OK)
{
if (_PurcchaseDetailList != null)
{
foreach (var item in _PurcchaseDetailList)
{
BillDetailTable billdetailtable = new BillDetailTable();
billdetailtable.BillID = billviewmodel.BilID;
billdetailtable.ItemId = item.PurchaseItemId;
billdetailtable.Description = item.PurchaseDescription;
billdetailtable.Quantity = item.PurchaseQuantity;
billdetailtable.Rate = item.PurchaseItemRate;
billdetailtable.Total = item.PurchaseTotal;
billdetailtable.Type = item.Type;
billdetailtable.RowSubTotal = Convert.ToDouble(item.RowSubTotal);
billdetailtable.Vat = item.PurchaseVatPercentage;
billdetailtable.ServiceDate = item.ServiceDate;
// APIBill
HttpResponseMessage responsses = GlobalVeriables.WebApiClient.PostAsJsonAsync("AddBillDetail", billdetailtable).Result;
if (responsses.StatusCode != System.Net.HttpStatusCode.OK)
{
return(new JsonResult {
Data = new { Status = "Fail", Message = "Fail to Proceed" }
});
}
}
if (UpdateQuatationStation(Id))
{
return(new JsonResult {
Data = new { Status = "Success", Message = "Proceed successfullly" }
});
}
}
}
}
}
catch (Exception)
{
throw;
}
return(new JsonResult {
Data = new { Status = "Success", Message = "Proceed successfullly" }
});
}
