public IActionResult SaveItemReceive(ItemReceive objItemReceive) { if (!String.IsNullOrEmpty(objItemReceive.ReceiveCode_PK)) { objItemReceive.IsNew = false; } else { objItemReceive.IsNew = true; } objItemReceive.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy"); objItemReceive.IsReceived = 1; foreach (ItemReceiveDet objItemReceiveDet in objItemReceive.ItemReceiveDet_VW) { objItemReceiveDet.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy"); objItemReceiveDet.ActionType = objItemReceive.ActionType; objItemReceiveDet.UserCode = objItemReceive.UserCode; objItemReceiveDet.CompanyCode_FK = objItemReceive.CompanyCode_FK; } string Vmsg = _itemReceiveRepository.SaveItemReceive(objItemReceive); return(Ok(new { message = Vmsg })); }
public void Show(ItemReceiveData[] items) { if (items.Length == 0) { return; } if (!isInit) { isInit = true; canvas.sortingOrder = (int)SceneType.RECEIVE_ITEM; } for (int i = 0; i < items.Length; i++) { ItemReceive ir = Instantiate(prefabItemReceive, parentItems); ir.SetData(items[i]); } trFrame.localScale = Vector3.zero; canvas.enabled = true; prevSceneType = _SceneManager.instance.activeSceneType; _SceneManager.instance.activeSceneType = SceneType.RECEIVE_ITEM; trFrame.LeanScale(Vector3.one, _SceneManager.TWEEN_DURATION); }
public string SaveItemReceive(ItemReceive objItemReceive) { int vResult = 0; string vOut = "Exception Occured !"; ArrayList vQueryList = new ArrayList(); objItemReceive.TableName_TBL = Inv_ItemReceive_TBL; SqlConnection connection = _supplierDbContext.GetConn(); connection.Open(); using (SqlTransaction trans = connection.BeginTransaction()) { if (string.IsNullOrEmpty(objItemReceive.ReceiveCode_PK)) { objItemReceive.ReceiveCode_PK = Guid.NewGuid().ToString(); objItemReceive.GRN = _iIDGenCriteriaInfo.GenerateID(trans, objItemReceive, EnumIdCategory.GRN); } vQueryList.Add(GetQuery(objItemReceive)); foreach (ItemReceiveDet objItemReceiveDet in objItemReceive.ItemReceiveDet_VW) { if (string.IsNullOrEmpty(objItemReceiveDet.ReceiveDetCode_PK)) { objItemReceiveDet.ReceiveDetCode_PK = Guid.NewGuid().ToString(); objItemReceiveDet.TableName_TBL = Inv_ItemReceiveDet_TBL; objItemReceiveDet.ReceiveCode_FK = objItemReceive.ReceiveCode_PK; } vQueryList.Add(GetQuery(objItemReceiveDet)); } try { using (SqlCommand command = new SqlCommand("", connection, trans)) { command.CommandType = System.Data.CommandType.Text; foreach (string obj_temp in vQueryList) { command.CommandText = obj_temp; vResult = command.ExecuteNonQuery(); } } if (vResult > 0) { trans.Commit(); vOut = objItemReceive.GRN; } } catch (DbException ex) { trans.Rollback(); throw ex; } finally { connection.Close(); } } return(vOut); }
public void AddItemReceive(Dictionary <string, object> info) { Transform item = Instantiate(ItemReceive) as Transform; gridViewReceive.gameObject.GetComponent <UIGrid>().AddChild(item); item.localScale = new Vector3(1, 1, 1); ItemReceive itemReceive = item.gameObject.GetComponent <ItemReceive>(); itemReceive.SetData(info, this); }
public List <ItemReceive> GetItemReceiveByPO(string pPOCode) { List <ItemReceive> itemReceives = new List <ItemReceive>(); string vComTxt = @"select ReceiveCode,GRN,ReceiveDate,IsApproved,ApprovalAction,POCode,sum(Quantity)Quantity, sum(ReceiveQuantity)ReceiveQuantity,sum(invoice_amt)invoice_amt,sum(VAT_Amount)VAT_Amount ,rate,VATRate,sum(invoice_amt)+sum(VAT_Amount) subtotalamount from( SELECT r.[ReceiveCode] ,[GRN] ,[ReceiveDate] ,r.[IsApproved] ,r.[ApprovalAction] ,[POCode] ,i.Quantity ,e.ReceiveQuantity ,e.ItemCode ,m.ProductID ,m.ProductName ,e.ReceiveQuantity*i.rate invoice_amt ,(i.[VATRate]/100)*(e.ReceiveQuantity*i.rate) VAT_Amount ,i.rate ,i.[VATRate] FROM [dbo].[Inv_ItemReceive] r join [dbo].[PMS_PurchaseOrder] p on r.POCode=p.PurchaseOrderCode join [dbo].[LSP_PMS_QuotationItem] i on i.QuotationCode=p.QuotationCode join [dbo].[Inv_ItemReceiveDet] e on e.ReceiveCode=r.ReceiveCode join [dbo].[PM_Product] m on m.ProductCode=e.ItemCode WHERE isnull(IsInvoiced,0)<>1)a WHERE [POCode]= '" + pPOCode + "'" + "group by ReceiveCode,GRN,ReceiveDate,IsApproved,ApprovalAction,POCode,rate,VATRate"; SqlConnection connection = _supplierDbContext.GetConn(); connection.Open(); SqlDataReader dr; SqlCommand objDbCommand = new SqlCommand(vComTxt, connection); dr = objDbCommand.ExecuteReader(); while (dr.Read()) { ItemReceive item = new ItemReceive(); item.ReceiveCode_PK = dr["ReceiveCode"].ToString(); item.GRN = dr["GRN"].ToString(); item.ReceiveDate = dr.GetDateTime(dr.GetOrdinal("ReceiveDate")).ToString("dd-MM-yyyy"); item.IsApproved = Convert.ToInt16(dr["IsApproved"].ToString()); item.ApprovalAction = Convert.ToInt16(dr["ApprovalAction"].ToString()); item.POCode = dr["POCode"].ToString(); item.TotalQuantity_VW = Convert.ToDecimal(dr["Quantity"].ToString()); item.ReceiveQuantity_VW = Convert.ToDecimal(dr["ReceiveQuantity"].ToString()); item.InvoiceAmount_VW = Convert.ToDecimal(dr["invoice_amt"].ToString()); item.TotalVAT_VW = Convert.ToDecimal(dr["VAT_Amount"].ToString()); item.Rate_VW = Convert.ToDecimal(dr["rate"].ToString()); item.VATRate_VW = Convert.ToDecimal(dr["VATRate"].ToString()); item.SubTotalAmount_VW = Convert.ToDecimal(dr["subtotalamount"].ToString()); itemReceives.Add(item); } dr.Close(); connection.Close(); return(itemReceives); }