private InvoiceDetailModel InitEditPanel() { InvoiceDetailModel detail = new InvoiceDetailModel(); initializareComboBox(); foreach (DataGridViewRow row in dataGridViewDetalii.SelectedRows) { tbAmount.Text = row.Cells[5].Value.ToString(); detail.InvoiceDetailId = Convert.ToInt32(row.Cells[0].Value.ToString()); tbObservations.Text = row.Cells[6].Value.ToString(); tbPrice.Text = row.Cells[4].Value.ToString(); tbQtty.Text = row.Cells[3].Value.ToString(); tbAmount.Text = ((Convert.ToDecimal(row.Cells[4].Value.ToString())) * (Convert.ToDecimal(row.Cells[3].Value.ToString()))).ToString(); DataTable items = new DataTable(); BLItems blItems = new BLItems(); try { items = blItems.GetItemNameById(Convert.ToInt32(row.Cells[2].Value.ToString())); cbItems.Text = items.Rows[0]["ItemName"].ToString(); } catch (Exception ex) { Console.WriteLine("Eroare INIT PANEL!! " + ex.Message); } } return(detail); }
public void initializareComboBox() { BLItems blItems = new BLItems(); DataTable articole = blItems.GetItems(); cbItems.DataSource = articole; cbItems.DisplayMember = "ItemName"; cbItems.ValueMember = "ItemId"; }
private void ClearFields() { this.created = DateTime.MinValue; this.uid = string.Empty; this.saveInfo = false; this.creditCard = null; this.billingAddress = null; this.shippingAddress = null; this.shoppingCart = null; this.category = null; this.billingAddress = new BLAddress(); this.shippingAddress = new BLAddress(); this.shoppingCart = new BLShoppingCart(); this.creditCard = new BLCreditCard(); this.items = new BLItems(); this.orders = new BLOrders(); this.category = new BLCategory(); this.item = new BLItem(); }
public void Retrieve() { DataSet dsitems; //////////////////// dsitems= GetOrgList( , "S", "get_Orgs", this.ID, ""); dsKnow = r.get_orgKnow("get_orgKnow", "S", this.ID, ""); if( this.uid.Length > 0 ) dsitems = DALCCustomer.GetItemBySessionID(this.uid); else dsitems = DALCCustomer.GetItem(this.id); if( dsitems.Tables.Count > 0 && dsitems.Tables[0].Rows.Count > 0) { this.id = Convert.ToInt32( dsitems.Tables["Customer"].Rows[0]["ID"] ); this.uid = Convert.ToString( dsitems.Tables["Customer"].Rows[0]["SessionID"] ); this.created = Convert.ToDateTime( dsitems.Tables["Customer"].Rows[0]["Created"] ); this.saveInfo = Convert.ToBoolean( dsitems.Tables["Customer"].Rows[0]["SaveInfo"] ); int creditCardID = Convert.ToInt32( dsitems.Tables["Customer"].Rows[0]["CreditCardInfoID"] ); int billingInfoID = Convert.ToInt32( dsitems.Tables["Customer"].Rows[0]["BillingAddressID"] ); int shippingInfoID = Convert.ToInt32( dsitems.Tables["Customer"].Rows[0]["ShippingAddressID"] ); if( creditCardID > 0) { creditCard = new BLCreditCard(); creditCard.ID = creditCardID; creditCard.Retrieve(); } if( billingInfoID > 0 ) { billingAddress = new BLAddress(); billingAddress.ID = billingInfoID; billingAddress.Retrieve(); } if( shippingInfoID > 0 ) { shippingAddress = new BLAddress(); shippingAddress.ID = shippingInfoID; shippingAddress.Retrieve(); } if (shoppingCart == null) { shoppingCart = new BLShoppingCart(); } shoppingCart.CustomerID = this.id; shoppingCart.Retrieve(); if(items == null) { items = new BLItems(); } items.OrgID = this.id; items.Retrieve(); } else { this.id = 0; ClearFields(); } }
/// public static DataSet get_watch(string commandName, string prm, int auctionid, int orgID, int buyerID) public DataSet fillWatch(BLItems items) { string commandName="get_watch"; string prm ="B"; int auctionid = items.AuctionID;// BLItems.AuctionID; int orgID = items.AuctionOrgID;//.OrgID;// BLOrganization.orgID; int buyerID = items.buyerID;// BLCustomer.buyerID; DataSet ds = new DataSet(); ds = items.UpdateWatch(prm, commandName, orgID, buyerID, auctionid); return ds; }
//public static DataSet fillcarts() //{ // DataSet ds = new DataSet(); // ds= messages.cust.ShoppingCart.fillCart(); // return ds; //} public void setWatch(BLItems items) { string commandName = "get_watch"; string prm = "I"; int auctionid = items.AuctionID;// BLItems.AuctionID; int orgID = items.OrgID;// BLOrganization.orgID; int buyerID = items.buyerID;// BLCustomer.buyerID; DataSet ds = new DataSet(); /// messages.orgs_.Orgitems.UpdateWatch(prm, commandName, orgID, buyerID, auctionid); items.UpdateWatch(prm, commandName, orgID, buyerID, auctionid); }
public int GetOrgbyAuctionID(BLItems items, int AuctionID ) { DataSet ds = new DataSet(); int shippngCost = 0; // int orgid = 0; String title = ""; int quantity = 0; //// catid = messages.blitem.catID; String location = ""; String orgPaypal = ""; String description = ""; String condition = ""; //String shippngCost = status; DateTime startDate = DateTime.Today; DateTime endDate = DateTime.Today; DateTime soldDate = DateTime.Today; String commandName = "get_Items"; String prm = "U"; int credits = 1; // string commandName; ///orgStatus = "";// drplstEmailSts.SelectedValue.ToString(); ds = r.getItems(commandName, prm,0, 0, 0, 0, location, description, quantity, shippngCost, condition, title, startDate, endDate, soldDate, "",AuctionID ); if(ds.Tables.Count>0 && ds.Tables[0].Rows.Count>0 ) { int orgid= Convert.ToInt16( ds.Tables[0].Rows[0][0]) ; // messages.orgs_.ID = orgid; // this.OrgID = orgid; items.AuctionOrgID = orgid; } return orgID; }