public int UpdateGRNItem(GRNItem objGRNItem) { using (IDbConnection connection = OpenConnection(dataConnection)) { string sql = @"UPDATE GRNItem SET GRNId = @GRNId ,SONoAndDate = @SONoAndDate ,SlNo = @SlNo ,ItemId = @ItemId,ItemDescription = @ItemDescription,PartNo = @PartNo,Quantity = @Quantity,Unit = @Unit,Rate = @Rate OUTPUT INSERTED.GRNItemId WHERE GRNItemId = @GRNItemId"; var id = connection.Execute(sql, objGRNItem); return(id); } }
public int InsertGRNItem(GRNItem model, IDbConnection connection, IDbTransaction trn) { try { string sql = @"INSERT INTO GRNItem(GRNId,SupplyOrderItemId,SlNo,ItemId,Remarks,ReceivedQty,Quantity,Rate,Discount,Amount,isActive,DirectPurchaseRequestItemId) VALUES (@GRNId,@SupplyOrderItemId,@SlNo,@ItemId,@Remarks,@ReceivedQuantity,@AcceptedQuantity,@Rate,@Discount,@Amount, 1, @DirectPurchaseRequestItemId); SELECT CAST(SCOPE_IDENTITY() AS INT)"; var id = connection.Query <int>(sql, model, trn).Single(); return(id); } catch (Exception) { throw; } }
public async Task <IActionResult> Create(GRN gRN, IEnumerable <Item> ItemList) { string CompId = User.Claims.Where(r => r.Type == "CompanyID").FirstOrDefault().Value; int CompID = Convert.ToInt32(CompId); // Main GRN gRN.CreatedBy = User.Identity.Name; gRN.CompanyID = CompID; _context.GRN.Add(gRN); await _context.SaveChangesAsync(); // Main GRN int GRN_ID = gRN.GRNID; var ItemList_Result = ItemList.ToList(); ItemList_Result.RemoveAll(x => x.CompanyID == 777777); ItemList_Result.ForEach(x => x.CompanyID = CompID); foreach (var item in ItemList_Result) { GRNItem grnlItem = new GRNItem(); grnlItem.ItemID = item.ItemID; grnlItem.GRNID = GRN_ID; grnlItem.Quantity = item.Quantity; grnlItem.CompanyID = CompID; _context.GRNItem.Add(grnlItem); await _context.SaveChangesAsync(); } ViewData["PartiesID"] = new SelectList(_context.Parties.Where(r => r.CompanyID == CompID), "PartiesID", "PartyName", gRN.PartiesID); return(RedirectToAction("Index")); }
public PartialViewResult UpdateItem(GRNItem item) { try { if (ModelState.IsValid) { CompanyProfiles cp = new CompanyProfiles(this.HttpContext); UpdateActualQtyMessage msg = new UpdateActualQtyMessage() { TenanId = cp.CompanyId, Guid = item.Guid, ActualQty = item.ActualQty }; new RabbitHelper().SendMasterDataExchange<UpdateActualQtyMessage>(msg); item.Jumlah = item.ActualQty * item.Harga; return PartialView("_EditResult", item); } return PartialView("_EditResult", item); } catch (Exception ex) { ModelState.AddModelError("", ex.Message); return PartialView(item); } }
public ActionResult Print(int Id) { ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "Grn.rpt")); DataSet ds = new DataSet(); ds.Tables.Add("Head"); ds.Tables.Add("Items"); //-------HEAD ds.Tables["Head"].Columns.Add("GRNNo"); ds.Tables["Head"].Columns.Add("GRNDate"); ds.Tables["Head"].Columns.Add("SupplierName"); ds.Tables["Head"].Columns.Add("WareHouseName"); ds.Tables["Head"].Columns.Add("SupplierDCNoAndDate"); ds.Tables["Head"].Columns.Add("VehicleNo"); ds.Tables["Head"].Columns.Add("GatePassNo"); ds.Tables["Head"].Columns.Add("SpecialRemarks"); ds.Tables["Head"].Columns.Add("GRNCurrencyName"); ds.Tables["Head"].Columns.Add("ReceivedBy"); //Organization ds.Tables["Head"].Columns.Add("DoorNo"); ds.Tables["Head"].Columns.Add("Street"); ds.Tables["Head"].Columns.Add("State"); ds.Tables["Head"].Columns.Add("Country"); ds.Tables["Head"].Columns.Add("Phone"); ds.Tables["Head"].Columns.Add("Fax"); ds.Tables["Head"].Columns.Add("Email"); ds.Tables["Head"].Columns.Add("ContactPerson"); ds.Tables["Head"].Columns.Add("CurrencyName"); ds.Tables["Head"].Columns.Add("Zip"); ds.Tables["Head"].Columns.Add("OrganizationName"); ds.Tables["Head"].Columns.Add("Image1"); //-------DT ds.Tables["Items"].Columns.Add("ItemName"); ds.Tables["Items"].Columns.Add("PartNo"); ds.Tables["Items"].Columns.Add("Remarks"); ds.Tables["Items"].Columns.Add("Qty"); ds.Tables["Items"].Columns.Add("UoM"); ds.Tables["Items"].Columns.Add("Rate"); ds.Tables["Items"].Columns.Add("Discount"); ds.Tables["Items"].Columns.Add("Amount"); GRNRepository repo = new GRNRepository(); var Head = repo.GetGRNDetailsHDPrint(Id, OrganizationId); DataRow dr = ds.Tables["Head"].NewRow(); dr["GRNNo"] = Head.GRNNo; dr["GRNDate"] = Head.GRNDate.ToString("dd-MMM-yyyy"); dr["SupplierName"] = Head.Supplier; dr["WareHouseName"] = Head.StockPointName; dr["SupplierDCNoAndDate"] = Head.SupplierDCNoAndDate; dr["VehicleNo"] = Head.VehicleNo; dr["GatePassNo"] = Head.GatePassNo; dr["SpecialRemarks"] = Head.SpecialRemarks; dr["CurrencyName"] = Head.CurrencyName; dr["ReceivedBy"] = Head.ReceivedBy; dr["ReceivedBy"] = Head.EmpReceivedBy; dr["GRNCurrencyName"] = Head.CurrencyName; //Organization dr["DoorNo"] = Head.DoorNo; dr["Street"] = Head.Street; dr["State"] = Head.State; dr["Country"] = Head.OrgCountryName; dr["Phone"] = Head.Phone; dr["Fax"] = Head.Fax; dr["Email"] = Head.Email; dr["ContactPerson"] = Head.ContactPerson; dr["Zip"] = Head.Zip; dr["CurrencyName"] = Head.OrgCurrency; dr["OrganizationName"] = Head.OrganizationName; dr["Image1"] = Server.MapPath("~/App_images/") + Head.Image1; ds.Tables["Head"].Rows.Add(dr); GRNRepository repo1 = new GRNRepository(); var Items = repo1.GetGRNItemsPrintDT(Id); foreach (var item in Items) { var pritem = new GRNItem { ItemName = item.ItemName, PartNo = item.PartNo, Remarks = item.Remarks, AcceptedQuantity = item.AcceptedQuantity, Unit = item.Unit, Rate = item.Rate, Discount = item.Discount, Amount = item.Amount, }; DataRow dri = ds.Tables["Items"].NewRow(); dri["ItemName"] = pritem.ItemName; dri["PartNo"] = pritem.PartNo; dri["Remarks"] = pritem.Remarks; dri["Qty"] = pritem.AcceptedQuantity; dri["UoM"] = pritem.Unit; dri["Rate"] = pritem.Rate; dri["Discount"] = pritem.Discount; dri["Amount"] = pritem.Amount; ds.Tables["Items"].Rows.Add(dri); } ds.WriteXml(Path.Combine(Server.MapPath("~/XML"), "Grn.xml"), XmlWriteMode.WriteSchema); rd.SetDataSource(ds); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", String.Format("Grn{0}.pdf", Id.ToString()))); } catch (Exception ex) { throw; } }