public Invoice GetInvoiceByNo(Invoice_RQ _objInvoice)
{
if (!string.IsNullOrWhiteSpace(_objInvoice.InvoiceNo))
{
try
{
using (LocalEntity _context = new LocalEntity())
{
//var search = _context.tblCustomers.();
var search = (from x in _context.tblInvoices
where x.InvoiceNo == _objInvoice.InvoiceNo
select x).AsQueryable();
string strInvoiceNo = string.Empty;
if (search != null)
{
strInvoiceNo = (from x in search select x.InvoiceNo).FirstOrDefault();
}
List <InvoiceItemDetails> _lstOrderitem = new List <InvoiceItemDetails>();
if (strInvoiceNo != string.Empty)
{
_lstOrderitem = (from x in _context.tbl_InvoiceItemDetails
where x.InvoiceNo == strInvoiceNo
select new InvoiceItemDetails
{
InvoiceItemID = x.InvoiceItemID,
Amount = x.Amount,
ArtDesc = x.ArtDesc,
ArtNo = x.ArtNo,
InvoiceNo = x.InvoiceNo,
Quantity = x.Quantity,
Rate = x.Rate,
RefileInk = x.RefileInk,
WorkOrderDesc = x.WorkOrderDesc
}
).ToList();
}
//var itemorderdetails
var result = (from s in search
select new Invoice
{
InvoiceId = s.InvoiceId,
InvoiceNo = s.InvoiceNo,
PartyNo = s.PartyNo,
BankId = s.BankId,
Unit = s.Unit,
InvoiceDate = s.InvoiceDate,
InvoiceCurrency = s.InvoiceCurrency,
InvoiceGrandQty = s.InvoiceGrandQty,
InvoiceGrandAmt = s.InvoiceGrandAmt,
Remark = s.Remark,
DeliveryTerms = s.DeliveryTerms,
DeliveryType = s.DeliveryType,
Port = s.Port,
PaymentTerms = s.PaymentTerms,
DeliveryPeriod = s.DeliveryPeriod,
WODelivery = s.WODelivery,
Remarks = s.Remarks,
WORemarks = s.WORemarks,
Note = s.Note,
PartialShip = s.PartialShip,
TransShipment = s.TransShipment,
CreatedBy = s.CreatedBy,
CreatedOn = s.CreatedOn,
EditedBy = s.EditedBy,
EditedOn = s.EditedOn,
IsActive = s.IsActive
}).FirstOrDefault();
if (result != null)
{
foreach (var item in _lstOrderitem)
{
result._objOrderItem.Add(item);
}
}
return(result);
}
}
catch (Exception)
{
throw;
}
}
return(new Invoice()
{
});
}
public Invoice CreateInvoice(Invoice _objCreateInvoice)
{
try
{
if (_objCreateInvoice != null)
{
//Check Duplicate
using (LocalEntity _context = new LocalEntity())
{
var invoice = _context.tblInvoices.OrderByDescending(x => x.InvoiceId).FirstOrDefault();
int intMaxId = 1;
int intInvoiceId = 1;
if (invoice != null)
{
intMaxId = invoice.InvoiceId + 1;
intInvoiceId = intInvoiceId + 1;
}
string strInvoiceNo = "SSB-" + intMaxId;
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-IN");
_context.tblInvoices.Add(new tblInvoice
{
InvoiceId = intInvoiceId,
InvoiceNo = strInvoiceNo,
PartyNo = _objCreateInvoice.PartyNo,
BankId = _objCreateInvoice.BankId,
Unit = _objCreateInvoice.Unit,
InvoiceDate = _objCreateInvoice.InvoiceDate,
InvoiceCurrency = string.Format(_objCreateInvoice.InvoiceCurrency, CultureInfo.InvariantCulture),
InvoiceGrandQty = Convert.ToDecimal(_objCreateInvoice.InvoiceGrandQty),
InvoiceGrandAmt = _objCreateInvoice.InvoiceGrandAmt,
Remark = _objCreateInvoice.Remark,
DeliveryTerms = _objCreateInvoice.DeliveryTerms,
DeliveryType = _objCreateInvoice.DeliveryType,
Port = _objCreateInvoice.Port,
PaymentTerms = _objCreateInvoice.PaymentTerms,
DeliveryPeriod = _objCreateInvoice.DeliveryPeriod,
WODelivery = _objCreateInvoice.WODelivery,
Remarks = _objCreateInvoice.Remarks,
WORemarks = _objCreateInvoice.WORemarks,
Note = _objCreateInvoice.Note,
PartialShip = _objCreateInvoice.PartialShip,
TransShipment = _objCreateInvoice.TransShipment,
CreatedBy = _objCreateInvoice.CreatedBy,
CreatedOn = _objCreateInvoice.CreatedOn,
EditedBy = _objCreateInvoice.EditedBy,
EditedOn = _objCreateInvoice.EditedOn,
IsActive = _objCreateInvoice.IsActive,
});
if (_context.SaveChanges() == 1)
{
//Create Item details
//var InvoiceItem = _context.tbl_InvoiceItemDetails.OrderByDescending(x => x.InvoiceItemID).FirstOrDefault();
//int intInvoiceItemID = 1;
//if (InvoiceItem != null)
Int32 intInvoiceItemID = GetItemDetailsMax();
//if (InvoiceItem != null)
//{
List <InvoiceItemDetails> _lstItems = new List <InvoiceItemDetails>();
int itemCount = 0;
foreach (var item in _objCreateInvoice._objOrderItem)
{
int intlocalInvoiceItemID = intInvoiceItemID + itemCount;
_context.tbl_InvoiceItemDetails.Add(new tbl_InvoiceItemDetails
{
InvoiceItemID = intlocalInvoiceItemID,
InvoiceNo = strInvoiceNo,
Amount = item.Amount,
ArtDesc = item.ArtDesc,
ArtNo = item.ArtNo,
Quantity = item.Quantity,
Rate = item.Rate,
RefileInk = item.RefileInk,
WorkOrderDesc = item.WorkOrderDesc
});
itemCount++;
}
//}
_context.SaveChanges();
_objCreateInvoice.Code = Models.MessageCode.Success;
_objCreateInvoice.MessageText = strInvoiceNo + " has been created successfully.";
_objCreateInvoice.InvoiceNo = strInvoiceNo;
}
else
{
_objCreateInvoice.Code = Models.MessageCode.Error;
_objCreateInvoice.MessageText = "Not Created. Pleases contact administor !!";
}
}
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return(_objCreateInvoice);
}
public static async Task <CdmEntityDefinition> FromData(CdmCorpusContext ctx, LocalEntity obj, List <CdmTraitDefinition> extensionTraitDefList, List <CdmTraitDefinition> localExtensionTraitDefList)
{
var entity = ctx.Corpus.MakeObject <CdmEntityDefinition>(CdmObjectType.EntityDef, obj.Name);
if (!string.IsNullOrWhiteSpace(obj.Description))
{
entity.Description = obj.Description;
}
await Utils.ProcessAnnotationsFromData(ctx, obj, entity.ExhibitsTraits);
if (obj.Attributes != null)
{
foreach (dynamic attribute in obj.Attributes)
{
var typeAttribute = await TypeAttributePersistence.FromData(ctx, attribute, extensionTraitDefList, localExtensionTraitDefList);
if (typeAttribute != null)
{
entity.Attributes.Add(typeAttribute);
}
else
{
Logger.Error(nameof(EntityPersistence), (ResolveContext)ctx, "There was an error while trying to convert model.json attribute to cdm attribute.");
return(null);
}
}
}
ExtensionHelper.ProcessExtensionFromJson(ctx, obj, entity.ExhibitsTraits, extensionTraitDefList, localExtensionTraitDefList);
return(entity);
}
public static async Task<CdmDocumentDefinition> FromData(CdmCorpusContext ctx, LocalEntity obj, List<CdmTraitDefinition> extensionTraitDefList, List<CdmTraitDefinition> localExtensionTraitDefList)
{
var docName = $"{obj.Name}.cdm.json";
var document = ctx.Corpus.MakeObject<CdmDocumentDefinition>(CdmObjectType.DocumentDef, docName);
// import at least foundations
document.Imports.Add("cdm:/foundations.cdm.json");
var entity = await EntityPersistence.FromData(ctx, obj, extensionTraitDefList, localExtensionTraitDefList);
if (entity == null)
{
Logger.Error(nameof(DocumentPersistence), ctx, "There was an error while trying to convert a model.json entity to the CDM entity.");
return null;
}
if (obj.Imports != null)
{
foreach (var import in obj.Imports)
{
if (import.CorpusPath?.Equals("cdm:/foundations.cdm.json") == true)
{
// don't add foundations twice
continue;
}
document.Imports.Add(CdmFolder.ImportPersistence.FromData(ctx, import));
}
}
document.Definitions.Add(entity);
return document;
}
public static async Task <CdmLocalEntityDeclarationDefinition> FromData(CdmCorpusContext ctx, CdmFolderDefinition documentFolder, LocalEntity obj, List <CdmTraitDefinition> extensionTraitDefList, CdmManifestDefinition manifest)
{
var localEntity = ctx.Corpus.MakeObject <CdmLocalEntityDeclarationDefinition>(CdmObjectType.LocalEntityDeclarationDef, obj.Name);
var localExtensionTraitDefList = new List <CdmTraitDefinition>();
var entityDoc = await DocumentPersistence.FromData(ctx, obj, extensionTraitDefList, localExtensionTraitDefList);
documentFolder.Documents.Add(entityDoc);
// Entity schema path is the path to the doc containing the entity definition.
localEntity.EntityPath = ctx.Corpus.Storage.CreateRelativeCorpusPath($"{entityDoc.AtCorpusPath}/{obj.Name}", manifest);
localEntity.Explanation = obj.Description;
localEntity.LastChildFileModifiedTime = obj.LastChildFileModifiedTime;
localEntity.LastFileModifiedTime = obj.LastFileModifiedTime;
localEntity.LastFileStatusCheckTime = obj.LastFileStatusCheckTime;
if (obj.IsHidden == true)
{
var isHiddenTrait = ctx.Corpus.MakeRef <CdmTraitReference>(CdmObjectType.TraitRef, "is.hidden", true);
isHiddenTrait.IsFromProperty = true;
localEntity.ExhibitsTraits.Add(isHiddenTrait);
}
// Add traits for schema entity info.
if (obj.Schemas != null)
{
var t2pm = new TraitToPropertyMap(localEntity);
t2pm.UpdatePropertyValue("cdmSchemas", obj.Schemas);
}
// Data partitions are part of the local entity, add them here.
if (obj.Partitions != null)
{
foreach (var element in obj.Partitions)
{
var cdmPartition = await DataPartitionPersistence.FromData(ctx, element, extensionTraitDefList, localExtensionTraitDefList, documentFolder);
if (cdmPartition != null)
{
localEntity.DataPartitions.Add(cdmPartition);
}
else
{
Logger.Error((ResolveContext)ctx, Tag, nameof(FromData), null, CdmLogCode.ErrPersistModelJsonDocConversionError);
return(null);
}
}
}
List <CdmImport> importDocs = await ExtensionHelper.StandardImportDetection(ctx, extensionTraitDefList, localExtensionTraitDefList);
ExtensionHelper.AddImportDocsToManifest(ctx, importDocs, entityDoc);
return(localEntity);
}
public void SDXThread(object sender)
{
float progress = 0.0f;
while (IsRunning)
{
GameHandle = GameProcess.MainWindowHandle;
if (GameProcess.HasExited)
{
IsRunning = false;
}
// get the coords of the csgo window
GetWindowRect(GameHandle, out WindowBounds);
// set the location of the form overlay
try
{
if (WindowBounds.X != Location.X || WindowBounds.Width != Size.Width)
{
Location = new System.Drawing.Point(WindowBounds.X, WindowBounds.Y);
Size = new System.Drawing.Size(WindowBounds.Width, WindowBounds.Height);
}
}
catch { }
// set the size of the form overlay
WindowSize = new Size2(WindowBounds.Width, WindowBounds.Height);
RenderDevice.BeginDraw();
RenderDevice.Clear(Color.Transparent);
RenderDevice.TextAntialiasMode = TextAntialiasMode.Aliased; // you can set another text mode
//place your rendering things here
if (GetActiveWindowTitle() == "Counter-Strike: Global Offensive" || GetActiveWindowTitle() == "Dolphin")
{
Mem.StartProcess();
// Create Local Entity
LocalEntity LE = new LocalEntity();
// update viewmatrix
ViewMatrix = Matrix4x4.ReadMatrix(Mem, dwClient + dwViewMatrix);
// Update radar image (in case of map change)
if (RadarEnabled)
{
RadarImageUpdate();
}
// perform this loop for every entity in the game
for (int i = 0; i < 32; i++)
{
// increment rainbow cycle colour
progress += 0.00001f;
// create new entity instance
Entity Entity = new Entity(i);
// Call Radar if enabled on GUI
if (RadarEnabled)
{
RadarLoop(Entity, LE);
}
// Call ESP if enabled on GUI
if (BoxESPEnabledFriendly || BoxESPEnabledOpposition || SkeletonsEnabledFriendly || SkeletonsEnabledOpposition)
{
ESPLoop(Entity, LE, progress);
}
// Draw HP Label if enabled on GUI
if (IsEnabled_EnemyHPLabel && Entity.Entity_Team != LE.LocalEntity_Team && Entity.Entity_isAlive())
{
Drawing2D.DrawShadowText(Entity.Entity_Position_W2S.X - 20, Entity.Entity_Position_W2S.Y, 12.0f, Color.Lime, ("《 ❤ " + Entity.Entity_Health + " 》"));
}
// Draw Glow if enabled on GUI
if (GlowEnabledOpposition || GlowEnabledFriendly)
{
DoGlow(Mem, Entity, LE, progress);
}
// Call trigger if enabled on GUI
if (IsEnabled_TriggerBot)
{
TriggerbotLoop(LE);
}
}
Thread.Sleep(1);
}
RenderDevice.EndDraw();
}
}
public static async Task <CdmDocumentDefinition> FromData(CdmCorpusContext ctx, LocalEntity obj, List <CdmTraitDefinition> extensionTraitDefList, List <CdmTraitDefinition> localExtensionTraitDefList)
{
var docName = $"{obj.Name}.cdm.json";
var document = ctx.Corpus.MakeObject <CdmDocumentDefinition>(CdmObjectType.DocumentDef, docName);
// import at least foundations
document.Imports.Add("cdm:/foundations.cdm.json");
var entity = await EntityPersistence.FromData(ctx, obj, extensionTraitDefList, localExtensionTraitDefList);
if (entity == null)
{
Logger.Error(ctx, Tag, nameof(FromData), null, CdmLogCode.ErrPersistModelJsonEntityConversionError, obj.Name);
return(null);
}
if (obj.Imports != null)
{
foreach (var import in obj.Imports)
{
if (import.CorpusPath?.Equals("cdm:/foundations.cdm.json") == true)
{
// don't add foundations twice
continue;
}
document.Imports.Add(CdmFolder.ImportPersistence.FromData(ctx, import));
}
}
document.Definitions.Add(entity);
return(document);
}
