public async Task <ActionResult <AdjustmentItem> > inventory_adjustments_getId(string id)
{
string sessionID
= Request.Headers["Session-ID"];
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_adjustments_get", new
{
id = id
});
query += DataAccess.DataQuery.Create("dms", "ws_stocks_list_by_permission");
query += DataAccess.DataQuery.Create("dms", "ws_categories_get", new
{
module = "adjustment_reasons"
});
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
var result = new AdjustmentItem();
if (ds.Tables[0].ToModel <Adjustment>().Count > 0)
{
result.adjustment = ds.Tables[0].ToModel <Adjustment>()[0];
result.adjustment.products = ds.Tables[1].ToModel <Product>();
}
result.stocks = ds.Tables[2].ToModel <Stock>();
result.adjustment_reasons = ds.Tables[3].ToModel <Category>();
return(result);
}
}
private async void Button_Clicked(object sender, EventArgs e)
{
var query = TrilmDataAccess.DataQuery.Create("Security", "ws_Session_List", new
{
FacID = 2
});
query += TrilmDataAccess.DataQuery.Create("Security", "ws_Permissions_Save", new
{
FacID = 1,
UserID="",
PermissionID=""
});
var watch = System.Diagnostics.Stopwatch.StartNew();
var result = await clientServices.ExecuteAsync(query);
watch.Stop();
var elapsedMs = watch.ElapsedMilliseconds;
if(clientServices.LastError=="")
{
lblStatus.Text = string.Format("Return rows {2}.Execution time of a method {0} s {1} ms: ",watch.Elapsed.Seconds,watch.Elapsed.Milliseconds,result.Tables[0].Rows.Count+ result.Tables[1].Rows.Count);
}
else
{
lblStatus.Text = clientServices.LastError;
}
}
public async Task <ActionResult> inventory_adjustments_dieuchinh(
string id, string in_stock_id, int reason_id
)
{
string sessionID
= Request.Headers["Session-ID"];
ClientServices Services = new ClientServices(sessionID);
using (var reader = new StreamReader(Request.Body))
{
var body = reader.ReadToEnd();
_logger.LogInformation(body);
var query = DataAccess.DataQuery.Create("dms", "ws_adjustments_dieuchinh", new
{
id,
in_stock_id,
product_json = body,
reason_id
});
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(Ok(Services.LastError));
}
else
{
return(Ok("Ok"));
}
// Do something
}
}
public async Task <ActionResult <List <Filter> > > Get(string module)
{
string sessionID
= Request.Headers["Session-ID"];
try
{
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_filter_get", new
{
module = module
});
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
var result = new List <Filter>();
result = ds.Tables[0].ToModel <Filter>();
foreach (var item in result)
{
item.filter_expressions = JsonConvert.DeserializeObject <List <FilterExpression> >(item.expressions);
}
return(result);
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <ActionResult <Store> > GetItem(Guid store_id)
{
string sessionID
= Request.Headers["Session-ID"];
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_stores_get", new
{
id = store_id
});
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
if (ds.Tables[0].Rows.Count > 0)
{
return(ds.Tables[0].ToModel <Store>()[0]);
}
else
{
return new Store()
{
id = Guid.NewGuid().ToString(), is_active = true
}
};
}
}
public async Task <ActionResult <Visit> > GetItem(String id)
{
string sessionID
= Request.Headers["Session-ID"];
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_visits_get", new
{
id = id
});
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
var visit = ds.Tables[0].ToModel <Visit>()[0];
if (ds.Tables[1].Rows.Count > 0)
{
var order = ds.Tables[1].ToModel <Order>()[0];
order.products = ds.Tables[2].ToModel <Product>();
visit.order = order;
}
List <ImageS3> image_checkin = new List <ImageS3>();
List <ImageS3> image_checkout = new List <ImageS3>();
foreach (DataRow row in ds.Tables[3].Rows)
{
if (row["type"].ToString() == "Check-in")
{
image_checkin.Add(new ImageS3()
{
path = row["server_path"].ToString()
});
}
if (row["type"].ToString() == "Check-out")
{
image_checkout.Add(new ImageS3()
{
path = row["server_path"].ToString()
});
}
}
visit.checkin_images = image_checkin;
visit.checkout_images = image_checkout;
visit.store = ds.Tables[4].ToModel <Store>()[0];
return(visit);
}
public async Task <ActionResult <List <Stock> > > GetItem()
{
string sessionID
= Request.Headers["Session-ID"];
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_stocks_list");
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
return(ds.Tables[0].ToModel <Stock>());
}
}
public async Task <ActionResult <List <Filter> > > PostItem(string module, string id, string name)
{
string sessionID
= Request.Headers["Session-ID"];
try
{
using (var reader = new StreamReader(Request.Body))
{
var body = reader.ReadToEnd();
_logger.LogInformation(body);
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_filters_save", new
{
module,
id,
name,
filter_expression = body
});
query += DataAccess.DataQuery.Create("dms", "ws_filter_get", new
{
module = module
});
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
var result = ds.Tables[1].ToModel <Filter>();
foreach (var item in result)
{
item.filter_expressions = JsonConvert.DeserializeObject <List <FilterExpression> >(item.expressions);
}
return(result);
}
// Do something
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <ActionResult <string> > PostItem()
{
string sessionID
= Request.Headers["Session-ID"];
try
{
using (var reader = new StreamReader(Request.Body))
{
var body = reader.ReadToEnd();
_logger.LogInformation(body);
var product = JsonConvert.DeserializeObject <Product>(body);
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_products_save", new
{
id = product.id,
no = product.no,
name = product.name,
description = product.description,
unit = product.unit,
price = product.sell_price,
is_active = product.is_active,
image_path = product.image_path
});
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
return(Ok("Ok"));
}
// Do something
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <ActionResult <string> > GetItem(string username, string password)
{
string sessionID = Guid.NewGuid().ToString();
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_users_login_web", new
{
user_name = username,
password_hash = password.GetMd5Hash()
});
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
return(ds.Tables[0].Rows[0][0].ToString());
}
}
public async Task <ActionResult <List <Product> > > GetItem(string stock_id_in = "00000000-0000-0000-0000-000000000000", string stock_id_out = "00000000-0000-0000-0000-000000000000")
{
string sessionID
= Request.Headers["Session-ID"];
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_products_list", new
{
stock_id_in,
stock_id_out
});
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
return(ds.Tables[0].ToModel <Product>());
}
}
public async Task <ActionResult <string> > ListItems(string phieu_xuat_id, int status)
{
string sessionID
= Request.Headers["Session-ID"];
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_phieu_xuat_approved", new
{
phieu_xuat_id = phieu_xuat_id,
status
});
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
return("Ok");
}
}
public async Task <ActionResult <string> > PostItem(string import_stock_id, string export_stock_id, string phieu_nhap_id, string phieu_xuat_id)
{
string sessionID
= Request.Headers["Session-ID"];
try
{
using (var reader = new StreamReader(Request.Body))
{
var body = reader.ReadToEnd();
_logger.LogInformation(body);
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_phieu_xuat_detail_save", new
{
import_stock_id,
export_stock_id,
phieu_nhap_id,
phieu_xuat_id,
type = 1,
product_json = body
});
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
return(Ok("Ok"));
}
// Do something
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <ActionResult <List <Visit> > > getAll(string searchText = "", string filter = "[]")
{
if (!Request.Headers.ContainsKey("Session-ID"))
{
return(BadRequest("Token faild"));
}
string sessionID
= Request.Headers["Session-ID"];
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_visits_list", new
{
filter_expression = filter,
search_text = searchText
});
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
return(ds.Tables[0].ToModel <Visit>());
}
public async Task <ActionResult <List <FilterFieldNameValues> > > GetValues(string module)
{
var result = new List <FilterFieldNameValues>();
string sessionID
= Request.Headers["Session-ID"];
try
{
ClientServices Services = new ClientServices(sessionID);
if (module == "inventory_adjustments")
{
var query = DataAccess.DataQuery.Create("dms", "ws_stocks_list_by_permission");
query += DataAccess.DataQuery.Create("dms", "ws_categories_get", new
{
module = "adjustment_reasons"
});
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
var stocks = new List <FilterValue>();
foreach (DataRow row in ds.Tables[0].Rows)
{
var stock = new FilterValue();
stock.id = row["id"].ToString();
stock.value = row["name"].ToString();
stocks.Add(stock);
}
result.Add(new FilterFieldNameValues()
{
field_name = "stock_id",
filter_values = stocks
});
var adjustment_reasons = new List <FilterValue>();
foreach (DataRow row in ds.Tables[1].Rows)
{
var item = new FilterValue();
item.id = row["id"].ToString();
item.value = row["name"].ToString();
adjustment_reasons.Add(item);
}
result.Add(new FilterFieldNameValues()
{
field_name = "adjustment_reason_id",
filter_values = adjustment_reasons
});
}
}
if (module == "inventory_transactions")
{
var query = DataAccess.DataQuery.Create("dms", "ws_stocks_list_by_permission");
query += DataAccess.DataQuery.Create("dms", "ws_products_list");
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
var stocks = new List <FilterValue>();
foreach (DataRow row in ds.Tables[0].Rows)
{
var item = new FilterValue();
item.id = row["id"].ToString();
item.value = row["name"].ToString();
stocks.Add(item);
}
var products = new List <FilterValue>();
foreach (DataRow row in ds.Tables[1].Rows)
{
var item = new FilterValue();
item.id = row["id"].ToString();
item.value = row["name"].ToString();
products.Add(item);
}
result.Add(new FilterFieldNameValues()
{
field_name = "stock_id",
filter_values = stocks
});
result.Add(new FilterFieldNameValues()
{
field_name = "product_id",
filter_values = products
});
}
}
if (module == "inventory_purchase_orders")
{
var query = DataAccess.DataQuery.Create("dms", "ws_stocks_list_by_permission");
query += DataAccess.DataQuery.Create("dms", "ws_purchase_order_status_list");
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
var stocks = new List <FilterValue>();
foreach (DataRow row in ds.Tables[0].Rows)
{
var stock = new FilterValue();
stock.id = row["id"].ToString();
stock.value = row["name"].ToString();
stocks.Add(stock);
}
result.Add(new FilterFieldNameValues()
{
field_name = "stock_id",
filter_values = stocks
});
var purchase_order_status = new List <FilterValue>();
foreach (DataRow row in ds.Tables[1].Rows)
{
var item = new FilterValue();
item.id = row["id"].ToString();
item.value = row["name"].ToString();
purchase_order_status.Add(item);
}
result.Add(new FilterFieldNameValues()
{
field_name = "purchase_order_status_id",
filter_values = purchase_order_status
});
}
}
if (module == "orders")
{
var query = DataAccess.DataQuery.Create("dms", "ws_stocks_list_by_permission");
//query += DataAccess.DataQuery.Create("dms", "ws_purchase_order_status_list");
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
var stocks = new List <FilterValue>();
foreach (DataRow row in ds.Tables[0].Rows)
{
var stock = new FilterValue();
stock.id = row["id"].ToString();
stock.value = row["name"].ToString();
stocks.Add(stock);
}
result.Add(new FilterFieldNameValues()
{
field_name = "stock_id",
filter_values = stocks
});
var exportStatus = new List <FilterValue>();
var item = new FilterValue();
item.id = "0";
item.value = "Chưa xuất";
exportStatus.Add(item);
var item2 = new FilterValue();
item2.id = "1";
item2.value = "Đã xuất";
exportStatus.Add(item2);
result.Add(new FilterFieldNameValues()
{
field_name = "is_export_stock",
filter_values = exportStatus
});
}
}
if (module == "visits")
{
var query = DataAccess.DataQuery.Create("dms", "ws_stores_list");
//query += DataAccess.DataQuery.Create("dms", "ws_purchase_order_status_list");
var ds = await Services.ExecuteAsync(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
else
{
var stores = new List <FilterValue>();
foreach (DataRow row in ds.Tables[0].Rows)
{
var store = new FilterValue();
store.id = row["id"].ToString();
store.value = row["name"].ToString();
stores.Add(store);
}
result.Add(new FilterFieldNameValues()
{
field_name = "store_id",
filter_values = stores
});
}
}
return(result);
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
