private void GenerateCode(Digital_AppEntities posContext) { var purchaseTransactions = posContext.ItemPurchaseMsts; if (purchaseTransactions.Count() == 0) { txtGRNO.Text = "GRN-" + DateTime.Now.Year.ToString() + "-" + "1".PadLeft(6, '0'); } else { ItemPurchaseMst itemPurchaseMst = purchaseTransactions.OrderByDescending(id => id.ID).Take(1).Single(); if (itemPurchaseMst.CreatedDate.Value.Year == DateTime.Now.Year) { var a = Convert.ToInt16(itemPurchaseMst.GRN.Replace("GRN-" + DateTime.Now.Year.ToString() + "-", "")); txtGRNO.Text = "GRN-" + DateTime.Now.Year.ToString() + "-" + (Convert.ToInt16(itemPurchaseMst.GRN.Replace("GRN-" + DateTime.Now.Year.ToString() + "-", "")) + 1).ToString().PadLeft(6, '0'); } else { txtGRNO.Text = "GRN-" + DateTime.Now.Year.ToString() + "-" + "1".PadLeft(6, '0'); } } txtPO.Text = txtGRNO.Text.Replace("GRN-", "PO-"); }
private void btnSave_Click(object sender, EventArgs e) { if (dgvItemPurchaseDetail.Rows.Count <= 0) { MessageBox.Show("Please Iput Purchase Item..!!", Global.ApplicationNameWithVersion, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } ItemPurchaseMst itemPurchaseMst; using (var posContext = new Digital_AppEntities()) { if (itemPurchaseMstID == 0) { itemPurchaseMst = new ItemPurchaseMst(); itemPurchaseMst.GRN = txtGRNO.Text; itemPurchaseMst.ReceivedDate = Convert.ToDateTime(dtpGRNODate.Value.ToShortDateString() + " " + DateTime.Now.TimeOfDay.ToString()); itemPurchaseMst.PO = txtPO.Text; itemPurchaseMst.PODate = Convert.ToDateTime(dtpGRNODate.Value.ToShortDateString() + " " + DateTime.Now.TimeOfDay.ToString()); itemPurchaseMst.ChallanNo = txtChallanNo.Text; itemPurchaseMst.ChallanDate = Convert.ToDateTime(dtpGRNODate.Value.ToShortDateString() + " " + DateTime.Now.TimeOfDay.ToString()); if (cmbSupplier.SelectedValue != null) { itemPurchaseMst.SupplierID = Convert.ToInt16(cmbSupplier.SelectedValue); } itemPurchaseMst.Currency = "BD"; itemPurchaseMst.Total = Convert.ToDecimal(lblTotalData.Text); itemPurchaseMst.Remarks = txtRemarks.Text; itemPurchaseMst.CreatedBy = Global.LoggedInUser.ID; itemPurchaseMst.CreatedDate = DateTime.Now; itemPurchaseMst.discount = Convert.ToDecimal(txtDiscount.Text); itemPurchaseMst.carriage_charge = Convert.ToDecimal(txtCarriageCharg.Text); itemPurchaseMst.labure_charge = Convert.ToDecimal(txtLabureCharge.Text); itemPurchaseMst.SupplierMobileNo = txtMobileNo.Text; posContext.ItemPurchaseMsts.Add(itemPurchaseMst); posContext.SaveChanges(); int id = itemPurchaseMst.ID; itemPurchaseMstID = Convert.ToInt16(itemPurchaseMst.ID); SupplierID = Convert.ToInt16(cmbSupplier.SelectedValue); TotalAmount = Convert.ToDecimal(lblTotalData.Text); Discount = Convert.ToDecimal(txtDiscount.Text); ItemPurchaseDtl itemPurchaseDtl; decimal totqty = 0; foreach (DataGridViewRow row in dgvItemPurchaseDetail.Rows) { itemPurchaseDtl = new ItemPurchaseDtl(); itemPurchaseDtl.ItemPurchaseMstID = id; itemPurchaseDtl.ItemID = Convert.ToInt32(row.Cells["colItemID"].Value); //itemPurchaseDtl.BatchNo = (row.Cells["BatchNo"].Value).ToString(); itemPurchaseDtl.BatchNo = "0"; itemPurchaseDtl.ExpireDate = Convert.ToDateTime(row.Cells["ColExpireDate"].Value); itemPurchaseDtl.UnitPrice = Convert.ToDecimal(row.Cells["colUnitPrice"].Value); itemPurchaseDtl.Quantity = Convert.ToDecimal(row.Cells["colQuantity"].Value); itemPurchaseDtl.ReturnQuantity = Convert.ToDecimal(row.Cells["colQuantity"].Value); itemPurchaseDtl.Total = Convert.ToDecimal(row.Cells["colTotal"].Value); totqty += Convert.ToDecimal(itemPurchaseDtl.Quantity); posContext.ItemPurchaseDtls.Add(itemPurchaseDtl); } posContext.SaveChanges(); try { if (chkSentSMS.Checked) { if (!string.IsNullOrEmpty(txtMobileNo.Text) && txtMobileNo.Text.Length > 10) { string Year = DateTime.Now.Year.ToString(""); string TotalAmount2 = (itemPurchaseMst.Total * 1 + 0).ToString().Replace(" ", "").Replace(",", ""); string Invoice = "Dear Sir/Madam " + cmbSupplier.Text + ", Your Receipt No:" + itemPurchaseMst.PO + " Quantity :" + totqty.ToString() + " Amount :" + TotalAmount2 + " Thank's you for with us. For any query:01996513255"; // string Text = "Dear Sir/Madam,Thanks for shopping with Dorjibari.Invoice:" + invoiceNumber.Replace("INV-" + Year + "-", "") + ", Qty:" + totalSaleQuantity.ToString() + ",Amt:" + TotalAmount + ", Visit our online shop www.dorjibari.com.bd, For any query:01708449690"; int ln = (int)Text.Length; DialogResult values1 = MessageBox.Show("Are you want To Sent SMS!!", "", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); SMSGEtwayCode aSMSGEtwayCode = new SMSGEtwayCode(); if (values1.ToString() == "Yes") { aSMSGEtwayCode.SampleTestHttpApi(txtMobileNo.Text, Invoice, "userName", "Password"); } } } } catch { } MessageBox.Show("Save SuccessFully", Global.ApplicationNameWithVersion, MessageBoxButtons.OK, MessageBoxIcon.Information); //var categoryid = (from cats in posContext.ItemPurchaseMsts.LastOrDefaul() select cats.id).SingleOrDefault(); } else { itemPurchaseMst = posContext.ItemPurchaseMsts.Single(s => s.ID == itemPurchaseMstID); itemPurchaseMst.GRN = txtGRNO.Text; itemPurchaseMst.ReceivedDate = Convert.ToDateTime(dtpGRNODate.Value.ToShortDateString() + " " + DateTime.Now.TimeOfDay.ToString()); itemPurchaseMst.PO = txtPO.Text; itemPurchaseMst.PODate = Convert.ToDateTime(dtpGRNODate.Value.ToShortDateString() + " " + DateTime.Now.TimeOfDay.ToString()); itemPurchaseMst.ChallanNo = txtChallanNo.Text; itemPurchaseMst.ChallanDate = Convert.ToDateTime(dtpGRNODate.Value.ToShortDateString() + " " + DateTime.Now.TimeOfDay.ToString()); if (cmbSupplier.SelectedValue != null) { itemPurchaseMst.SupplierID = Convert.ToInt16(cmbSupplier.SelectedValue); } itemPurchaseMst.Currency = "BD"; itemPurchaseMst.Total = Convert.ToDecimal(lblTotalData.Text); itemPurchaseMst.Remarks = txtRemarks.Text; itemPurchaseMst.ModifiedBy = Global.LoggedInUser.ID; itemPurchaseMst.ModifiedDate = DateTime.Now; itemPurchaseMst.discount = Convert.ToDecimal(txtDiscount.Text); itemPurchaseMst.carriage_charge = Convert.ToDecimal(txtCarriageCharg.Text); itemPurchaseMst.labure_charge = Convert.ToDecimal(txtLabureCharge.Text); itemPurchaseMst.SupplierMobileNo = txtMobileNo.Text; posContext.SaveChanges(); int id = itemPurchaseMst.ID; foreach (ItemPurchaseDtl item in posContext.ItemPurchaseMsts.Single(s => s.ID == itemPurchaseMstID).ItemPurchaseDtls.ToList()) { posContext.ItemPurchaseDtls.Remove(item); } posContext.SaveChanges(); ItemPurchaseDtl itemPurchaseDtl; foreach (DataGridViewRow row in dgvItemPurchaseDetail.Rows) { itemPurchaseDtl = new ItemPurchaseDtl(); itemPurchaseDtl.ItemPurchaseMstID = id; itemPurchaseDtl.ItemID = Convert.ToInt32(row.Cells["colItemID"].Value); itemPurchaseDtl.BatchNo = "0"; //(row.Cells["BatchNo"].Value).ToString(); itemPurchaseDtl.ExpireDate = Convert.ToDateTime(row.Cells["ColExpireDate"].Value); itemPurchaseDtl.UnitPrice = Convert.ToDecimal(row.Cells["colUnitPrice"].Value); itemPurchaseDtl.Quantity = Convert.ToDecimal(row.Cells["colQuantity"].Value); itemPurchaseDtl.ReturnQuantity = Convert.ToDecimal(row.Cells["colQuantity"].Value); itemPurchaseDtl.Total = Convert.ToDecimal(row.Cells["colTotal"].Value); posContext.ItemPurchaseDtls.Add(itemPurchaseDtl); } posContext.SaveChanges(); MessageBox.Show("Update Successfully", Global.ApplicationNameWithVersion, MessageBoxButtons.OK, MessageBoxIcon.Information); } // this.ClearForm(); this.btnSave.Enabled = false; } }