private TRN ApplyTextureLine(TRN trn, Pair <double, double> upper, Pair <double, double> lower)
{
int xStart = (int)Math.Floor((Math.Min(upper.X, lower.X) - this.newInner) / Constants.TextureSpacing);
int width = (int)(4 * this.newInner * Math.Abs(upper.X - lower.X));
int yStart = (int)Math.Floor((Math.Min(upper.Y, lower.Y) - this.newInner) / Constants.TextureSpacing);
int height = (int)(4 * this.newInner * Math.Abs(upper.Y - lower.Y));
Rectangle coverRectangle = new Rectangle(xStart, yStart, width, height);
LineSegment lineSegment = new LineSegment(upper, lower);
foreach (textureData texture in data.textures)
{
int i = 0;
foreach (DDSGroup ddsGroup in trn.DDSGroups)
{
//Check whether the DDSGroup contain parts of the rectangle that surrounds the triangle
int x = (i % trn.Width) * ddsGroup.Width;
int y = ((i - (i % trn.Width)) / trn.Width) * ddsGroup.Height;
i++;
ddsGroup.ApplyTextureAsNewChannel(x, y, texture, lineSegment, coverRectangle, this.newInner);
}
}
return(trn);
}
private TRN ApplyColourLine(TRN trn, Pair <double, double> upper, Pair <double, double> lower)
{
Random ran = new Random();
int coverage = 0;
LineSegment linesegment = new LineSegment(upper, lower);
foreach (Vertex vertex in trn.Vertices)
{
Pair <double, double> point = new Pair <double, double>(vertex.Position[0], vertex.Position[1]);
if ((upper.X <= point.X && point.X <= lower.X) && (upper.Y <= point.Y && point.Y <= lower.Y))
{
if (linesegment.distance(point) <= Constants.VertexSpacing + newInner)
{
coverage = ran.Next(1, 100);
if (coverage <= data.colourCoverage)
{
vertex.Color = data.col;
}
}
}
}
return(trn);
}
public Boolean loadData(DataSet dat)
{
HMMSEntitiesDB trndb = new HMMSEntitiesDB();
try
{
foreach (DataRow dr in dat.Tables[0].Rows)
{
TRN localtrn = new TRN();
localtrn.Id = Guid.NewGuid();
localtrn.Received_Date = Convert.IsDBNull(dr["Received Date"]) ? "" : dr["Received Date"].ToString().Trim().Replace(">", "GTN").Replace("<", "ltn").Replace("$", "pct").Replace(",", ";").Replace("\n", ";").Replace("\r", ";").Replace("\"", "");
localtrn.Transfer_Date = Convert.IsDBNull(dr["Transfer Date"]) ? "" : dr["Transfer Date"].ToString().Trim().Replace(">", "GTN").Replace("<", "ltn").Replace("$", "pct").Replace(",", ";").Replace("\n", ";").Replace("\r", ";").Replace("\"", "");
localtrn.Transfer_From_Issue_Point = Convert.IsDBNull(dr["Transfer From Issue Point"]) ? "" : dr["Transfer From Issue Point"].ToString().Trim().Replace(">", "GTN").Replace("<", "ltn").Replace("$", "pct").Replace(",", ";").Replace("\n", ";").Replace("\r", ";").Replace("\"", "");
localtrn.Receiving_Issue_Point = Convert.IsDBNull(dr["Receiving Issue Point"]) ? "" : dr["Receiving Issue Point"].ToString().Trim().Replace(">", "GTN").Replace("<", "ltn").Replace("$", "pct").Replace(",", ";").Replace("\n", ";").Replace("\r", ";").Replace("\"", "");
localtrn.Serial_Number = Convert.IsDBNull(dr["Serial Number"]) ? "" : dr["Serial Number"].ToString().Trim().Replace(">", "GTN").Replace("<", "ltn").Replace("$", "pct").Replace(",", ";").Replace("\n", ";").Replace("\r", ";").Replace("\"", "");
localtrn.Transfer_User_Logon = Convert.IsDBNull(dr["Transfer User Logon"]) ? "" : dr["Transfer User Logon"].ToString().Trim().Replace(">", "GTN").Replace("<", "ltn").Replace("$", "pct").Replace(",", ";").Replace("\n", ";").Replace("\r", ";").Replace("\"", "");
localtrn.Received_User_Logon = Convert.IsDBNull(dr["Received User Logon"]) ? "" : dr["Received User Logon"].ToString().Trim().Replace(">", "GTN").Replace("<", "ltn").Replace("$", "pct").Replace(",", ";").Replace("\n", ";").Replace("\r", ";").Replace("\"", "");
trndb.TRNs.Add(localtrn);
}
trndb.SaveChanges();
}
catch (System.Data.Entity.Core.EntityException ee)
{
var msg = ee.Message;
msg = ee.InnerException.Message;
FileTypes.LogModel log = new FileTypes.LogModel();
log.WriteLog("ERROR", msg);
return(false);
}
catch (System.Data.Entity.Validation.DbEntityValidationException e)
{
{
string msg;
foreach (var eve in e.EntityValidationErrors)
{
msg = "Entity of type \"{0}\" in state \"{1}\" has the following validation errors:" + eve.Entry.Entity.GetType().Name + ":" + eve.Entry.State;
foreach (var ve in eve.ValidationErrors)
{
msg = "- Property: \"{0}\", Error: \"{1}\"" + ve.PropertyName + ":" + ve.ErrorMessage;
FileTypes.LogModel log = new FileTypes.LogModel();
log.WriteLog("ERROR", msg);
}
}
return(false);
}
}
finally
{
trndb.Dispose();
}
return(true);
}
/// <summary>
/// The method that calls the colour and texture methods
/// </summary>
/// <param name="area">The area we want to change</param>
/// <param name="trn">The TRN data that we is going to modify</param>
/// <param name="triangle">The Triangle we want to paint inside</param>
/// <param name="upper">The left upper point of the rectangle that contains triangle</param>
/// <param name="lower">The right lower point of the rectangle that contains triangle</param>
/// <returns></returns>
public TRN ApplyTriangle(NWN2Toolset.NWN2.Data.NWN2GameArea area, TRN trn, Triangle triangle, Pair <double, double> upper, Pair <double, double> lower, Random ran)
{
if (data.colourOption == colourOption.Colour)
{
trn = ApplyColourTriangle(trn, triangle, upper, lower, ran);
}
//texturemaps
trn = ApplyTextureTriangle(trn, triangle, upper, lower, ran);
return(trn);
}
private TRN ApplyLine(NWN2Toolset.NWN2.Data.NWN2GameArea area, TRN trn, Pair <double, double> upper, Pair <double, double> lower)
{
if (data.colourOption == colourOption.Colour)
{
trn = ApplyColourLine(trn, upper, lower);
}
//texturemaps
trn = ApplyTextureLine(trn, upper, lower);
return(trn);
}
/// <summary>
/// The method that uses the texture the inside of the triangle
/// </summary>
/// <param name="trn">The TRN data that we is going to modify</param>
/// <param name="triangle">The Triangle we want to paint inside</param>
/// <param name="upper">The left upper point of the rectangle that contains triangle</param>
/// <param name="lower">The right lower point of the rectangle that contains triangle</param>
/// <returns></returns>
public TRN ApplyTextureTriangle(TRN trn, Triangle triangle, Pair <double, double> upper, Pair <double, double> lower, Random ran)
{
Rectangle coverRectangle = new Rectangle((int)Math.Floor(upper.X / Constants.TextureSpacing), (int)Math.Floor(upper.Y / Constants.TextureSpacing),
(int)Math.Ceiling((lower.X - upper.X) / Constants.TextureSpacing), (int)Math.Ceiling((lower.Y - upper.Y) / Constants.TextureSpacing));
foreach (textureData texture in data.textures)
{
int i = 0;
foreach (DDSGroup ddsGroup in trn.DDSGroups)
{
//Check whether the DDSGroup contain parts of the rectangle that surrounds the triangle
int x = (i % trn.Width) * ddsGroup.Width;
int y = ((i - (i % trn.Width)) / trn.Width) * ddsGroup.Height;
i++;
ddsGroup.ApplyTextureAsNewChannel(x, y, texture, triangle, coverRectangle, ran);
}
}
return(trn);
}
/// <summary>
/// The method that colours the inside of the triangle
/// </summary>
/// <param name="trn">The TRN data that we is going to modify</param>
/// <param name="triangle">The Triangle we want to paint inside</param>
/// <param name="upper">The left upper point of the rectangle that contains triangle</param>
/// <param name="lower">The right lower point of the rectangle that contains triangle</param>
/// <returns>The changed TRN data</returns>
public TRN ApplyColourTriangle(TRN trn, Triangle triangle, Pair <double, double> upper, Pair <double, double> lower, Random ran)
{
int coverage = 0;
foreach (Vertex vertex in trn.Vertices)
{
float x = vertex.Position[0];
float y = vertex.Position[1];
if ((upper.X <= x && x <= lower.X) && (upper.Y <= y && y <= lower.Y))
{
if (triangle.insideTriangle(new Pair <double, double>(x, y)))
{
coverage = ran.Next(1, 100);
if (coverage <= data.colourCoverage)
{
vertex.Color = data.col;
}
}
}
}
return(trn);
}
private void StartMigration()
{
CompanyMaster companyMaster = new CompanyMaster();
ItemMaster itemMaster = new ItemMaster();
PersonRouteMaster personRouteMaster = new PersonRouteMaster();
PersonalLedgerMaster personalLedgerMaster = new PersonalLedgerMaster();
AccountLedgerMaster accountLedgerMaster = new AccountLedgerMaster();
SupplierLedgerMaster supplierLedgerMaster = new SupplierLedgerMaster();
CustomerLedgerMaster customerLedgerMaster = new CustomerLedgerMaster();
BillOutstanding billOutstanding = new BillOutstanding();
FIFO fifo = new FIFO();
PurchaseSaleBookHeaderMigration purchaseSaleBookHeaderMigration = new PurchaseSaleBookHeaderMigration();
PurchaseSaleBookLineItemMigration purchaseSaleBookLineItemMigration = new PurchaseSaleBookLineItemMigration();
TRN trn = new TRN();
ReceiptPaymentMigration receiptPayment = new ReceiptPaymentMigration();
BillOutStandingsAudjustmentMigration billOsAdjustment = new BillOutStandingsAudjustmentMigration();
int result = 0;
int rowIndex = 0;
SetProcessingText(grdDataMigration, "Company Master", rowIndex, "Processing", result, true);
result = companyMaster.InsertCompanyMasterData();
SetProcessingText(grdDataMigration, "Company Master", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "ASM", rowIndex, "Processing", result, true);
result = personRouteMaster.InsertASMData();
SetProcessingText(grdDataMigration, "ASM", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "RSM", rowIndex, "Processing", result, true);
result = personRouteMaster.InsertRSMData();
SetProcessingText(grdDataMigration, "RSM", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "ZSM", rowIndex, "Processing", result, true);
result = personRouteMaster.InsertZSMData();
SetProcessingText(grdDataMigration, "ZSM", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Sales Man", rowIndex, "Processing", result, true);
result = personRouteMaster.InsertSalesManData();
SetProcessingText(grdDataMigration, "Sales Man", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Area", rowIndex, "Processing", result, true);
result = personRouteMaster.InsertAreaData();
SetProcessingText(grdDataMigration, "Area", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Route", rowIndex, "Processing", result, true);
result = personRouteMaster.InsertRouteData();
SetProcessingText(grdDataMigration, "Route", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Personal Ledger", rowIndex, "Processing", result, true);
result = personalLedgerMaster.InsertPersonalLedgerMasterData();
SetProcessingText(grdDataMigration, "Personal Ledger", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Control Codes", rowIndex, "Processing", result, true);
result = accountLedgerMaster.InsertControlCodesData();
SetProcessingText(grdDataMigration, "Control Codes", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Income Ledger", rowIndex, "Processing", result, true);
result = accountLedgerMaster.InsertIncomeLedgerData();
SetProcessingText(grdDataMigration, "Income Ledger", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Expenditure Ledger", rowIndex, "Processing", result, true);
result = accountLedgerMaster.InsertExpenditureLedgerData();
SetProcessingText(grdDataMigration, "Expenditure Ledger", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Transaction Ledger", rowIndex, "Processing", result, true);
result = accountLedgerMaster.InsertTransactionLedgerData();
SetProcessingText(grdDataMigration, "Transaction Ledger", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "General Ledger", rowIndex, "Processing", result, true);
result = accountLedgerMaster.InsertGeneralLedgerData();
SetProcessingText(grdDataMigration, "General Ledger", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Purchase Ledger", rowIndex, "Processing", result, true);
result = accountLedgerMaster.InsertPurchaseLedgerData();
SetProcessingText(grdDataMigration, "Purchase Ledger", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Sale Ledger", rowIndex, "Processing", result, true);
result = accountLedgerMaster.InsertSaleLedgerData();
SetProcessingText(grdDataMigration, "Sale Ledger", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Item Master", rowIndex, "Processing", result, true);
result = itemMaster.InsertItemMasterData();
SetProcessingText(grdDataMigration, "Item Master", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Supplier Ledger", rowIndex, "Processing", result, true);
result = supplierLedgerMaster.InsertSupplierLedgerMasterData();
SetProcessingText(grdDataMigration, "Supplier Ledger", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Customer Ledger", rowIndex, "Processing", result, true);
result = customerLedgerMaster.InsertCustomerLedgerMasterData(); //confirm mapping columns for columns having comments in CustomerLedgerMaster
SetProcessingText(grdDataMigration, "Customer Ledger", rowIndex, "Completed", result, false);
//result = 0;
//rowIndex += 1;
//SetProcessingText(grdDataMigration, "Customer Compnay Discount Ref", rowIndex, "Processing", result, true);
//result = customerLedgerMaster.InsertCustomerCompanyReferenceData();
//SetProcessingText(grdDataMigration, "Customer Compnay Discount Ref", rowIndex, "Completed", result, false);
//result = 0;
//rowIndex += 1;
//SetProcessingText(grdDataMigration, "Suppiier Compnay Discount Ref", rowIndex, "Processing", result, true);
//result = supplierLedgerMaster.InsertSupplierCompanyReferenceData();
//SetProcessingText(grdDataMigration, "Suppiier Compnay Discount Ref", rowIndex, "Completed", result, false);
/*------------------------------------------------------------*/
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "PurchaseSaleBookHeaderData", rowIndex, "Processing", result, true);
result = purchaseSaleBookHeaderMigration.InsertPurchaseSaleBookHeaderData();
SetProcessingText(grdDataMigration, "PurchaseSaleBookHeaderData", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "PurchaseSaleBookLineItemData", rowIndex, "Processing", result, true);
result = purchaseSaleBookLineItemMigration.InsertPurchaseSaleBookLineItemData();
SetProcessingText(grdDataMigration, "PurchaseSaleBookLineItemData", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Fifo", rowIndex, "Processing", result, true);
result = fifo.InsertFIFOData();
SetProcessingText(grdDataMigration, "Fifo", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "Bill Outstanding", rowIndex, "Processing", result, true);
result = billOutstanding.InsertBillOutstandingData();
SetProcessingText(grdDataMigration, "Bill Outstanding", rowIndex, "Completed", result, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "TRN", rowIndex, "Processing", result, true);
trn.InsertTRNData();
SetProcessingText(grdDataMigration, "TRN", rowIndex, "Completed", 0, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "ReceiptPayment", rowIndex, "Processing", result, true);
result = receiptPayment.InsertReceiptPaymentData();
SetProcessingText(grdDataMigration, "ReceiptPayment", rowIndex, "Completed", 0, false);
result = 0;
rowIndex += 1;
SetProcessingText(grdDataMigration, "BillOutStandingsAudjustment", rowIndex, "Processing", result, true);
result = billOsAdjustment.InsertBillOutStandingsAudjustmentData();
SetProcessingText(grdDataMigration, "BillOutStandingsAudjustment", rowIndex, "Completed", 0, false);
/* --------------------------------------- ---------------------------------------*/
MessageBox.Show("Process Completed");
}
public EDI835SchemaModel ParseEDI835(string fileText)
{
bool payerSeg = false;
bool payeeSeg = false;
string claimSegment = string.Empty;
string segmentValue = string.Empty;
string[] ediTextArray = fileText.Split("~");
CLP clp = null;
SVC svc = null;
bool findNextCLP = false;
bool isServiceLineVisited = false;
foreach (string stringSegment in ediTextArray)
{
string[] segmentArray = stringSegment.Split("*");
if (segmentArray != null)
{
IEnumerable <string> values = Enum.GetValues(typeof(EDI835Segments))
.OfType <EDI835Segments>()
.Select(s => Convert.ToString(s));
if (values.Contains(segmentArray[0].TrimStart()))
{
if (segmentArray[0].TrimStart() != "CLP" && findNextCLP == true)
{
continue;
}
//else continue;
segmentValue = segmentArray[0].TrimStart();
if (claimSegment == "CLP")
{
segmentValue = "CLP";
}
switch (segmentValue)
{
case "ISA":
{
ISA ISA = GetSegmentInfo <ISA>(new ISA(), segmentArray);
ediSchemaModel.ISA = ISA;
break;
}
case "GS":
{
GS GS = GetSegmentInfo <GS>(new GS(), segmentArray);
ediSchemaModel.GS = GS;
break;
}
case "ST":
{
ST ST = GetSegmentInfo <ST>(new ST(), segmentArray);
ediSchemaModel.ST = ST;
break;
}
case "BPR":
{
BPR BPR = GetSegmentInfo <BPR>(new BPR(), segmentArray);
ediSchemaModel.BPR = BPR;
break;
}
case "TRN":
{
TRN TRN = GetSegmentInfo <TRN>(new TRN(), segmentArray);
ediSchemaModel.TRN = TRN;
break;
}
case "DTM":
{
DTM DTM = GetSegmentInfo <DTM>(new DTM(), segmentArray);
ediSchemaModel.DTM = DTM;
break;
}
case "N1":
{
if (segmentArray[1] == "PR")
{
N1 N1 = GetSegmentInfo <N1>(new N1(), segmentArray);
ediSchemaModel.PayerInfo = N1;
payerSeg = true;
}
else if (segmentArray[1] == "PE")
{
N1 N1 = GetSegmentInfo <N1>(new N1(), segmentArray);
ediSchemaModel.PayeeInfo = N1;
payeeSeg = true;
}
break;
}
case "N3":
{
if (payerSeg)
{
N3 N3 = GetSegmentInfo <N3>(new N3(), segmentArray);
ediSchemaModel.PayerAddress = N3;
}
else if (payeeSeg)
{
N3 N3 = GetSegmentInfo <N3>(new N3(), segmentArray);
ediSchemaModel.PayeeAddress = N3;
}
break;
}
case "N4":
{
if (payerSeg)
{
N4 N4 = GetSegmentInfo <N4>(new N4(), segmentArray);
ediSchemaModel.PayerCityStateZip = N4;
payerSeg = false;
}
else if (payeeSeg)
{
N4 N4 = GetSegmentInfo <N4>(new N4(), segmentArray);
ediSchemaModel.PayeeCityStateZip = N4;
payeeSeg = false;
}
break;
}
case "CLP":
{
claimSegment = "CLP";
switch (segmentArray[0].TrimStart())
{
case "CLP":
{
findNextCLP = false;
if (clp != null)
{
ediSchemaModel.CLPList.Add(clp);
isServiceLineVisited = false;
clp = null;
}
clp = GetSegmentInfo <CLP>(new CLP(), segmentArray);
break;
}
case "SVC":
{
//if (svc != null)
//{
// if (clp.SVCList == null) clp.SVCList = new List<SVC>();
// clp.SVCList.Add(svc);
// svc = null;
//}
svc = GetSegmentInfo <SVC>(new SVC(), segmentArray);
if (clp != null && clp.SVCList == null)
{
clp.SVCList = new List <SVC>();
}
clp.SVCList.Add(svc);
isServiceLineVisited = true;
break;
}
case "CAS":
{
if (isServiceLineVisited)
{
CAS CAS = GetSegmentInfo <CAS>(new CAS(), segmentArray);
if (svc.SVCAdjList == null)
{
svc.SVCAdjList = new List <CAS>();
}
svc.SVCAdjList.Add(CAS);
CAS = null;
}
break;
}
case "REF":
{
if (segmentArray[1].Trim() == "6R" && svc != null && svc.REF == null)
{
svc.REF = new REF();
svc.REF = GetSegmentInfo <REF>(new REF(), segmentArray);
}
break;
}
case "GE":
{
if (clp != null)
{
ediSchemaModel.CLPList.Add(clp);
isServiceLineVisited = false;
clp = null;
findNextCLP = true;
}
break;
}
default:
{
break;
}
}
break;
}
}
}
}
}
return(ediSchemaModel);
}
static void Main()
{
#region TableRecordCounts
Handle.GET("/OynSay", () =>
{
var nor = Db.SQL <long>("select count(o) from OYN o").First;
return(nor.ToString());
});
Handle.GET("/TkmSay", () =>
{
var nor = Db.SQL <long>("select count(o) from TKM o").First;
return(nor.ToString());
});
Handle.GET("/TrnSay", () =>
{
var nor = Db.SQL <long>("select count(o) from TRN o").First;
return(nor.ToString());
});
Handle.GET("/TrnOynSay", () =>
{
var nor = Db.SQL <long>("select count(o) from TRNOYN o").First;
return(nor.ToString());
});
Handle.GET("/TrnTkmSay", () =>
{
var nor = Db.SQL <long>("select count(o) from TRNTKM o").First;
return(nor.ToString());
});
Handle.GET("/TrnTkmOynSay", () =>
{
var nor = Db.SQL <long>("select count(o) from TRNTKMOYN o").First;
return(nor.ToString());
});
Handle.GET("/MsbSay", () =>
{
var nor = Db.SQL <long>("select count(o) from MSB o").First;
return(nor.ToString());
});
Handle.GET("/MacSay", () =>
{
var nor = Db.SQL <long>("select count(o) from MAC o").First;
return(nor.ToString());
});
#endregion
#region WebSocketUpgrade
Handle.GET("/wsOynConnect", (Request req) =>
{
if (req.WebSocketUpgrade)
{
req.SendUpgrade("wsOyn");
Console.WriteLine("wsOyn Connected {0}", DateTime.Now);
return(HandlerStatus.Handled);
}
return(new Response()
{
StatusCode = 500,
StatusDescription = "WebSocket upgrade on " + req.Uri + " was not approved."
});
});
Handle.GET("/wsTkmConnect", (Request req) =>
{
if (req.WebSocketUpgrade)
{
req.SendUpgrade("wsTkm");
Console.WriteLine("wsTkm Connected {0}", DateTime.Now);
return(HandlerStatus.Handled);
}
return(new Response()
{
StatusCode = 500,
StatusDescription = "WebSocket upgrade on " + req.Uri + " was not approved."
});
});
Handle.GET("/wsTrnConnect", (Request req) =>
{
if (req.WebSocketUpgrade)
{
req.SendUpgrade("wsTrn");
Console.WriteLine("wsTrn Connected {0}", DateTime.Now);
return(HandlerStatus.Handled);
}
return(new Response()
{
StatusCode = 500,
StatusDescription = "WebSocket upgrade on " + req.Uri + " was not approved."
});
});
Handle.GET("/wsTrnOynConnect", (Request req) =>
{
if (req.WebSocketUpgrade)
{
req.SendUpgrade("wsTrnOyn");
Console.WriteLine("wsTrnOyn Connected {0}", DateTime.Now);
return(HandlerStatus.Handled);
}
return(new Response()
{
StatusCode = 500,
StatusDescription = "WebSocket upgrade on " + req.Uri + " was not approved."
});
});
Handle.GET("/wsTrnTkmConnect", (Request req) =>
{
if (req.WebSocketUpgrade)
{
req.SendUpgrade("wsTrnTkm");
Console.WriteLine("wsTrnTkm Connected {0}", DateTime.Now);
return(HandlerStatus.Handled);
}
return(new Response()
{
StatusCode = 500,
StatusDescription = "WebSocket upgrade on " + req.Uri + " was not approved."
});
});
Handle.GET("/wsTrnTkmOynConnect", (Request req) =>
{
if (req.WebSocketUpgrade)
{
req.SendUpgrade("wsTrnTkmOyn");
Console.WriteLine("wsTrnTkmOyn Connected {0}", DateTime.Now);
return(HandlerStatus.Handled);
}
return(new Response()
{
StatusCode = 500,
StatusDescription = "WebSocket upgrade on " + req.Uri + " was not approved."
});
});
Handle.GET("/wsMsbConnect", (Request req) =>
{
if (req.WebSocketUpgrade)
{
req.SendUpgrade("wsMsb");
Console.WriteLine("wsMsb Connected {0}", DateTime.Now);
return(HandlerStatus.Handled);
}
return(new Response()
{
StatusCode = 500,
StatusDescription = "WebSocket upgrade on " + req.Uri + " was not approved."
});
});
Handle.GET("/wsMacConnect", (Request req) =>
{
if (req.WebSocketUpgrade)
{
req.SendUpgrade("wsMac");
Console.WriteLine("wsMac Connected {0}", DateTime.Now);
return(HandlerStatus.Handled);
}
return(new Response()
{
StatusCode = 500,
StatusDescription = "WebSocket upgrade on " + req.Uri + " was not approved."
});
});
#endregion
#region WebSocket Receiver
Handle.WebSocket("wsOyn", (String s, WebSocket ws) =>
{
OynJson jsn = new OynJson();
jsn.PopulateFromJson(s);
if (jsn.PutGet == "G")
{
var nor = Db.SQL <long>("select count(o) from PPDB.OYN o").First;
var oyn = Db.SQL <OYN>("select o from OYN o");
foreach (var obj in oyn)
{
jsn.NOR = nor--;
jsn.ID = (long)obj.GetObjectNo();
jsn.Ad = obj.Ad;
jsn.Sex = obj.Sex;
ws.Send(jsn.ToJson());
}
}
else if (jsn.PutGet == "P")
{
Db.Transact(() =>
{
if (jsn.ID < 0)
{
var obj = new OYN()
{
Ad = jsn.Ad,
Sex = jsn.Sex
};
jsn.NewID = (long)obj.GetObjectNo();
}
else
{
var obj = (OYN)DbHelper.FromID((ulong)jsn.ID);
if (jsn.Stu == "D")
{
obj.Delete();
}
else
{
obj.Ad = jsn.Ad;
obj.Sex = jsn.Sex;
}
}
});
ws.Send(jsn.ToJson());
}
});
Handle.WebSocket("wsTkm", (String s, WebSocket ws) =>
{
TkmJson jsn = new TkmJson();
jsn.PopulateFromJson(s);
if (jsn.PutGet == "G")
{
var nor = Db.SQL <long>("select count(o) from PPDB.TKM o").First;
var tkm = Db.SQL <TKM>("select o from TKM o");
foreach (var obj in tkm)
{
jsn.NOR = nor--;
jsn.ID = (long)obj.GetObjectNo();
jsn.Ad = obj.Ad;
ws.Send(jsn.ToJson());
}
}
else if (jsn.PutGet == "P")
{
Db.Transact(() =>
{
if (jsn.ID < 0)
{
var obj = new TKM()
{
Ad = jsn.Ad
};
jsn.NewID = (long)obj.GetObjectNo();
}
else
{
var obj = (TKM)DbHelper.FromID((ulong)jsn.ID);
if (jsn.Stu == "D")
{
obj.Delete();
}
else
{
obj.Ad = jsn.Ad;
}
}
});
ws.Send(jsn.ToJson());
}
});
Handle.WebSocket("wsTrn", (String s, WebSocket ws) =>
{
TrnJson jsn = new TrnJson();
jsn.PopulateFromJson(s);
if (jsn.PutGet == "G")
{
var nor = Db.SQL <long>("select count(o) from PPDB.TRN o").First;
var trn = Db.SQL <TRN>("select o from TRN o");
foreach (var obj in trn)
{
jsn.NOR = nor--;
jsn.ID = (long)obj.GetObjectNo();
jsn.Ad = obj.Ad;
jsn.Tarih = obj.Tarih;
ws.Send(jsn.ToJson());
}
}
else if (jsn.PutGet == "P")
{
Db.Transact(() =>
{
if (jsn.ID < 0)
{
var obj = new TRN()
{
Ad = jsn.Ad
};
jsn.NewID = (long)obj.GetObjectNo();
}
else
{
var obj = (TRN)DbHelper.FromID((ulong)jsn.ID);
if (jsn.Stu == "D")
{
obj.Delete();
}
else
{
obj.Ad = jsn.Ad;
obj.Trh = DateTime.Parse(jsn.Tarih);
}
}
});
ws.Send(jsn.ToJson());
}
});
Handle.WebSocket("wsTrnOyn", (String s, WebSocket ws) =>
{
TrnOynJson jsn = new TrnOynJson();
jsn.PopulateFromJson(s);
if (jsn.PutGet == "G")
{
var nor = Db.SQL <long>("select count(o) from TRNOYN o").First;
var trn = Db.SQL <TRNOYN>("select o from TRNOYN o");
foreach (var obj in trn)
{
jsn.NOR = nor--;
jsn.ID = (long)obj.GetObjectNo();
jsn.TrnID = (long)obj.Trn.GetObjectNo();
jsn.OynID = (long)obj.Oyn.GetObjectNo();
jsn.SrtNo = obj.SrtNo;
jsn.MacOS = obj.MacOS;
jsn.MacAS = obj.MacAS;
jsn.MacVS = obj.MacVS;
jsn.MacOD = obj.MacOD;
jsn.MacAD = obj.MacAD;
jsn.MacVD = obj.MacVD;
ws.Send(jsn.ToJson());
}
}
else if (jsn.PutGet == "P")
{
Db.Transact(() =>
{
if (jsn.ID < 0)
{
var obj = new TRNOYN()
{
Trn = (TRN)DbHelper.FromID((ulong)jsn.TrnID),
Oyn = (OYN)DbHelper.FromID((ulong)jsn.OynID),
SrtNo = (short)jsn.SrtNo,
MacOS = (short)jsn.MacOS,
MacAS = (short)jsn.MacAS,
MacVS = (short)jsn.MacVS,
MacOD = (short)jsn.MacOD,
MacAD = (short)jsn.MacAD,
MacVD = (short)jsn.MacVD,
};
jsn.NewID = (long)obj.GetObjectNo();
}
else
{
var obj = (TRNOYN)DbHelper.FromID((ulong)jsn.ID);
if (jsn.Stu == "D")
{
obj.Delete();
}
else
{
obj.Trn = (TRN)DbHelper.FromID((ulong)jsn.TrnID);
obj.Oyn = (OYN)DbHelper.FromID((ulong)jsn.OynID);
obj.SrtNo = (short)jsn.SrtNo;
obj.MacOS = (short)jsn.MacOS;
obj.MacAS = (short)jsn.MacAS;
obj.MacVS = (short)jsn.MacVS;
obj.MacOD = (short)jsn.MacOD;
obj.MacAD = (short)jsn.MacAD;
obj.MacVD = (short)jsn.MacVD;
}
}
});
ws.Send(jsn.ToJson());
}
});
Handle.WebSocket("wsTrnTkm", (String s, WebSocket ws) =>
{
TrnTkmJson jsn = new TrnTkmJson();
jsn.PopulateFromJson(s);
if (jsn.PutGet == "G")
{
var nor = Db.SQL <long>("select count(o) from TRNTKM o").First;
var trn = Db.SQL <TRNTKM>("select o from TRNTKM o");
foreach (var obj in trn)
{
jsn.NOR = nor--;
jsn.ID = (long)obj.GetObjectNo();
jsn.TrnID = (long)obj.Trn.GetObjectNo();
jsn.TkmID = (long)obj.Tkm.GetObjectNo();
jsn.MsbO = obj.MsbO;
jsn.MsbA = obj.MsbA;
jsn.MsbV = obj.MsbV;
jsn.MsbB = obj.MsbB;
jsn.MsbPA = obj.MsbPA;
jsn.MsbPV = obj.MsbPV;
ws.Send(jsn.ToJson());
}
}
else if (jsn.PutGet == "P")
{
Db.Transact(() =>
{
if (jsn.ID < 0)
{
var obj = new TRNTKM()
{
Trn = (TRN)DbHelper.FromID((ulong)jsn.TrnID),
Tkm = (TKM)DbHelper.FromID((ulong)jsn.TkmID),
MsbO = (short)jsn.MsbO,
MsbA = (short)jsn.MsbA,
MsbV = (short)jsn.MsbV,
MsbB = (short)jsn.MsbB,
MsbPA = (short)jsn.MsbPA,
MsbPV = (short)jsn.MsbPV,
};
jsn.NewID = (long)obj.GetObjectNo();
}
else
{
var obj = (TRNTKM)DbHelper.FromID((ulong)jsn.ID);
if (jsn.Stu == "D")
{
obj.Delete();
}
else
{
obj.Trn = (TRN)DbHelper.FromID((ulong)jsn.TrnID);
obj.Tkm = (TKM)DbHelper.FromID((ulong)jsn.TkmID);
obj.MsbO = (short)jsn.MsbO;
obj.MsbA = (short)jsn.MsbA;
obj.MsbV = (short)jsn.MsbV;
obj.MsbB = (short)jsn.MsbB;
obj.MsbPA = (short)jsn.MsbPA;
obj.MsbPV = (short)jsn.MsbPV;
}
}
});
ws.Send(jsn.ToJson());
}
});
Handle.WebSocket("wsTrnTkmOyn", (String s, WebSocket ws) =>
{
TrnTkmOynJson jsn = new TrnTkmOynJson();
jsn.PopulateFromJson(s);
if (jsn.PutGet == "G")
{
var nor = Db.SQL <long>("select count(o) from TRNTKMOYN o").First;
var trn = Db.SQL <TRNTKMOYN>("select o from TRNTKM o");
foreach (var obj in trn)
{
jsn.NOR = nor--;
jsn.ID = (long)obj.GetObjectNo();
jsn.TrnID = (long)obj.Trn.GetObjectNo();
jsn.TkmID = (long)obj.Tkm.GetObjectNo();
jsn.OynID = (long)obj.Oyn.GetObjectNo();
ws.Send(jsn.ToJson());
}
}
else if (jsn.PutGet == "P")
{
Db.Transact(() =>
{
if (jsn.ID < 0)
{
var obj = new TRNTKMOYN()
{
Trn = (TRN)DbHelper.FromID((ulong)jsn.TrnID),
Tkm = (TKM)DbHelper.FromID((ulong)jsn.TkmID),
Oyn = (OYN)DbHelper.FromID((ulong)jsn.OynID),
};
jsn.NewID = (long)obj.GetObjectNo();
}
else
{
var obj = (TRNTKMOYN)DbHelper.FromID((ulong)jsn.ID);
if (jsn.Stu == "D")
{
obj.Delete();
}
else
{
obj.Trn = (TRN)DbHelper.FromID((ulong)jsn.TrnID);
obj.Tkm = (TKM)DbHelper.FromID((ulong)jsn.TkmID);
obj.Oyn = (OYN)DbHelper.FromID((ulong)jsn.OynID);
}
}
});
ws.Send(jsn.ToJson());
}
});
Handle.WebSocket("wsMsb", (String s, WebSocket ws) =>
{
MsbJson jsn = new MsbJson();
jsn.PopulateFromJson(s);
if (jsn.PutGet == "G")
{
var nor = Db.SQL <long>("select count(o) from PPDB.MSB o").First;
var msb = Db.SQL <MSB>("select o from MSB o");
foreach (var obj in msb)
{
jsn.NOR = nor--;
jsn.ID = (long)obj.GetObjectNo();
jsn.Tarih = obj.Tarih;
jsn.TrnID = (long)obj.Trn.GetObjectNo();
jsn.Skl = obj.Skl;
jsn.Ktg = obj.Ktg;
jsn.Rnd = obj.Rnd;
jsn.Grp = obj.Grp;
jsn.HTkmID = (long)obj.HTkm.GetObjectNo();
jsn.GTkmID = (long)obj.GTkm.GetObjectNo();
jsn.HTP = obj.HTP;
jsn.GTP = obj.GTP;
jsn.HTMP = obj.HTMP;
jsn.GTMP = obj.GTMP;
jsn.HTMAS = obj.HTMAS;
jsn.HTMAD = obj.HTMAD;
jsn.GTMAS = obj.GTMAS;
jsn.GTMAD = obj.GTMAD;
ws.Send(jsn.ToJson());
}
}
else if (jsn.PutGet == "P")
{
Db.Transact(() =>
{
if (jsn.ID < 0)
{
var obj = new MSB()
{
Trh = DateTime.Parse(jsn.Tarih),
Trn = (TRN)DbHelper.FromID((ulong)jsn.TrnID),
HTkm = (TKM)DbHelper.FromID((ulong)jsn.HTkmID),
GTkm = (TKM)DbHelper.FromID((ulong)jsn.GTkmID),
Skl = jsn.Skl,
Ktg = jsn.Ktg,
Rnd = jsn.Rnd,
Grp = jsn.Grp,
HTP = (short)jsn.HTP,
GTP = (short)jsn.GTP,
HTMP = (short)jsn.HTMP,
GTMP = (short)jsn.GTMP,
HTMAS = (short)jsn.HTMAS,
HTMAD = (short)jsn.HTMAD,
GTMAS = (short)jsn.GTMAS,
GTMAD = (short)jsn.GTMAD,
};
jsn.NewID = (long)obj.GetObjectNo();
}
else
{
var obj = (MSB)DbHelper.FromID((ulong)jsn.ID);
if (jsn.Stu == "D")
{
obj.Delete();
}
else
{
obj.Trh = DateTime.Parse(jsn.Tarih);
obj.Trn = (TRN)DbHelper.FromID((ulong)jsn.TrnID);
obj.HTkm = (TKM)DbHelper.FromID((ulong)jsn.HTkmID);
obj.GTkm = (TKM)DbHelper.FromID((ulong)jsn.GTkmID);
obj.Skl = jsn.Skl;
obj.Ktg = jsn.Ktg;
obj.Rnd = jsn.Rnd;
obj.Grp = jsn.Grp;
obj.HTP = (short)jsn.HTP;
obj.GTP = (short)jsn.GTP;
obj.HTMP = (short)jsn.HTMP;
obj.GTMP = (short)jsn.GTMP;
obj.HTMAS = (short)jsn.HTMAS;
obj.HTMAD = (short)jsn.HTMAD;
obj.GTMAS = (short)jsn.GTMAS;
obj.GTMAD = (short)jsn.GTMAD;
}
}
});
ws.Send(jsn.ToJson());
}
});
Handle.WebSocket("wsMac", (String s, WebSocket ws) =>
{
MacJson jsn = new MacJson();
jsn.PopulateFromJson(s);
for (int i = 0; i < 1; i++)
{
//ws.Send(jsn.ToJson());
}
if (jsn.PutGet == "G")
{
var nor = Db.SQL <long>("select count(o) from PPDB.MAC o").First;
var mac = Db.SQL <MAC>("select o from PPDB.MAC o");
foreach (var obj in mac)
{
jsn.NOR = nor--;
jsn.ID = (long)obj.GetObjectNo();
jsn.TrnID = (long)obj.Trn.GetObjectNo();
jsn.MsbID = (long)obj.Msb.GetObjectNo();
jsn.HOyn1ID = obj.HOyn1 == null ? 0 : (long)obj.HOyn1.GetObjectNo();
jsn.HOyn2ID = obj.HOyn2 == null ? 0 : (long)obj.HOyn2.GetObjectNo();
jsn.GOyn1ID = obj.GOyn1 == null ? 0 : (long)obj.GOyn1.GetObjectNo();
jsn.GOyn2ID = obj.GOyn2 == null ? 0 : (long)obj.GOyn2.GetObjectNo();
jsn.Ktg = obj.Ktg;
jsn.Sra = obj.Sra;
jsn.S1HP = obj.S1HP;
jsn.S1GP = obj.S1GP;
jsn.S2HP = obj.S2HP;
jsn.S2GP = obj.S2GP;
jsn.S3HP = obj.S3HP;
jsn.S3GP = obj.S3GP;
jsn.S4HP = obj.S4HP;
jsn.S4GP = obj.S4GP;
jsn.S5HP = obj.S5HP;
jsn.S5GP = obj.S5GP;
jsn.S6HP = obj.S6HP;
jsn.S6GP = obj.S6GP;
jsn.S7HP = obj.S7HP;
jsn.S7GP = obj.S7GP;
jsn.HS = obj.HS;
jsn.GS = obj.GS;
jsn.HP = obj.HP;
jsn.GP = obj.GP;
ws.Send(jsn.ToJson());
}
}
else if (jsn.PutGet == "P")
{
Db.Transact(() =>
{
if (jsn.ID < 0)
{
var obj = new MAC()
{
Trn = (TRN)DbHelper.FromID((ulong)jsn.TrnID),
Msb = (MSB)DbHelper.FromID((ulong)jsn.MsbID),
HOyn1 = (OYN)DbHelper.FromID((ulong)jsn.HOyn1ID),
HOyn2 = (OYN)DbHelper.FromID((ulong)jsn.HOyn2ID),
GOyn1 = (OYN)DbHelper.FromID((ulong)jsn.GOyn1ID),
GOyn2 = (OYN)DbHelper.FromID((ulong)jsn.GOyn2ID),
Ktg = jsn.Ktg,
Sra = (short)jsn.Sra,
S1HP = (short)jsn.S1HP,
S1GP = (short)jsn.S1GP,
S2HP = (short)jsn.S2HP,
S2GP = (short)jsn.S2GP,
S3HP = (short)jsn.S3HP,
S3GP = (short)jsn.S3GP,
S4HP = (short)jsn.S4HP,
S4GP = (short)jsn.S4GP,
S5HP = (short)jsn.S5HP,
S5GP = (short)jsn.S5GP,
S6HP = (short)jsn.S6HP,
S6GP = (short)jsn.S6GP,
S7HP = (short)jsn.S7HP,
S7GP = (short)jsn.S7GP,
HS = (short)jsn.HS,
GS = (short)jsn.GS,
HP = (short)jsn.HP,
GP = (short)jsn.GP,
};
jsn.NewID = (long)obj.GetObjectNo();
}
else
{
var obj = (MAC)DbHelper.FromID((ulong)jsn.ID);
if (jsn.Stu == "D")
{
obj.Delete();
}
else
{
obj.Trn = (TRN)DbHelper.FromID((ulong)jsn.TrnID);
obj.Msb = (MSB)DbHelper.FromID((ulong)jsn.MsbID);
obj.HOyn1 = (OYN)DbHelper.FromID((ulong)jsn.HOyn1ID);
obj.HOyn2 = (OYN)DbHelper.FromID((ulong)jsn.HOyn2ID);
obj.GOyn1 = (OYN)DbHelper.FromID((ulong)jsn.GOyn1ID);
obj.GOyn2 = (OYN)DbHelper.FromID((ulong)jsn.GOyn2ID);
obj.Ktg = jsn.Ktg;
obj.Sra = (short)jsn.Sra;
obj.S1HP = (short)jsn.S1HP;
obj.S1GP = (short)jsn.S1GP;
obj.S2HP = (short)jsn.S2HP;
obj.S2GP = (short)jsn.S2GP;
obj.S3HP = (short)jsn.S3HP;
obj.S3GP = (short)jsn.S3GP;
obj.S4HP = (short)jsn.S4HP;
obj.S4GP = (short)jsn.S4GP;
obj.S5HP = (short)jsn.S5HP;
obj.S5GP = (short)jsn.S5GP;
obj.S6HP = (short)jsn.S6HP;
obj.S6GP = (short)jsn.S6GP;
obj.S7HP = (short)jsn.S7HP;
obj.S7GP = (short)jsn.S7GP;
obj.HS = (short)jsn.HS;
obj.GS = (short)jsn.GS;
obj.HP = (short)jsn.HP;
obj.GP = (short)jsn.GP;
}
}
});
ws.Send(jsn.ToJson());
}
});
#endregion
#region Deneme
Handle.POST("/Tkm", (TkmJson jsn) =>
{
return(jsn);
});
#endregion
}
