public override int GetHashCode() { int hash = 1; if (Id.Length != 0) { hash ^= Id.GetHashCode(); } if (Length != 0D) { hash ^= pbc::ProtobufEqualityComparers.BitwiseDoubleEqualityComparer.GetHashCode(Length); } if (Width != 0D) { hash ^= pbc::ProtobufEqualityComparers.BitwiseDoubleEqualityComparer.GetHashCode(Width); } if (Height != 0D) { hash ^= pbc::ProtobufEqualityComparers.BitwiseDoubleEqualityComparer.GetHashCode(Height); } if (Qty != 0) { hash ^= Qty.GetHashCode(); } if (Weight != 0D) { hash ^= pbc::ProtobufEqualityComparers.BitwiseDoubleEqualityComparer.GetHashCode(Weight); } if (_unknownFields != null) { hash ^= _unknownFields.GetHashCode(); } return(hash); }
public async Task <JsonResult> BulkUpdate(Qty model) { string userId = User.Identity.GetUserId(); await _cart.BulkQuantityUpdateItemForCart(Guid.Parse(model.id), userId, int.Parse(model.qty)); return(Json("Proccess completed successfuly", JsonRequestBehavior.AllowGet)); }
/// <summary> /// Returns true if OrderItem instances are equal /// </summary> /// <param name="other">Instance of OrderItem to be compared</param> /// <returns>Boolean</returns> public bool Equals(OrderItem other) { if (ReferenceEquals(null, other)) { return(false); } if (ReferenceEquals(this, other)) { return(true); } return (( ItemName == other.ItemName || ItemName != null && ItemName.Equals(other.ItemName) ) && ( Qty == other.Qty || Qty.Equals(other.Qty) ) && ( UnitPrice.Equals(other.UnitPrice) ) && ( Cost.Equals(other.Cost) )); }
public ActionResult Catalogue([Bind(Include = "testID,qty")] Qty qty) { if (ModelState.IsValid) { return(RedirectToAction("Index")); } return(View()); }
public void combineGroup(Group g) /*將單一group合併到本group*/ { //確認g是單一Group if (g.Qty.Count > 1) { //Globals.ThisAddIn.odiMsgOut("[Error] Can't comine complex group, check code!"); MessageBox.Show("[Error] Can't comine complex group, check code!"); return; } else { //合併main source資料 Qty.Add(g.Qty[0]); ProjectName.Add(g.ProjectName[0]); SCHVersion.Add(g.SCHVersion[0]); BOMVersion.Add(g.BOMVersion[0]); BOMKey.Add(g.getBomKey()); //歷遍目前AVL,找到相同的合併,並且從g移除 bool foundAVLing; foreach (var i in AVL) { foundAVLing = g.AVL.TryGetValue(i.Key, out Item gi); i.Value.ProjectName.Add(g.ProjectName[0]); //不論有沒有找到,都要增加project欄位 i.Value.SCHVersion.Add(g.SCHVersion[0]); i.Value.BOMVersion.Add(g.BOMVersion[0]); i.Value.BOMKey.Add(g.getBomKey()); if (foundAVLing) { i.Value.Qty.Add(gi.Qty[0]); g.AVL.Remove(i.Key); } else { i.Value.Qty.Add(0); } } //如果g還有剩下(新的)AVL item,則加入目前的AVL dictionary, 並且補足其前面的空白欄位 if (g.AVL.Count > 0) { foreach (var j in g.AVL) { j.Value.ProjectName = ProjectName; j.Value.SCHVersion = SCHVersion; j.Value.BOMVersion = BOMVersion; j.Value.BOMKey = BOMKey; for (int k = 0; k < Qty.Count() - 1; k++) { j.Value.Qty.Insert(0, 0); } AVL.Add(j.Key, j.Value); } } } }
/* * CONVERTS TO STRING (to later be displayed on a listbox)*/ public override string ToString() { if (Name.Length < 8) { return(ID.ToString() + "\t\t" + Name + "\t\t\t" + Qty.ToString() + '\t' + QtyReq.ToString()); } else { return(ID.ToString() + "\t\t" + Name + "\t\t" + Qty.ToString() + '\t' + QtyReq.ToString()); } }
public virtual int _GetUniqueIdentifier() { var hashCode = 399326290; hashCode = hashCode * -1521134295 + (TransportDetailsID?.GetHashCode() ?? 0); hashCode = hashCode * -1521134295 + (EventID?.GetHashCode() ?? 0); hashCode = hashCode * -1521134295 + (Qty?.GetHashCode() ?? 0); hashCode = hashCode * -1521134295 + (ExtDateStart?.GetHashCode() ?? 0); hashCode = hashCode * -1521134295 + (ExtTimeStart?.GetHashCode() ?? 0); hashCode = hashCode * -1521134295 + (ExtTimeAction?.GetHashCode() ?? 0); hashCode = hashCode * -1521134295 + (RealDateStart?.GetHashCode() ?? 0); hashCode = hashCode * -1521134295 + (RealTimeStart?.GetHashCode() ?? 0); hashCode = hashCode * -1521134295 + (RealTimeAction?.GetHashCode() ?? 0); return(hashCode); }
private async void InsertIntoCart(int?obj) { try { if (obj != null) { var item = ListPro.SingleOrDefault(t => t.ProductID == (int)obj); if (item != null) { if (!string.IsNullOrEmpty(Qty) && Qty.IsNum()) { if (ListOD.SingleOrDefault(t => t.ProductID == (int)obj) == null) { if (Convert.ToInt32(Qty) <= RestQty && RestQty >= 0) { var ProOD = new ProductODModel() { ProductID = _selectedPro.ProductID, Name = _selectedPro.Name, }; ProOD.OrderQty = Convert.ToInt32(Qty); ProOD.UnitPrice = (double)_selectedPro.UnitOnOrder; ProOD.StoreID = SelectedSto.StoreID; Subtotal += (double)_selectedPro.UnitOnOrder * Convert.ToInt32(Qty); ListOD.Add(ProOD); } else { MessageBox.Show("số lượng phải nhỏ hơn hoặc bằng số lượng hiện tại", "Thông Báo", MessageBoxButton.OK, MessageBoxImage.Warning); } } else { MessageBox.Show("Đã Tồn Tại Trong Giỏ Hàng", "Thông Báo", MessageBoxButton.OK, MessageBoxImage.Warning); } } else { MessageBox.Show("Có Lỗi - Số Lượng Phải Là Số", "Thông Báo", MessageBoxButton.OK, MessageBoxImage.Warning); } } } } catch { MessageBox.Show("Có Lỗi", "Thông Báo", MessageBoxButton.OK, MessageBoxImage.Warning); } }
private void Form2_Load(object sender, EventArgs e) { PName.Text = "Select-an-option"; Qty.Clear(); Rate.Clear(); SqlDataAdapter da = new SqlDataAdapter("select Product_Name from Add_Product ", con); DataSet ds = new DataSet(); da.Fill(ds, "login"); int index = 0; for (index = 0; index < ds.Tables[0].Rows.Count; index++) { PName.Items.Add(ds.Tables[0].Rows[index][0]); } }
private string GetSeperatedParameters() { return(OrgNo + ";" + FeeNo + ";" + RegNo + ";" + PriceCode + ";" + PriceName + ";" + StartDate + ";" + StartTime + ";" + EndDate + ";" + EndTime + ";" + Qty.ToString() + ";" + TakeTime + ";" + Id + ";" + Operation + ";" + FilePath + ";" + FileName); }
public static List <Qty> GetQtys(int GSETypeId) { List <Qty> lstQty = new List <Qty>(); //Accessing DB Layer DbCommand dbCommand = db.GetStoredProcCommand("prSelQtysByGSETypeId"); db.AddInParameter(dbCommand, "GSETypeID", DbType.String, GSETypeId); IDataReader dr = null; try { // Execute command dr = db.ExecuteReader(dbCommand); //Set Output and add to the list while (dr.Read()) { Qty objQty = new Qty(); objQty.QtyId = dr["QuantityId"].ToString(); objQty.Description = dr["Description"].ToString(); objQty.GSETypeId = Convert.ToInt32(dr["GSETypeId"]); objQty.MetricUnitDescription = dr["MetricUnitDescription"].ToString(); if (!String.IsNullOrEmpty(dr["ImperialUnitDescription"].ToString())) { objQty.ImperialUnitDescription = dr["ImperialUnitDescription"].ToString(); objQty.MetricConversionRatio = Convert.ToSingle(dr["MetricConversionRatio"]); } lstQty.Add(objQty); } } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { dr.Close(); } return(lstQty); }
/// <summary> /// Returns true if Position instances are equal /// </summary> /// <param name="other">Instance of Position to be compared</param> /// <returns>Boolean</returns> public bool Equals(Position other) { if (ReferenceEquals(null, other)) { return(false); } if (ReferenceEquals(this, other)) { return(true); } return (( Id == other.Id || Id != null && Id.Equals(other.Id) ) && ( Instrument == other.Instrument || Instrument != null && Instrument.Equals(other.Instrument) ) && ( Qty == other.Qty || Qty != null && Qty.Equals(other.Qty) ) && ( Side == other.Side || Side != null && Side.Equals(other.Side) ) && ( AvgPrice == other.AvgPrice || AvgPrice != null && AvgPrice.Equals(other.AvgPrice) ) && ( UnrealizedPl == other.UnrealizedPl || UnrealizedPl != null && UnrealizedPl.Equals(other.UnrealizedPl) )); }
/// <summary> /// Returns true if Execution instances are equal /// </summary> /// <param name="other">Instance of Execution to be compared</param> /// <returns>Boolean</returns> public bool Equals(Execution other) { if (ReferenceEquals(null, other)) { return(false); } if (ReferenceEquals(this, other)) { return(true); } return (( Id == other.Id || Id != null && Id.Equals(other.Id) ) && ( Instrument == other.Instrument || Instrument != null && Instrument.Equals(other.Instrument) ) && ( Price == other.Price || Price != null && Price.Equals(other.Price) ) && ( Time == other.Time || Time != null && Time.Equals(other.Time) ) && ( Qty == other.Qty || Qty != null && Qty.Equals(other.Qty) ) && ( Side == other.Side || Side != null && Side.Equals(other.Side) )); }
protected void ProductName_TextChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ToString()); SqlCommand cmd = new SqlCommand("", con); cmd.CommandText = "select *,dbo.GETAVLQTY(productId,@FrenchiseID)as AQTY from ProductRepurchase where ProductName = @ProductName and Status != 1 "; cmd.Parameters.AddWithValue("@productName", ProductName.Text); cmd.Parameters.AddWithValue("@FrenchiseID", ConfigurationManager.AppSettings["FrenchiseID"].ToString()); con.Open(); cmd.CommandTimeout = 0; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { PID.Value = dr["ProductID"].ToString(); ProductCode.Text = dr["ProductCode"].ToString(); MRP.Text = dr["MRP"].ToString().Replace(".0000", ".00"); SpecialDiscount = Convert.ToDecimal(dr["DiscountAmount"].ToString().Replace(".0000", ".00")); SPDiscount.Text = SpecialDiscount.ToString(); DP.Text = dr["SalesAmount"].ToString().Replace(".0000", ".00"); BV.Text = dr["BV"].ToString(); Tax.Text = dr["vat"].ToString(); CashBack.Text = dr["CashBack"].ToString(); txtselcashback.Text = dr["SelfCashBack"].ToString(); CGST.Text = string.Format("{0:f2}", decimal.Parse(dr["CGST"].ToString())); SGST.Text = string.Format("{0:f2}", decimal.Parse(dr["SGST"].ToString())); IGST.Text = string.Format("{0:f2}", decimal.Parse(dr["IGST"].ToString())); Cess.Text = string.Format("{0:f2}", decimal.Parse(dr["Cess"].ToString())); Qty.Text = "1"; // Amount.Text = string.Format("{0:f2}", (decimal.Parse(Qty.Text) * decimal.Parse(DP.Text))); //Amount.Text = string.Format("{0:f2}", (decimal.Parse(DP.Text) - decimal.Parse(SPDiscount.Text))); Amount.Text = string.Format("{0:f2}", (decimal.Parse(DP.Text) * (decimal.Parse(Qty.Text)) - decimal.Parse(SPDiscount.Text))); // txtAVLQTY.Text = dr["AQTY"].ToString(); //imageload.HRef = dr["ImageUrl"].ToString(); } dr.Close(); con.Close(); Qty.Focus(); }
public string PrintTotal() { StringBuilder line = new StringBuilder(); if (IsImport) { line.Append("Imported "); } line.Append(Description + ": "); if (Qty > 1) { line.Append($"{TotalCost()} ({Qty.ToString()} @ {TotalPrice()})"); } else { line.Append(TotalCost()); } return(line.ToString()); }
public override string ToString() { string str = ""; str += "&idserver=\"" + IDServer.ToString() + "\""; if (IDUser != -1) { str += "&iduser=\"" + IDUser.ToString() + "\""; } if (IDCategory != 0) { str += "&idcategory=\"" + IDCategory.ToString() + "\""; } if (IDMealUnit != 0) { str += "&idmealunit=\"" + IDServerMealUnit.ToString() + "\""; } if (Qty != 0) { str += "&qty=\"" + Qty.ToString() + "\""; } if (MealDate != null) { str += "&mealdate=\"" + MealDate.ToString("yyyy-MM-dd HH:mm:ss") + "\""; } if (InsertDate != null) { str += "&insertdate=\"" + InsertDate.ToString("yyyy-MM-dd HH:mm:ss") + "\""; } if (UpdateDate != null) { str += "&updatedate=\"" + UpdateDate.ToString("yyyy-MM-dd HH:mm:ss") + "\""; } return(str.Substring(1)); }
private async void discounttxt_LostFocus(object sender, RoutedEventArgs e) { MainWindow mainWindow = (MainWindow)Application.Current.MainWindow; if (!string.IsNullOrEmpty(Price.Text) && !string.IsNullOrEmpty(Qty.Text)) { calculateTotal(); } else { if (string.IsNullOrEmpty(Qty.Text)) { await mainWindow.ShowMessageAsync("Please Enter Qunatity", ""); Qty.Focus(); } else if (string.IsNullOrEmpty(Price.Text)) { await mainWindow.ShowMessageAsync("Please Enter Unitprice", ""); Price.Focus(); } } }
/// <summary> /// 加载页面数据 /// </summary> private void LoadData() { txtKeyId.Text = KeyId; txtFMarginEnd.Text = Qty.ToString(CultureInfo.InvariantCulture); txtFQty.Text = Qty.ToString(CultureInfo.InvariantCulture); switch (Actions) { case WebAction.Add: break; case WebAction.Edit: if (To != null) { txtFMarginEnd.Text = To.XMarginEnd.ToString(); ddlBill.SelectedValue = To.XBill; tbxFVehicleNum.Text = To.XVehicleNum; txtFQty.Text = To.XQty.ToString(); txtFMemo.Text = To.XMemo; } break; } }
public override int GetHashCode() { return(Qty.GetHashCode() ^ SellItem.GetHashCode()); }
private void Newstock() { divBack.Visible = true; decimal Qty; DataTable dtCollect = new DataTable(); dtCollect.Columns.Add("CreatedDate", typeof(DateTime)); dtCollect.Columns.Add("Qty", typeof(decimal)); dtCollect.Columns.Add("Productname"); dtCollect.Columns.Add("BQty", typeof(decimal)); dtCollect.Columns.Add("Balance", typeof(decimal)); decimal BQty = 0; string[] code = ddlSeasonYear.Text.Split(new string[] { "20" }, StringSplitOptions.None); DataTable dtUniqeCollectionDates = reportObj.GetCollectionDates(Convert.ToInt32(ddlProduct.SelectedValue), code[1].ToString()); DataTable dt = reportObj.GetNewallcollectionList(ddlProduct.SelectedValue, code[1].ToString()); foreach (DataRow Date in dtUniqeCollectionDates.Rows) { foreach (DataRow item in dt.Rows) { if (Date["CreatedDate"].ToString() == item["CreatedDate"].ToString()) { DataRow drNew = dtCollect.NewRow(); if (item["CollectionQty"].ToString().Contains("@")) { string[] CollectionQty = item["CollectionQty"].ToString().Split('@'); } else { string[] CollectionQty1 = item["CollectionQty"].ToString().Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries); Qty = 0; for (int i = 0; i < CollectionQty1.Length; i++) { Qty = Qty + Convert.ToDecimal(CollectionQty1[i].ToString()); } drNew["Qty"] = Qty.ToString(); } drNew["ProductName"] = item["ProductName"].ToString(); drNew["CreatedDate"] = Convert.ToDateTime(item["CreatedDate"]); drNew["BQty"] = "0.00"; drNew["Balance"] = "0.00"; dtCollect.Rows.Add(drNew); } } } DataTable dtblend1 = reportObj.GetSelectedBlendQty(code[1].ToString(), Convert.ToInt32(ddlProduct.SelectedValue)); for (int i = 0; i < dtblend1.Rows.Count; i++) { DataTable dtDate1 = reportObj.GetSelectedCollectionDate(dtblend1.Rows[i]["createddate"].ToString(), Convert.ToInt32(ddlProduct.SelectedValue)); if (dtblend1.Rows.Count > 0) { DataRow drNew1 = dtCollect.NewRow(); decimal BlendQty = 0; if (dtDate1.Rows.Count > 0) { if (dtDate1.Rows[0]["createddate"].ToString() == dtblend1.Rows[i]["createddate"].ToString()) { BlendQty = BlendQty + Convert.ToDecimal(dtblend1.Rows[i]["BQty"].ToString()); drNew1["Qty"] = "0.00"; drNew1["Productname"] = dtblend1.Rows[i]["ProductName"].ToString(); drNew1["CreatedDate"] = dtblend1.Rows[i]["createddate"].ToString(); drNew1["BQty"] = BlendQty.ToString(); dtCollect.Rows.Add(drNew1); } } else { drNew1["Qty"] = "0.00"; drNew1["Productname"] = dtblend1.Rows[i]["ProductName"].ToString(); drNew1["CreatedDate"] = dtblend1.Rows[i]["createddate"].ToString(); drNew1["BQty"] = dtblend1.Rows[i]["BQty"].ToString(); dtCollect.Rows.Add(drNew1); } } } DataView dv = dtCollect.DefaultView; dv.Sort = "CreatedDate asc"; DataTable sortedDT = dv.ToTable(); if (sortedDT.Rows.Count > 0) { for (int d = 0; d < sortedDT.Rows.Count; d++) { BQty = BQty + (Convert.ToDecimal(sortedDT.Rows[d]["Qty"].ToString()) - Convert.ToDecimal(sortedDT.Rows[d]["BQty"])); sortedDT.Rows[d]["Balance"] = BQty.ToString(); } } gvgvStockregister.DataSource = sortedDT; gvgvStockregister.DataBind(); decimal farmerCollTotal = dtCollect.AsEnumerable().Sum(m => m.Field <decimal>("Qty")); lblColleted.Text = Math.Round(farmerCollTotal, 1).ToString(); }
/// <summary> /// Gets the hash code /// </summary> /// <returns>Hash code</returns> public override int GetHashCode() { unchecked // Overflow is fine, just wrap { var hashCode = 41; // Suitable nullity checks etc, of course :) if (Id != null) { hashCode = hashCode * 59 + Id.GetHashCode(); } if (Instrument != null) { hashCode = hashCode * 59 + Instrument.GetHashCode(); } if (Qty != null) { hashCode = hashCode * 59 + Qty.GetHashCode(); } if (Side != null) { hashCode = hashCode * 59 + Side.GetHashCode(); } if (Type != null) { hashCode = hashCode * 59 + Type.GetHashCode(); } if (FilledQty != null) { hashCode = hashCode * 59 + FilledQty.GetHashCode(); } if (AvgPrice != null) { hashCode = hashCode * 59 + AvgPrice.GetHashCode(); } if (LimitPrice != null) { hashCode = hashCode * 59 + LimitPrice.GetHashCode(); } if (StopPrice != null) { hashCode = hashCode * 59 + StopPrice.GetHashCode(); } if (ParentId != null) { hashCode = hashCode * 59 + ParentId.GetHashCode(); } if (ParentType != null) { hashCode = hashCode * 59 + ParentType.GetHashCode(); } if (Duration != null) { hashCode = hashCode * 59 + Duration.GetHashCode(); } if (Status != null) { hashCode = hashCode * 59 + Status.GetHashCode(); } return(hashCode); } }
/// <summary> /// Returns true if Order instances are equal /// </summary> /// <param name="other">Instance of Order to be compared</param> /// <returns>Boolean</returns> public bool Equals(Order other) { if (ReferenceEquals(null, other)) { return(false); } if (ReferenceEquals(this, other)) { return(true); } return (( Id == other.Id || Id != null && Id.Equals(other.Id) ) && ( Instrument == other.Instrument || Instrument != null && Instrument.Equals(other.Instrument) ) && ( Qty == other.Qty || Qty != null && Qty.Equals(other.Qty) ) && ( Side == other.Side || Side != null && Side.Equals(other.Side) ) && ( Type == other.Type || Type != null && Type.Equals(other.Type) ) && ( FilledQty == other.FilledQty || FilledQty != null && FilledQty.Equals(other.FilledQty) ) && ( AvgPrice == other.AvgPrice || AvgPrice != null && AvgPrice.Equals(other.AvgPrice) ) && ( LimitPrice == other.LimitPrice || LimitPrice != null && LimitPrice.Equals(other.LimitPrice) ) && ( StopPrice == other.StopPrice || StopPrice != null && StopPrice.Equals(other.StopPrice) ) && ( ParentId == other.ParentId || ParentId != null && ParentId.Equals(other.ParentId) ) && ( ParentType == other.ParentType || ParentType != null && ParentType.Equals(other.ParentType) ) && ( Duration == other.Duration || Duration != null && Duration.Equals(other.Duration) ) && ( Status == other.Status || Status != null && Status.Equals(other.Status) )); }
public string ToPostData(int index) { string postData = ""; if (Name != null) { postData += HttpUtility.UrlEncode("L_PAYMENTREQUEST_0_NAME" + index.ToString()) + "=" + HttpUtility.UrlEncode(Name) + "&"; } if (Desc != null) { postData += HttpUtility.UrlEncode("L_PAYMENTREQUEST_0_DESC" + index.ToString()) + "=" + HttpUtility.UrlEncode(Desc) + "&"; } if (Amt != 0) { postData += HttpUtility.UrlEncode("L_PAYMENTREQUEST_0_AMT" + index.ToString()) + "=" + Amt.ToString("F", CultureInfo.InvariantCulture) + "&"; } if (TaxAmt != 0) { postData += HttpUtility.UrlEncode("L_PAYMENTREQUEST_0_TAXAMT" + index.ToString()) + "=" + TaxAmt.ToString("F", CultureInfo.InvariantCulture) + "&"; } if (Number != 0) { postData += HttpUtility.UrlEncode("L_PAYMENTREQUEST_0_NUMBER" + index.ToString()) + "=" + Number.ToString(CultureInfo.InvariantCulture) + "&"; } if (Qty != 0) { postData += HttpUtility.UrlEncode("L_PAYMENTREQUEST_0_QTY" + index.ToString()) + "=" + Qty.ToString(CultureInfo.InvariantCulture) + "&"; } return(postData); }
public override string ToString() { return($"Sell Item: {SellItem.ToString()} Qty: {Qty.ToString()}"); }
private void btnAdd_Click(object sender, EventArgs e) { //Disclaimers Start if (cboxTitle.Text == "" || cboxType.Text == "" || cboxAuthor.Text == "" || cboxGenre.Text == "" || txtPages.Text == "" || txtPrice.Text == "" || txtQty.Text == "" || txtPublisher.Text == "") { MessageBox.Show("Stock cannot be added because, one or many of the nessasary fields are left blank. Please fill all the fields and try again", "Field Left Blank", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End; } //Remove single & double quotes which cause sql troubles foreach (Control c in this.Controls) { if (c is TextBox || c is ComboBox) { c.Text = c.Text.Replace("'", ""); c.Text = c.Text.Replace("\"", ""); } } int Qty; bool q = int.TryParse(txtQty.Text, out Qty); if (q == false) { MessageBox.Show("Insert a valid value for No. of books", "Invalid no. of books", MessageBoxButtons.OK, MessageBoxIcon.Error); goto End; } //Disclaimers End //Declarations string Title = cboxTitle.Text; string Maxbook = "B0000"; string BookID; double Price, Trans; Methods methods = new Methods(); //When Creating new title. if (TitleNew == true) { //Disclaimer + integer Declarations int Pages; bool pg = int.TryParse(txtPages.Text, out Pages); bool p = double.TryParse(txtPrice.Text, out Price); if (q == false || p == false || pg == false) { MessageBox.Show("Insert a valid value for No. of books, No. Pages or Price"); goto End; } //Declarations string Type, Author, Genre, ISBN, Publisher; TitleID = ""; Author = cboxAuthor.Text; Genre = cboxGenre.Text; ISBN = txtISBN.Text; Publisher = txtPublisher.Text; if (cboxType.SelectedIndex == 0) { Type = "CLend"; } else if (cboxType.SelectedIndex == 1) { Type = "ALend"; } else { Type = "Ref"; } //Creating New TitleID { //Getting MaxID from Databse string sqlMaxTitle = "SELECT MAX(TitleID) as MaxTitle, COUNT(TitleID) as CountID FROM Title"; OleDbCommand cmdMaxTitle = new OleDbCommand(sqlMaxTitle, db.con); if (db.con.State.Equals(ConnectionState.Closed)) { db.con.Open(); } OleDbDataReader drMaxTitle = cmdMaxTitle.ExecuteReader(); drMaxTitle.Read(); //If there are titles in DB, formulate a new TitleID if (drMaxTitle["CountID"].ToString() != "0") { // Calling NewID method TitleID = methods.NewID(drMaxTitle["MaxTitle"].ToString()); } else { TitleID = "T0001"; } } //Declartions End //Add Values to Relation: Title string sqlTitleNew = string.Format("INSERT INTO Title(TitleID, BTitle, BType, Price, Genre, ISBN, Pg, Author, Publisher) VALUES('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}')", TitleID, Title, Type, Price, Genre, ISBN, Pages, Author, Publisher); OleDbCommand cmdTitleNew = new OleDbCommand(sqlTitleNew, db.con); if (db.con.State.Equals(ConnectionState.Closed)) { db.con.Open(); } cmdTitleNew.ExecuteNonQuery(); } else { Price = double.Parse(txtPrice.Text); } // Get the highest BookID from Database string sqlMaxBook = "SELECT MAX(BookID) as MaxBook, COUNT(BookID) as CountID FROM Book"; OleDbCommand cmdMaxBook = new OleDbCommand(sqlMaxBook, db.con); if (db.con.State.Equals(ConnectionState.Closed)) { db.con.Open(); } OleDbDataReader drMaxbook = cmdMaxBook.ExecuteReader(); drMaxbook.Read(); if (drMaxbook["CountID"].ToString() != "0") { Maxbook = drMaxbook["MaxBook"].ToString(); } else { Maxbook = "B0000"; } // Adding books in a loop. for (int book = 1; book <= Qty; book++) { //Calling new ID method to create newID BookID = methods.NewID(Maxbook); //Adding a book with such book ID & TitleID to DB string sqlbook = string.Format("INSERT INTO Book (BookID, TitleID) VALUES ('{0}','{1}')", BookID, TitleID); OleDbCommand cmdbook = new OleDbCommand(sqlbook, db.con); if (db.con.State.Equals(ConnectionState.Closed)) { db.con.Open(); } cmdbook.ExecuteNonQuery(); //Make the BookID as the new Book_MaxID to help the next loop Maxbook = BookID; } Maxbook = ""; BookID = ""; // Adding Transaction details Trans = Price * Qty; string TDetail = string.Format("{0} books under the Title: {1}", Qty, Title); string sqlTrans = string.Format("INSERT INTO Cash (TDate, Amount, TDetail, Event) VALUES('{0}', {1}, '{2}', 'NewStock')", DateTime.Now.ToString(), -Trans, TDetail); OleDbCommand cmdTrans = new OleDbCommand(sqlTrans, db.con); cmdTrans.ExecuteNonQuery(); // Transactions added. //Successful Message MessageBox.Show(string.Format("{0} Book(s) and/or Book Title have been added to collection and transaction has been recorded successfully", Qty.ToString()), "Books Successfully Added", MessageBoxButtons.OK, MessageBoxIcon.Information); //Reset form this.Close(); frmAddBook f = new frmAddBook(); f.Show(); End : if (db.con.State.Equals(ConnectionState.Open)) { db.con.Close(); } }
internal void AddNewSalesOrder() { ExcelLib.PopulateInCollection(InventoryTest.ExcelPath, "SalesOrderPage"); //Navigate through Add Sales Order SalesMenu.Click(); Thread.Sleep(1000); OrdersMenu.Click(); Thread.Sleep(1000); AddSalesOrder.Click(); Thread.Sleep(3000); //Add New Sales Order CustCode.Click(); CustCode.SendKeys(ExcelLib.ReadData(2, "CustCode")); Thread.Sleep(2000); CustCodSelect.Click(); Thread.Sleep(3000); CustRef.SendKeys(ExcelLib.ReadData(2, "CustRef")); Thread.Sleep(1000); Discount.Clear(); Thread.Sleep(1000); Discount.SendKeys(ExcelLib.ReadData(2, "Discount")); Thread.Sleep(1000); Tax.SendKeys(ExcelLib.ReadData(2, "TaxRate")); Thread.Sleep(2000); //var TaxRate = CommonMethods.driver.FindElement(By.Id("SaleTaxes")); //var selectTaxRate = new SelectElement(TaxRate); //Thread.Sleep(3000); //selectTaxRate.SelectByText(ExcelLib.ReadData(2, "TaxRate")); //Warehouse.SendKeys(ExcelLib.ReadData(2,"Warehouse")); //Thread.Sleep(1000); var warehouse = CommonMethods.driver.FindElement(By.Id("WarehouseList")); var selectWarehouse = new SelectElement(warehouse); Thread.Sleep(1000); selectWarehouse.SelectByText(ExcelLib.ReadData(2, "Warehouse")); //DeliveryMethod.SendKeys(ExcelLib.ReadData(2,"DeliveryMethod")); //Thread.Sleep(1000); var deliverymethod = CommonMethods.driver.FindElement(By.Id("DeliveryMethodList")); var selectDM = new SelectElement(deliverymethod); Thread.Sleep(1000); selectDM.SelectByText(ExcelLib.ReadData(2, "DeliveryMethod")); DeliveryName.SendKeys(ExcelLib.ReadData(2, "DeliveryName")); Thread.Sleep(1000); DeliveryAdd.SendKeys(ExcelLib.ReadData(2, "StreetAddress")); Thread.Sleep(1000); DeliverySub.SendKeys(ExcelLib.ReadData(2, "Suburb")); Thread.Sleep(1000); DeliveryCity.SendKeys(ExcelLib.ReadData(2, "City")); Thread.Sleep(1000); Region.SendKeys(ExcelLib.ReadData(2, "Region")); Thread.Sleep(1000); PostCode.SendKeys(ExcelLib.ReadData(2, "PostCode")); Thread.Sleep(1000); DeliveryCountry.SendKeys(ExcelLib.ReadData(2, "Country")); Thread.Sleep(1000); SalesPerson.SendKeys(ExcelLib.ReadData(2, "SalesPerson")); Thread.Sleep(2000); //var sp = CommonMethods.driver.FindElement(By.Id("SalesPersonSelection")); //var selectsp = new SelectElement(sp); //Thread.Sleep(1000); //selectsp.SelectByText(ExcelLib.ReadData(2, "SalesPerson")); //SalesGrp.SendKeys(ExcelLib.ReadData(2, "SalesOrderGrp")); //Thread.Sleep(1000); var salesgroup = CommonMethods.driver.FindElement(By.Id("SalesGroupList")); var selectsalesgrp = new SelectElement(salesgroup); Thread.Sleep(1000); selectsalesgrp.SelectByText(ExcelLib.ReadData(2, "SalesOrderGrp")); OrderDate.SendKeys(ExcelLib.ReadData(2, "OrderDate")); Thread.Sleep(1000); OrderDateSelect.Click(); Thread.Sleep(1000); RequiredDate.SendKeys(ExcelLib.ReadData(2, "ReqDate")); Thread.Sleep(1000); RequiredDateSelect.Click(); //InvoiceLayout.SendKeys(ExcelLib.ReadData(2, "SalesOrderTemp")); //Thread.Sleep(1000); var SalesorderTemp = CommonMethods.driver.FindElement(By.Id("InvoiceLayoutId")); var selectSalesorderTemp = new SelectElement(SalesorderTemp); Thread.Sleep(1000); selectSalesorderTemp.SelectByText(ExcelLib.ReadData(2, "SalesOrderTemp")); //PackingSliplayout.SendKeys(ExcelLib.ReadData(2, "PackingSlipTemp")); //Thread.Sleep(1000); var PackingTemp = CommonMethods.driver.FindElement(By.Id("InvoiceLayoutId")); var selectPackingTemp = new SelectElement(PackingTemp); Thread.Sleep(1000); selectPackingTemp.SelectByText(ExcelLib.ReadData(2, "PackingSlipTemp")); ProductLineAdd.SendKeys(ExcelLib.ReadData(2, "ProductLine")); Thread.Sleep(1000); Qty.SendKeys(ExcelLib.ReadData(2, "Qty")); Thread.Sleep(1000); Price.SendKeys(ExcelLib.ReadData(2, "LinePrice")); Thread.Sleep(1000); DeliverySub.SendKeys(ExcelLib.ReadData(2, "LineDiscount")); Thread.Sleep(1000); //Add sales order line to Order AddOrderLineBtn.Click(); Thread.Sleep(1000); //Save Sales Order SaveSalesOrderBtn.Click(); Thread.Sleep(1000); ViewSalesOrder.Click(); Thread.Sleep(1000); //to filter data either can give cutomernumber or order number OrderNoFilter.SendKeys(SalesOrderNoDisplay.Text); Thread.Sleep(1000); OrderNoFilter.SendKeys(Keys.Enter); //filter byCust num CustFilter.SendKeys(ExcelLib.ReadData(2, "CustCode")); Thread.Sleep(1000); CustFilter.SendKeys(Keys.Enter); IList SalesOrderList = CommonMethods.driver.FindElements(By.XPath(".//*[@id='SalesOrderList_tccell0_")); int SalesOrderListCount = SalesOrderList.Count; //.//*[@id='SalesOrderList_tccell1_1']/a //.//*[@id='SalesOrderList_tccell2_1']/a //Verify added Sales Order try { for (int i = 0; i <= SalesOrderListCount; i++) { //Check whether the Salesorder is equal with grid table data if (SalesOrderNoDisplay.Text == CommonMethods.driver.FindElement(By.XPath(".//*[@id='SalesOrderList_tccell[" + i + "]_1']/a ")).Text) { //Check whether the Salesorder is equal to actual if (ExcelLib.ReadData(2, "CustCode") == CommonMethods.driver.FindElement(By.XPath(".//*[@id='SalesOrderList_tccell[" + i + "]_4']/a")).Text) { SaveScreenShotClass.SaveScreenshot(CommonMethods.driver, "Found Added Sales Order"); Thread.Sleep(2000); } } else { SaveScreenShotClass.SaveScreenshot(CommonMethods.driver, "Sales Order not found"); Thread.Sleep(2000); } } } catch (Exception e) { Console.WriteLine("Can not find added Product,Test failed" + e.Message); } }