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;
}
}
