public ActionResult Delete(int Id)
{
ViewBag.Title = "Delete";
var result1 = new GRNRepository().CHECK(Id);
if (result1 > 0)
{
TempData["error"] = "Sorry! Already Used.";
TempData["GRNNo"] = null;
return(RedirectToAction("Edit", new { id = Id }));
}
else
{
//var result5 = new GRNItemRepository().DeleteGRNADDDED(Id);
//var result2 = new GRNItemRepository().DeleteGRNItem(Id);
//var result4 = new StockUpdateRepository().DeleteGRNStockUpdate(Id);
//var result3 = new GRNRepository().DeleteGRNHD(Id);
var result3 = new GRNRepository().DeleteGRN(Id);
if (result3 > 0)
{
TempData["success"] = "Deleted succesfully";
return(RedirectToAction("PreviousList"));
}
else
{
TempData["error"] = "Some error occured. Please try again.";
TempData["GRNNo"] = null;
return(RedirectToAction("Edit", new { id = Id }));
}
}
}
public ActionResult PreviousListGRN(string Grn = "", string Supplier = "", string LPO = "")
{
var repo = new GRNRepository();
IEnumerable <GRN> GRNList = repo.GetGRNPreviousList(Grn, Supplier, LPO, OrganizationId);
return(PartialView("_PreviousListGRN", GRNList));
}
public void FillCurrency()
{
var repo = new GRNRepository();
var list = repo.FillCurrency();
ViewBag.currlist = new SelectList(list, "Id", "Name");
}
public void FillWarehouse()
{
GRNRepository repo = new GRNRepository();
var result = repo.GetWarehouseList();
ViewBag.WarehouseList = new SelectList(result, "StockPointId", "StockPointName");
}
public ActionResult Edit(GRN model)
{
ViewBag.Title = "Edit";
model.OrganizationId = OrganizationId;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
FillWarehouse();
FillCurrency();
SupplierDropdown();
FillAdditionDeduction();
FillEmployee();
var repo = new GRNRepository();
var result1 = new GRNRepository().CHECK(model.GRNId);
if (result1 > 0)
{
TempData["error"] = "Sorry! Already Used.";
TempData["GRNNo"] = null;
return(View("Edit", model));
}
else
{
try
{
var result = new GRNRepository().UpdateGRN(model);
//var result3 = new GRNItemRepository().DeleteGRNADDDED(model.GRNId);
//var result2 = new GRNItemRepository().DeleteGRNItem(model.GRNId);
//var result4 = new StockUpdateRepository().DeleteGRNStockUpdate(model.GRNId);
//var result5 = new GRNRepository().InsertGRNDT(model);
if (result.GRNId > 0)
{
TempData["success"] = "Updated successfully. (" + result.GRNNo + ")";
TempData["GRNNo"] = result.GRNNo;
return(RedirectToAction("PreviousList"));
//return View("Edit", model);
}
else
{
throw new Exception();
}
}
catch (SqlException)
{
TempData["error"] = "Some error occured while connecting to database. Please check your network connection and try again.";
}
catch (NullReferenceException)
{
TempData["error"] = "Some required data was missing. Please try again.";
}
catch (Exception)
{
TempData["error"] = "Some error occured. Please try again.";
}
return(RedirectToAction("PreviousList"));
}
}
public ActionResult Edit(int id = 0)
{
if (id == 0)
{
TempData["error"] = "That was an invalid/unknown request.";
return(RedirectToAction("Index", "Home"));
}
GRNRepository repo = new GRNRepository();
FillWarehouse();
FillCurrency();
FillEmployee();
FillAdditionDeduction();
GRN model = repo.GetGRNDetails(id);
if (model == null)
{
TempData["error"] = "Could not find the requested GRN. Please try again.";
return(RedirectToAction("PreviousList"));
}
model.Items = repo.GetGRNItems(id);
model.Additions = repo.GetGRNAdditions(id);
if (model.Additions.Count == 0)
{
model.Additions.Add(new GRNAddition());
}
model.Deductions = repo.GetGRNDeductions(id);
if (model.Deductions.Count == 0)
{
model.Deductions.Add(new GRNDeduction());
}
return(View(model));
}
public ActionResult LoadQuickView()
{
if (Session["user"] == null)
{
return(RedirectToAction("LogOff", "Account"));
}
QuickView view = new QuickView();
view.PendingDirectPurchaseRequests = true;
view.PendingTransQuotations = true;
view.PendingProjectQuotations = true;
view.PendingSupplyOrders = true;
view.PendingWorkshopRequests = true;
view.PendingProjectSaleOrdersForJobCard = true;
view.PendingTransSaleOrdersForJobCard = true;
view.MaterialStockBelowMinLevel = true;
view.PendingVechicleInpass = true;
view.PendingWRForStoreIssue = true;
view.PendingJobcardQC = true;
view.PendingMaterialReqPRS = true;
if (view.PendingProjectQuotations)
{
SalesQuotationRepository repo = new SalesQuotationRepository();
var res = repo.GetSalesQuotationApproveList(1, 0, OrganizationId);
view.NoOfProjectQuotations = res.Count;
}
if (view.PendingTransQuotations)
{
SalesQuotationRepository repo = new SalesQuotationRepository();
var res = repo.GetSalesQuotationApproveList(0, 0, OrganizationId);
view.NoOfTransQuotations = res.Count;
}
if (view.PendingSupplyOrders)
{
var repo = new GRNRepository();
var res = repo.GetGRNPendingList(0);
view.NoOfSupplyOrders = res.Count();
}
if (view.PendingDirectPurchaseRequests)
{
var res = new DirectPurchaseRepository().GetUnApprovedRequests(UserID);
view.NoOfPurchaseRequests = res.Count;
}
if (view.PendingWorkshopRequests)
{
var rep = new SaleOrderRepository();
var slist = rep.GetSaleOrdersPendingWorkshopRequest(OrganizationId, 0);
view.NoOfWorkShopRequests = slist.Count;
}
if (view.PendingProjectSaleOrdersForJobCard)
{
var list = new JobCardRepository().GetPendingSO(1, OrganizationId, 0);
view.NoOfProjectSaleOrdersForJobCard = list.Count();
}
if (view.PendingTransSaleOrdersForJobCard)
{
var list = new JobCardRepository().GetPendingSO(0, OrganizationId, 0);
view.NoOfTransSaleOrdersForJobCard = list.Count();
}
if (view.MaterialStockBelowMinLevel)
{
var list = new ItemRepository().GetCriticalMaterialsBelowMinStock(OrganizationId);
view.NoOfMaterialStockBelowMinLevel = list.Count();
//view.NoOfMaterialStockBelowMinLevel = new ItemRepository().GetCriticalMaterialsBelowMinStock(OrganizationId);
}
if (view.PendingVechicleInpass)
{
var list = new VehicleInPassRepository().PendingVehicleInpassforAlert(OrganizationId);
view.NoOfVechicleInpass = list.Count();
}
if (view.PendingWRForStoreIssue)
{
var list = new WorkShopRequestRepository().PendingWorkshopRequests("", "", "", "");
view.NoOfWRForStoreIssue = list.Count();
}
if (view.PendingJobcardQC)
{
var list = new DeliveryChallanRepository().PendingDelivery(OrganizationId);
view.NoOfJobcardQC = list.Count();
}
if (view.PendingMaterialReqPRS)
{
var list = new PurchaseRequestRepository().GetWorkShopRequestPending(OrganizationId, 0, "", "all");
view.NoOfPendingMaterialReqPRS = list.Count();
}
IEnumerable <ERPAlerts> Alerts;
if (Session["alertpermissions"] == null)
{
UserRepository repo = new UserRepository();
Alerts = repo.GetAlerts(UserID);
Session["alertpermissions"] = Alerts;
}
else
{
Alerts = (IEnumerable <ERPAlerts>)Session["alertpermissions"];
Session["alertpermissions"] = Alerts;
}
AlertPermission alertpermission = new AlertPermission();
foreach (var item in Alerts)
{
if (item.HasPermission == 1)
{
switch (item.AlertId)
{
case 1:
alertpermission.ProjectQuotApproval = true;
break;
case 2:
alertpermission.TransportQuotApproval = true;
break;
case 3:
alertpermission.PendingSupplyOrdForGrn = true;
break;
case 4:
alertpermission.DirectPurchaseReqDorApproval = true;
break;
case 5:
alertpermission.PendingSOForWorkshopReq = true;
break;
//case 6:
// alertpermission.PendingProjectSaleOrdersForJobCard = true;
// break;
//case 7:
// alertpermission.PendingTransSaleOrdersForJobCard = true;
// break;
case 6:
alertpermission.MaterialStockBelowMinLevel = true;
break;
case 7:
alertpermission.PendingVechicleInpass = true;
break;
case 8:
alertpermission.PendingWRForStoreIssue = true;
break;
case 9:
alertpermission.PendingJobcardQC = true;
break;
case 10:
alertpermission.PendingMaterialReqPRS = true;
break;
default:
break;
}
}
}
ViewBag.AlertPermissions = alertpermission;
return(PartialView("_QuickView", view));
}
public ActionResult Create(IList <PendingForGRN> list)
{
try
{
GRN model = new GRN();
if (list.Count > 0)
{
List <int?> id;
if (list[0].isDirectPurchase) //if direct purchase
{
id = (from PendingForGRN p in list
where p.isChecked
select p.DirectPurchaseRequestId).ToList();
if (id.Count > 0)
{
List <GRNAddition> Additions = new List <GRNAddition>();
Additions.Add(new GRNAddition());
List <GRNDeduction> Deductions = new List <GRNDeduction>();
Deductions.Add(new GRNDeduction());
model.isDirectPurchaseGRN = true;
model.Items = new GRNRepository().GetDirectGRNItems(id);
model.GRNDate = DateTime.Today;
model.Additions = Additions;
model.Deductions = Deductions;
SupplierDropdown();
}
else
{
throw new NullReferenceException("1No purchase requests were selected. Please select atleast one purchase request and try again.");
}
}
else //if not direct purchase
{
var selectedlist = (from PendingForGRN p in list
where p.isChecked
select p).ToList();
//if (selectedlist.)
if (selectedlist.Count > 0)
{
List <GRNAddition> Additions = new List <GRNAddition>();
Additions.Add(new GRNAddition());
List <GRNDeduction> Deductions = new List <GRNDeduction>();
Deductions.Add(new GRNDeduction());
model = new GRNRepository().GetGRNDetails(selectedlist[0].SupplierId);
model.GRNDate = DateTime.Today;
model.Items = new GRNRepository().GetGRNItem(selectedlist.Select(m => m.SupplyOrderId).ToList());
model.Additions = Additions;
model.Deductions = Deductions;
}
else
{
throw new NullReferenceException("1No supply orders were selected. Please select atleast one supply order and try again.");
}
}
}
FillWarehouse();
FillCurrency();
FillAdditionDeduction();
FillEmployee();
model.GRNNo = DatabaseCommonRepository.GetNextDocNo(11, OrganizationId);
return(View(model));
}
catch (NullReferenceException nx)
{
if (nx.Message.StartsWith("1"))
{
TempData["error"] = nx.Message.Substring(1);
}
else
{
TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message;
}
}
catch (SqlException sx)
{
TempData["error"] = "Some error occured while connecting to database. Please check your network connection and try again.|" + sx.Message;
}
catch (Exception ex)
{
TempData["error"] = "Some error occured. Please try again.|" + ex.Message;
}
TempData["success"] = "";
try
{
if (list[0].isDirectPurchase)
{
return(RedirectToAction("PendingDirectPurchase"));
}
return(RedirectToAction("PendingGrnWareHouse"));
}
catch (Exception)
{
return(RedirectToAction("Index", "Home"));
}
}
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;
}
}
public ActionResult Save(GRN model)
{
try
{
//if (!ModelState.IsValid)
//{
// return View(model);
//}
if (model == null || model.Items == null || model.Items.Count == 0)
{
throw new NullReferenceException();
}
model.OrganizationId = OrganizationId;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
string result = new GRNRepository().InsertGRN(model);
if (result != "")
{
TempData["success"] = "Saved succesfully. The GRN Reference No. is " + result;
TempData["error"] = "";
if (model.isDirectPurchaseGRN)
{
return(RedirectToAction("PendingDirectPurchase"));
}
return(RedirectToAction("PendingGrnWareHouse"));
}
else
{
throw new Exception();
}
}
catch (NullReferenceException nx)
{
TempData["success"] = "";
if (nx.Message.StartsWith("1"))
{
TempData["error"] = nx.Message.Substring(1);
}
else
{
TempData["error"] = "Some required value was missing. Please try again.|" + nx.Message;
}
}
catch (Exception ex)
{
TempData["success"] = "";
TempData["error"] = "Some error occured. Please try again.|" + ex.Message;
}
FillWarehouse();
FillCurrency();
SupplierDropdown();
FillAdditionDeduction();
FillEmployee();
PendingForGRN pending = new PendingForGRN();
if (model.isDirectPurchaseGRN)
{
foreach (var item in model.Items)
{
pending.DirectPurchaseRequestId = item.DirectPurchaseRequestId;
}
}
else
{
foreach (var item in model.Items)
{
pending.SupplyOrderId = item.SupplyOrderId;
}
}
return(View("Create", model));
}
