Skip to content

Instantly share code, notes, and snippets.

View jinan-kordab's full-sized avatar

Jinan Kordab jinan-kordab

View GitHub Profile
@jinan-kordab
jinan-kordab / ShipmentDeatilColumns
Created October 13, 2018 16:28
WH01 Shipment Details Columns
shipmentDetailsID bigint
shipmentID bigint
shipmentDate datetime
shipmentEstimatedArrivalDate datetime
shipmentArrivalDate datetime
shipmentMethod nvarchar(MAX)
numberOfProducts bigint
@jinan-kordab
jinan-kordab / shipmenttablecolumns.sql
Created October 13, 2018 16:27
WH01 Shipment Table Columns
shipmentID bigint
countryID bigint
shipmentCity nvarchar(MAX)
shipmentProvince nvarchar(MAX)
@jinan-kordab
jinan-kordab / WH01countrycolumns
Created October 13, 2018 16:26
WH01 Country Table Columns
countryID bigint
countryName nvarchar(MAX)
countryAbbreviation nvarchar(MAX)
countryFlag nvarchar(MAX)
@jinan-kordab
jinan-kordab / supplier-sql-columns.sql
Created October 13, 2018 16:24
WH01-supplier-columns
supplierID bigint
supplierName nvarchar(MAX)
countryID bigint
supplierProvince nvarchar(MAX)
supplierCity nvarchar(MAX)
supplierPostalCode nvarchar(50)
supplierTelephone nvarchar(MAX)
supplierFax nvarchar(MAX)
supplierEmail nvarchar(MAX)
supplierStreet nvarchar(MAX)
@jinan-kordab
jinan-kordab / WH01CopyProduct.cshtml
Created October 13, 2018 16:19
WH01 Action Result Copy Product
public ActionResult CopyProduct(FormCollection s_formCollection)
{
var ModelToReturn = TempData["currModel"];
var prodId = Convert.ToInt32(s_formCollection["hprodid"]);
var UpdateContext = new EntityFramework.WH01Entities();
var quwry = from pdet in UpdateContext.PRODUCT_DESCRIPTION
where pdet.productID == prodId
select pdet;
@jinan-kordab
jinan-kordab / WH01SearchActionresult.cshtml
Created October 13, 2018 16:18
Search Action Result for WH01
[HttpPost]
public ActionResult Search(FormCollection w_formCollection)
{
string searchTerm = w_formCollection["searchDialog"].ToString();
string byProduct = w_formCollection["cbProduct"] == null ? "off" : "on";
string byShipment = w_formCollection["cbShipment"] == null ? "off" : "on";
string gView = w_formCollection["cbGridview"] == null ? "off" : "on";
SearchProductModelList spml = new SearchProductModelList();
@jinan-kordab
jinan-kordab / WH01Nav.cshtml
Created October 13, 2018 16:16
Custom Navigation Bar header
<nav role="navigation" class="navbar navbar-default">
<div class="navbar-header">
<button type="button" data-target="#navbarCollapse" data-toggle="collapse" class="navbar-toggle">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a href="/DOutlet/Index" class="navbar-brand">Outlet D1</a>
</div>
@jinan-kordab
jinan-kordab / WH01db.sql
Created October 13, 2018 16:08
Distribution Outlet SQL Create
USE [WH01]
GO
/****** Object: Table [dbo].[COUNTRY] Script Date: 2017-02-05 16:51:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[COUNTRY](
[countryID] [bigint] IDENTITY(1,10) NOT NULL,
[countryName] [nvarchar](max) NOT NULL,
@jinan-kordab
jinan-kordab / MyClassicASPPage.asp
Created October 6, 2018 00:23
A hyperlink in classic ASP page that opens a URL in iFrame called myIframeInClassicASPPage
<a target="myIframeInClassicASPPage" href="http://10.10.10.10:9988/api/values/<%=Response.Write(Server.URLEncode(Session("UserName")))%>/<%=Response.Write(698757 * Server.URLEncode(Session("product_id")))%>" >Click Here</a>
@jinan-kordab
jinan-kordab / MyWebAPIController.cs
Created October 6, 2018 00:15
WEB API C# Controller , inside ASP.NET MVC project
public HttpResponseMessage Get(string u, string p)
{
Uri referrer = HttpContext.Current.Request.UrlReferrer;
dynamic myModel = new Models.MyModel();
CirculationMonitor.Controllers.HomeController hc = new HomeController();
string sd = DateTime.Now.ToShortDateString();
string ed = DateTime.Now.ToShortDateString();
var response = new HttpResponseMessage(HttpStatusCode.OK);
if (referrer != null)