public List <BestPriceReturn> GetPrice(RequisitionData request)
{
List <BestPriceReturn> bestPriceReturnList = new List <BestPriceReturn>();
CustomerScore customerScore = GetCustomerScoreAsync(request.CpfCnpjCustomer).Result;
foreach (Product product in request.Products)
{
List <ReturnPrice> returnPriceList = new List <ReturnPrice>();
ReturnPrice baseReturnprice = GetPriceAzulAsync(product.Id.ToString(), request.StoreId.ToString(), customerScore.Score != null).Result;
ReturnPrice priceEncarte = GetPriceEncarte(baseReturnprice, customerScore, request.StoreId);
if (priceEncarte.SalePrice > 0)
{
returnPriceList.Add(priceEncarte);
}
if (customerScore.Score != null)
{
switch ((MedalCode)Enum.Parse(typeof(MedalCode), customerScore.Score.Id))
{
case MedalCode.Ouro:
returnPriceList.Add(GetPriceOuro(baseReturnprice, request.StoreId, MedalCode.Ouro));
break;
case MedalCode.Senior:
returnPriceList.Add(GetPriceSenior(baseReturnprice, request.StoreId, MedalCode.Senior));
break;
case MedalCode.Hapvida:
returnPriceList.Add(GetPriceHapvida(baseReturnprice, request.StoreId, MedalCode.Senior));
break;
default:
returnPriceList.Add(baseReturnprice);
break;
}
}
else
{
returnPriceList.Add(GetPriceNotRegistered(baseReturnprice));
}
bestPriceReturnList.Add(GetBestPrice(returnPriceList));
}
return(bestPriceReturnList);
}
//public PointOfSaleRefData GetRefRequisitionItem(double refRequisition)
//{
// PointOfSaleRefData data = new PointOfSaleRefData();
// DataTable dt = ABB.DAL.Sales.PointOfSaleDAL.GetRefRequisition(refRequisition);
// foreach (DataRow dRow in dt.Rows)
// {
// data.REQUISITION = Convert.ToDouble(dRow["LOID"]);
// data.REQUISITIONCODE = dRow["REQUISITIONCODE"].ToString();
// data.CUSTOMER = Convert.ToDouble(dRow["CUSTOMER"]);
// data.CUSTOMERCODE = dRow["CODE"].ToString();
// data.CUSTOMERDISCOUNT = Convert.ToDouble(dRow["CUSTOMERDISCOUNT"]);
// }
// DataTable dtItem = ABB.DAL.Sales.PointOfSaleDAL.GetRefRequisitionItem(refRequisition);
// foreach (DataRow dRow in dtItem.Rows)
// {
// PointOfSaleRefItemData itemData = new PointOfSaleRefItemData();
// itemData.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
// itemData.BARCODE = dRow["BARCODE"].ToString();
// itemData.DISCOUNT = Convert.ToDouble(dRow["DISCOUNT"]);
// itemData.ISVAT = dRow["ISVAT"].ToString();
// itemData.NAME = dRow["NAME"].ToString();
// itemData.PRICE = Convert.ToDouble(dRow["PRICE"]);
// itemData.QTY = Convert.ToDouble(dRow["QTY"]);
// itemData.REFREQUISITIONITEM = Convert.ToDouble(dRow["LOID"]);
// itemData.UNIT = Convert.ToDouble(dRow["UNIT"]);
// itemData.UNITNAME = dRow["UNITNAME"].ToString();
// data.REFITEM.Add(itemData);
// }
// return data;
//}
public bool ValidateData(RequisitionData data)
{
bool ret = true;
if (data.CUSTOMER == 0)
{
ret = false;
_error = "¡ÃسÒÃкØÅÙ¡¤éÒ";
}
else if (data.REQUISITIONITEM.Count == 0)
{
ret = false;
_error = "¡ÃسÒÃкØÃÒ¡ÒÃÊÔ¹¤éÒ";
}
return ret;
}
private void SetData(RequisitionData data)
{
this.txtCreateBy.Text = data.CREATEBY;
this.txtStatus.Text = data.STATUS;
this.txtStatusName.Text = Appz.GetStatusName(data.STATUS);
this.txtVat.Text = ABB.Flow.SysConfigFlow.GetValue(Constz.ConfigName.VAT);
this.txtCode.Text = data.CODE;
this.dtpReserveDate.Value = data.RESERVEDATE;
this.txtReserveDate.Text = data.RESERVEDATE.ToString(Constz.DateFormat);
this.txtCustomer.Text = data.CUSTOMER.ToString();
SetCustomerDetail(data.CUSTOMER);
this.txtTotal.Text = data.TOTAL.ToString(Constz.DblFormat);
this.txtTotalDiscount.Text = data.TOTDIS.ToString(Constz.DblFormat);
this.txtTotalVat.Text = data.TOTVAT.ToString(Constz.DblFormat);
this.txtGrandTotal.Text = data.GRANDTOT.ToString(Constz.DblFormat);
this.txtReason.Text = data.REASON;
this.txtRemark.Text = data.REMARK;
this.grvSupport.Rows.Clear();
for (int i = 0; i < data.REQUISITIONITEM.Count; ++i)
{
RequisitionItemData itemData = (RequisitionItemData)data.REQUISITIONITEM[i];
DataGridViewRow gRow = (DataGridViewRow)this.grvSupport.Rows[this.grvSupport.NewRowIndex].Clone();
gRow.Cells[indexPRODUCT].Value = itemData.PRODUCT;
gRow.Cells[indexUNIT].Value = itemData.UNIT;
gRow.Cells[indexORDERNO].Value = i + 1;
gRow.Cells[indexBARCODE].Value = itemData.BarCode;
gRow.Cells[indexNAME].Value = itemData.ProductName;
gRow.Cells[indexQTY].Value = itemData.QTY;
gRow.Cells[indexUNITNAME].Value = itemData.UnitName;
gRow.Cells[indexPRICE].Value = itemData.PRICE;
gRow.Cells[indexDISCOUNT].Value = itemData.DISCOUNT;
gRow.Cells[indexNETPRICE].Value = (itemData.PRICE - itemData.DISCOUNT) * itemData.QTY;
gRow.Cells[indexISVAT].Value = (itemData.ISVAT == Constz.VAT.Included.Code);
gRow.Cells[indexNORMALDISCOUNT].Value = itemData.DISCOUNT;
this.grvSupport.Rows.Add(gRow);
}
if (data.STATUS != Constz.Requisition.Status.Waiting.Code)
{
this.btnSave.Visible = false;
this.btnSubmit.Visible = false;
this.btnSearchCustomer.Enabled = false;
this.grvSupport.Columns[indexSEARCH].Visible = false;
Appz.FormatDataGridView(this.grvSupport, false, false, true);
}
}
public IActionResult GetBestPrice([FromBody] RequisitionData request)
{
try
{
List <BestPriceReturn> bestPrice = _productPriceService.GetPrice(request);
if (bestPrice == null)
{
return(NotFound());
}
return(Ok(bestPrice));
}
catch (Exception e)
{
return(BadRequest(e));
}
}
public IActionResult GetBestPrice([FromBody] RequisitionData request)
{
try
{
/*
* Identificar a medalha do cliente.
* Identificar o percentual de desconto da medalha para aquele produto
* Pegar o preço da medalha e preço segmentado caso seja Ouro ou Senior
* Chamar api de preço base caso seja Azul
*/
// List<Product> products = new List<Product>();
// products.Add(new Product { Id = 10 });
// products.Add(new Product { Id = 11 });
// Request req = new Request
// {
// CpfcnpjCustomer = "1234567",
// StoreId = 100,
// Products = products
// };
// var json = new JavaScriptSerializer().Serialize(req);
// Console.WriteLine(json);
List <Price> priceList = new List <Price>();
var data = GetPriceController.GetBestPrice(priceList);
return(Ok(data));
}
catch (Exception ex)
{
_logger.LogError(ex, "Erro ao tentar obter dados");
return(new StatusCodeResult(500));
}
}
private void setStatusRequisition(string active,string status)
{
bool rt = true;
ArrayList arr = new ArrayList();
ReturnSearchFlow csFlow = new ReturnSearchFlow();
RequisitionData dr = new RequisitionData();
dr.CODE = txtRqCode.Text.Trim();
dr.ACTIVE = active.ToString();
dr.STATUS = status.ToString();
arr.Add(dr);
rt = csFlow.UpdateRequisition_Choose(Appz.CurrentUserData.UserID.ToString(), arr);
}
public double InsertRequisition(string UserId, RequisitionData data)
{
Boolean ret = true;
RequisitionDAL oDAL = new RequisitionDAL();
oDAL.REQDATE = Convert.ToDateTime(data.REQDATE);
oDAL.REQUISITIONTYPE = Convert.ToDouble(data.REQUISITIONTYPE);
oDAL.STATUS = data.STATUS.ToString();
oDAL.WAREHOUSE = Convert.ToDouble(data.WAREHOUSE);
oDAL.RESERVEDATE = Convert.ToDateTime(data.RESERVEDATE);
oDAL.ACTIVE = data.ACTIVE.ToString();
ret = oDAL.InsertCurrentData(UserId, null);
if (ret == false)
{
_error = oDAL.ErrorMessage;
return 0;
}
else
return oDAL.LOID;
}
private RequisitionData GetData()
{
RequisitionData data = new RequisitionData();
data.LOID = Convert.ToDouble(this.txtLOID.Text == "" ? "0" : this.txtLOID.Text);
data.ACTIVE = Constz.ActiveStatus.Active;
data.CODE = this.txtCode.Text.Trim();
data.CUSTOMER = Convert.ToDouble(this.txtCustomer.Text == "" ? "0" : this.txtCustomer.Text);
data.GRANDTOT = Convert.ToDouble(this.txtGrandTotal.Text == "" ? "0" : this.txtGrandTotal.Text);
data.STATUS = this.txtStatus.Text.Trim();
data.TOTAL = Convert.ToDouble(this.txtTotal.Text == "" ? "0" : this.txtTotal.Text);
data.TOTDIS = Convert.ToDouble(this.txtTotalDiscount.Text == "" ? "0" : this.txtTotalDiscount.Text);
data.TOTVAT = Convert.ToDouble(this.txtTotalVat.Text == "" ? "0" : this.txtTotalVat.Text);
data.VAT = Convert.ToDouble(this.txtVat.Text == "" ? "0" : this.txtVat.Text);
data.WAREHOUSE = Appz.CurrentUserData.Warehouse;
data.RESERVEDATE = dtpReserveDate.Value.Date;
data.REASON = this.txtReason.Text.Trim();
data.REMARK = this.txtRemark.Text.Trim();
foreach (DataGridViewRow gRow in this.grvSupport.Rows)
{
RequisitionItemData itemData = new RequisitionItemData();
if (!gRow.IsNewRow)
{
itemData.ACTIVE = Constz.ActiveStatus.Active;
itemData.DISCOUNT = Convert.ToDouble(gRow.Cells[indexDISCOUNT].Value);
itemData.ISVAT = (Convert.ToBoolean(gRow.Cells[indexISVAT].Value) ? Constz.VAT.Included.Code : Constz.VAT.NotIncluded.Code);
itemData.NETPRICE = Convert.ToDouble(gRow.Cells[indexNETPRICE].Value);
itemData.PRICE = Convert.ToDouble(gRow.Cells[indexPRICE].Value);
itemData.PRODUCT = Convert.ToDouble(gRow.Cells[indexPRODUCT].Value);
itemData.QTY = Convert.ToDouble(gRow.Cells[indexQTY].Value);
itemData.UNIT = Convert.ToDouble(gRow.Cells[indexUNIT].Value);
data.REQUISITIONITEM.Add(itemData);
}
}
return data;
}
public bool DeleteRequisition(RequisitionData data)
{
bool ret = true;
ret = V_SUPPORT_LIST_DAL.DeleteRequisition(data);
return ret;
}
private void btnDelete_Click(object sender, EventArgs e)
{
bool ret = true;
if (Appz.OpenQuestionDialog("µéͧ¡ÒÃźÃÒ¡ÒÃãªèËÃ×ÍäÁè?") == DialogResult.OK)
{
ArrayList arrLOID = new ArrayList();
ArrayList arr = new ArrayList();
SupportSearchFlow csFlow = new SupportSearchFlow();
for (int i = 0; i < grvSupportSearch.Rows.Count; i++)
{
DataGridViewCheckBoxCell maCell = (DataGridViewCheckBoxCell)this.grvSupportSearch.Rows[i].Cells["CHKAPPROVE"];
if (maCell.FormattedValue.Equals(true))
{
RequisitionData dr = new RequisitionData();
arrLOID.Add(grvSupportSearch.Rows[i].Cells["RQLOID"].Value.ToString());
arr.Add(dr);
}
}
ret = csFlow.DeleteReq_ReqItemData(arrLOID);
if (ret == true)
{
Appz.OpenInformationDialog("źÃÒ¡ÒÃàÃÕºÃéÍÂ");
}
else
{
Appz.OpenWarningDialog(csFlow.ErrorMessage);
}
LoadData();
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
bool ret = true;
if (Appz.OpenQuestionDialog("µéͧ¡ÒÃÊ觽èÒ¢ÒÂãªèËÃ×ÍäÁè?") == DialogResult.OK)
{
ArrayList arrLOID = new ArrayList();
ArrayList arr = new ArrayList();
SupportSearchFlow csFlow = new SupportSearchFlow();
for (int i = 0; i < grvSupportSearch.Rows.Count; i++)
{
DataGridViewCheckBoxCell maCell = (DataGridViewCheckBoxCell)this.grvSupportSearch.Rows[i].Cells["CHKAPPROVE"];
if (maCell.FormattedValue.Equals(true))
{
RequisitionData dr = new RequisitionData();
arrLOID.Add(grvSupportSearch.Rows[i].Cells["RQLOID"].Value.ToString());
dr.ACTIVE = "1";
dr.STATUS = "AP";
arr.Add(dr);
}
}
ret = csFlow.RequisitionApprove(Appz.CurrentUserData.UserID, arrLOID);
if (ret == true)
{
Appz.OpenInformationDialog("Ê觽èÒ¢ÒÂàÃÕºÃéÍÂ");
}
else
{
Appz.OpenWarningDialog(csFlow.ErrorMessage);
}
LoadData();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
bool ret = true;
bool rt = true;
if (Appz.OpenQuestionDialog("µéͧ¡ÒÃźÃÒ¡ÒÃãªèËÃ×ÍäÁè?") == DialogResult.OK)
{
ArrayList arrLOID = new ArrayList();
ArrayList arr = new ArrayList();
ReturnSearchFlow csFlow = new ReturnSearchFlow();
for (int i = 0; i < grvReturnSearch.Rows.Count; i++)
{
DataGridViewCheckBoxCell maCell = (DataGridViewCheckBoxCell)this.grvReturnSearch.Rows[i].Cells["CHKAPPROVE"];
if (maCell.FormattedValue.Equals(true))
{
RequisitionData dr = new RequisitionData();
arrLOID.Add(grvReturnSearch.Rows[i].Cells["SILOID"].Value.ToString());
// arr.Add(grvReturnSearch.Rows[i].Cells["RQCODE"].Value.ToString());
dr.CODE = grvReturnSearch.Rows[i].Cells["RQCODE"].Value.ToString();
dr.ACTIVE = "1";
dr.STATUS = "AP";
arr.Add(dr);
}
}
ret = csFlow.DeleteStockIn_StockInitemData(Appz.CurrentUserData.UserID, arrLOID);
if (ret == true)
{
rt = csFlow.UpdateRequisition_Choose(Appz.CurrentUserData.UserID.ToString(), arr);
Appz.OpenInformationDialog("źÃÒ¡ÒÃàÃÕºÃéÍÂ");
}
else
{
Appz.OpenWarningDialog(csFlow.ErrorMessage);
}
LoadData();
}
}
private void btnNew_Click(object sender, EventArgs e)
{
if (Appz.OpenQuestionDialog("µéͧ¡ÒÃÊÃéÒ§ÃÒ¡ÒÃãËÁèãªèËÃ×ÍäÁè") == DialogResult.OK)
{
SupportSearchFlow csFlow = new SupportSearchFlow();
RequisitionData csData = new RequisitionData();
string str_today = getDateToday();
csData.REQUISITIONTYPE = Constz.Requisition.RequisitionType.REQ04;
csData.STATUS = Constz.Requisition.Status.Waiting.Code;
csData.REQDATE = Convert.ToDateTime(str_today);
csData.WAREHOUSE = Appz.CurrentUserData.Warehouse;
csData.RESERVEDATE = Convert.ToDateTime(str_today);
csData.ACTIVE = Constz.ActiveStatus.Active;
csData.VAT = Convert.ToDouble(ABB.Flow.SysConfigFlow.GetValue(Constz.ConfigName.VAT));
double loid;
//insert Requisition
loid = csFlow.InsertRequisition(Appz.CurrentUserData.UserID.ToString(), csData);
if (loid == 0)
MessageBox.Show(csFlow.ErrorMessage);
else
Openfrm(loid);
LoadData();
}
}
public bool UpdateRequisition(string userID, RequisitionData data)
{
bool ret = true;
V_SUPPORT_LIST_DAL v_spport_listt_dal = new V_SUPPORT_LIST_DAL();
ret = v_spport_listt_dal.UpdateRequsitionData(userID.ToString(), data);
if (ret != true)
{
_error = v_spport_listt_dal.ErrorMessage;
return ret;
}
else
{
RequisitionDAL rDAL = new RequisitionDAL();
bool rr = rDAL.CutStockRequisition(data.LOID, userID, null);
return ret;
}
}
public bool UpdateRequsitionData(string UserID, RequisitionData data)
{
bool ret = true;
RequisitionDAL oDAL = new RequisitionDAL();
oDAL.GetDataByLOID(data.LOID,null);
oDAL.CUSTOMER = Convert.ToDouble(data.CUSTOMER);
oDAL.TOTAL = Convert.ToDouble(data.TOTAL);
oDAL.REASON = data.REASON.ToString();
oDAL.REMARK = data.REMARK.ToString();
ret = oDAL.UpdateCurrentData(UserID, null);
if (ret == false)
{
_error = oDAL.ErrorMessage;
return ret;
}
else
return ret;
}
public RequisitionData GetData(double loid)
{
RequisitionData data = new RequisitionData();
if (DALObj.GetDataByLOID(loid, null))
{
data.CODE = DALObj.CODE;
data.ACTIVE = DALObj.ACTIVE;
data.CUSTOMER = DALObj.CUSTOMER;
data.GRANDTOT = DALObj.GRANDTOT;
data.STATUS = DALObj.STATUS;
data.TOTAL = DALObj.TOTAL;
data.TOTDIS = DALObj.TOTDIS;
data.TOTVAT = DALObj.TOTVAT;
data.VAT = DALObj.VAT;
data.WAREHOUSE = DALObj.WAREHOUSE;
data.RESERVEDATE = DALObj.RESERVEDATE;
data.CREATEBY = DALObj.CREATEBY;
data.REASON = DALObj.REASON;
data.REMARK = DALObj.REMARK;
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
DataTable dt = GetRequisitionItem(loid);
foreach (DataRow dRow in dt.Rows)
{
RequisitionItemData itemData = new RequisitionItemData();
itemData.BarCode = dRow["BARCODE"].ToString();
itemData.DISCOUNT = Convert.ToDouble(dRow["DISCOUNT"]);
itemData.ISVAT = dRow["ISVAT"].ToString();
itemData.NETPRICE = Convert.ToDouble(dRow["NETPRICE"]);
itemData.PRICE = Convert.ToDouble(dRow["PRICE"]);
itemData.PRODUCT = Convert.ToDouble(dRow["PRODUCT"]);
itemData.QTY = Convert.ToDouble(dRow["QTY"]);
itemData.ProductName = dRow["NAME"].ToString();
itemData.UNIT = Convert.ToDouble(dRow["UNIT"]);
itemData.UnitName = dRow["UNITNAME"].ToString();
data.REQUISITIONITEM.Add(itemData);
}
}
return data;
}
public static bool DeleteRequisition(RequisitionData data)
{
Boolean ret = true;
RequisitionDAL oDAL = new RequisitionDAL();
oDAL.GetDataByLOID(data.LOID, null);
ret = oDAL.DeleteCurrentData(null);
return ret;
}
public bool CommitData(string userID, RequisitionData data)
{
bool ret = true;
if (ValidateData(data))
{
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
_dal = new RequisitionDAL();
DALObj.OnDB = false;
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
if (DALObj.STATUS == Constz.Requisition.Status.Waiting.Code)
{
data.STATUS = Constz.Requisition.Status.Approved.Code;
UpdateData(userID, data, obj.zTrans);
_LOID = DALObj.LOID;
ret = DALObj.CutStockRequisition(DALObj.LOID, userID, obj.zTrans);
if (!ret) throw new ApplicationException(DALObj.ErrorMessage);
}
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
_error = ex.Message;
}
}
else
ret = false;
return ret;
}
public bool UpdateData(string userID, RequisitionData data)
{
bool ret = true;
if (ValidateData(data))
{
OracleDBObj obj = new OracleDBObj();
obj.CreateConnection();
obj.CreateTransaction();
try
{
_dal = new RequisitionDAL();
DALObj.OnDB = false;
DALObj.GetDataByLOID(data.LOID, obj.zTrans);
UpdateData(userID, data, obj.zTrans);
_LOID = DALObj.LOID;
obj.zTrans.Commit();
obj.CloseConnection();
}
catch (Exception ex)
{
obj.zTrans.Rollback();
obj.CloseConnection();
ret = false;
_error = ex.Message;
}
}
else
ret = false;
return ret;
}
private void UpdateData(string userID, RequisitionData data, OracleTransaction trans)
{
bool ret = true;
DALObj.REQUISITIONTYPE = Constz.Requisition.RequisitionType.REQ04;
DALObj.ACTIVE = data.ACTIVE;
DALObj.CUSTOMER = data.CUSTOMER;
DALObj.GRANDTOT = data.GRANDTOT;
DALObj.STATUS = data.STATUS;
DALObj.TOTAL = data.TOTAL;
DALObj.TOTDIS = data.TOTDIS;
DALObj.TOTVAT = data.TOTVAT;
DALObj.VAT = data.VAT;
DALObj.WAREHOUSE = data.WAREHOUSE;
DALObj.RESERVEDATE = data.RESERVEDATE;
DALObj.REMARK = data.REMARK;
DALObj.REASON = data.REASON;
if (DALObj.OnDB)
ret = DALObj.UpdateCurrentData(userID, trans);
else
{
DALObj.REQDATE = data.RESERVEDATE;
ret = DALObj.InsertCurrentData(userID, trans);
}
if (!ret)
{
throw new ApplicationException(DALObj.ErrorMessage);
}
RequisitionItemDAL itemDAL = new RequisitionItemDAL();
itemDAL.DeleteDataByRequisition(data.LOID, trans);
for (Int16 i = 0; i < data.REQUISITIONITEM.Count; ++i)
{
RequisitionItemData item = (RequisitionItemData)data.REQUISITIONITEM[i];
itemDAL.ACTIVE = item.ACTIVE;
itemDAL.DISCOUNT = item.DISCOUNT;
itemDAL.DUEDATE = item.DUEDATE;
itemDAL.NETPRICE = item.NETPRICE;
itemDAL.PRODUCT = item.PRODUCT;
itemDAL.QTY = item.QTY;
itemDAL.PRICE = item.PRICE;
itemDAL.REQUISITION = DALObj.LOID;
itemDAL.UNIT = item.UNIT;
itemDAL.ISVAT = item.ISVAT;
itemDAL.OnDB = false;
ret = itemDAL.InsertCurrentData(userID, trans);
if (!ret) throw new ApplicationException(itemDAL.ErrorMessage);
}
}
