Skip to content

Instantly share code, notes, and snippets.

View Taifunov's full-sized avatar
🏠
Working from home

Yaroslav Husynin Taifunov

🏠
Working from home
3 followers · 4 following
View GitHub Profile
@Taifunov
Taifunov / StringCSVToJSON.cs
Created May 5, 2021 08:55
Serialization issues
public static string StringCsvToJson()
{
var text = "\"ExecuteStatus\",\"ExecuteTime\",\"ExecuteMessege\",\"ExecuteEntityID\",\"Comment\",\"Disabled\",\"Hello\",\"ExecuteDetails\"\r\n\"0\",\"\",\"\",\"\",\"qwerty\",\"zxcvbn\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"qwerty\",\"zxcvbn\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"yuiop\",\"cvbnm\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"qwerty\",\"zxcvbn\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"yuiop\",\"cvbnm\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"qwerty\",\"zxcvbn\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"yuiop\",\"cvbnm\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"qwerty\",\"zxcvbn\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"yuiop\",\"cvbnm\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"qwerty\",\"zxcvbn\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"yuiop\",\"cvbnm\",\"parameter\",\"\"\r\n\"0\",\"\",\"\",\"\",\"summ test\",\"summ test\",\"parameter\",\"\"\r\n";
using var sr = new StringReade
@Taifunov
Taifunov / gist:c75d6d3d7ed6a32c2e9fdae24f24ae22
Created April 21, 2021 15:51
Result
[
{
"id": 0,
"title": "Return_To_WS",
"content": [
{
"Key": "ExecuteStatus",
"Value": "0"
},
{
@Taifunov
Taifunov / gist:b904a0d4d66a405e88c5be151083c1ce
Last active April 21, 2021 14:14
Результат форича
function getSummaryReportSchema(transactionid) {
transactionService.getSummaryReportSchema(transactionid, orgName)
.then((result) => {
log(JSON.stringify(result))
result.forEach(element => {
let values = element.Values;
vm.masterDetailResults.push(values);
vm.tabs.push({
title: element.TaskName
});
@Taifunov
Taifunov / file.js
Created January 30, 2020 21:39
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<script src="https://cdn.jsdelivr.net/npm/vue/dist/vue.js"></script>
<script src="https://unpkg.com/axios@0.19.2/dist/axios.min.js"></script>
<title>Document</title>
</head>
@Taifunov
Taifunov / postMessage.cs
Created January 2, 2020 20:58
internal async Task PostPhotoAsync(Photo instance)
{
try
{
var getById = _parser.GetById();
var descrs = _parser.GetDescription();
for (var i = 0; i < getById.Count && i < descrs.Count; i++)
{
string photo = getById[i];
var descr = descrs[i];
@Taifunov
Taifunov / updatePost.cs
Created September 17, 2019 13:44
public static PostData UpdatePostData(MyContext context, int messageId, bool isLiked)
{
var post = context.Posts
.FirstOrDefault(x => x.MessageId == messageId);
if (isLiked)
{
var likesCount = context.Posts
.Where(x => x.MessageId == messageId)
.Select(x => x.Likes)
@Taifunov
Taifunov / MyContext.cs
Last active September 7, 2019 17:50
public sealed class MyContext : DbContext
{
public DbSet<PostData> Posts { get; set; }
public DbSet<VoteData> Votes { get; set; }
public MyContext(DbContextOptions<MyContext> options) : base(options)
{
}
@Taifunov
Taifunov / dbislocked
Created August 26, 2019 15:04
public static PostData UpdatePostData(SQLiteConnection conn, int messageId, bool isLiked)
{
PostData postData;
if (isLiked)
{
conn.Open();
var likesCount = conn.ExecuteReader("SELECT (Likes) FROM PostData AS pd WHERE pd.MessageId = @MessageId", new { messageId }).Parse<int>().FirstOrDefault();
conn.Close();
var temp = 1;
if (likesCount > 0)
@Taifunov
Taifunov / dbContext
Created August 25, 2019 07:26
public class MyDbContext : DbContext
{
public DbSet<Car> Cars { get; set; }
public DbSet<Customer> Customers { get; set; }
public DbSet<CarMark> CarsMarks { get; set; }
public MyDbContext()
{
Database.EnsureCreated();
}
@Taifunov
Taifunov / postData
Last active August 19, 2019 18:31
public static PostData UpdatePostData(SQLiteConnection conn, int messageId, bool isLiked)
{
PostData postData;
if (isLiked)
{
var likesCount = conn.ExecuteReader("SELECT (Likes) FROM PostData AS pd WHERE pd.MessageId = @MessageId", new { messageId }).Parse<int>().FirstOrDefault();
var temp = 1;
if (likesCount > 0)
{
temp = likesCount++;