public async Task <IActionResult> CreateRetail([FromForm] RetailViewModel model)
{
try
{
if (_groupRepository.GetGroup(model.GroupId) == null)
{
return(Error((int)HttpStatusCode.BadRequest));
}
await _retailRepository.AddRetail(new RetailModel()
{
Name = model.Name,
GroupId = model.GroupId,
CreateDate = DateTime.Now,
ModificationDate = DateTime.Now
});
_eventLog.EventPublish("Create: ", $"{model.RetailId} : {model.Name} at {DateTime.Now}");
return(Ok(model.Name + " Successfully created"));
}
catch (Exception ex)
{
return(Error((int)HttpStatusCode.BadRequest, ex));
}
}
public invoive_No()
{
NpgsqlConnection connection = new NpgsqlConnection(connstring);
connection.Open();
NpgsqlCommand cmd_ad_user_pos_check = new NpgsqlCommand("SELECT " + "t1.ad_client_id, " + "t1.ad_org_id, " + "t1.ad_role_id, " + //2
"t1.ad_user_id," + "t1.c_bpartner_id, " + "t1.m_warehouse_id," + "t1.name, " + "t1.password," + "t1.sessionid ," +
"t2.name as ad_org_name, " + "t2.arabicname as ad_org_arabicname, " +
"t2.logo as ad_org_logo, " + "t2.phone as ad_org_phone, " +
"t2.email as ad_ord_email, " + "t2.address as ad_ord_add, " +
"t2.city as ad_org_city, " + "t2.country as ad_org_country, " +
"t2.postal as ad_org_postal, " + "t2.weburl as ad_org_weburl , " +
"t2.footermessage as ad_org_footermessage, " + "t2.arabicfootermessage as ad_org_arabicfootermessage, " +
"t2.termsmessage as ad_ord_termsmessage, " + "t2.arabictermsmessage as ad_org_arabictermsmessage," +
"t3.name as ad_role_name, " + "t4.name as m_warehouse_name , " + "t4.phone as m_warehouse_phone, " + "t4.city as m_warehouse_city, " +
"t4.warehouepricelistid as m_warehouse_warehouepricelistid, " + "t1.attribute1 as session_start_time " +
"FROM ad_user_pos t1,ad_org t2,ad_role t3,m_warehouse t4 " +
"where t1.islogged = 'Y' AND t1.isactive = 'Y' AND t1.ad_org_id = t2.ad_org_id " +
"AND t1.ad_client_id = t3.ad_client_id AND t1.ad_role_id = t3.ad_role_id " +
"AND t1.m_warehouse_id = t4.m_warehouse_id; ", connection);
NpgsqlDataReader _get_ad_user_pos_check = cmd_ad_user_pos_check.ExecuteReader();
if (_get_ad_user_pos_check.Read())
{
AD_Client_ID = _get_ad_user_pos_check.GetInt64(0);
AD_ORG_ID = _get_ad_user_pos_check.GetInt64(1);
AD_ROLE_ID = _get_ad_user_pos_check.GetInt64(2);
AD_USER_ID = _get_ad_user_pos_check.GetInt64(3);
AD_bpartner_Id = _get_ad_user_pos_check.GetInt64(4);
AD_Warehouse_Id = _get_ad_user_pos_check.GetInt64(5);
AD_UserName = _get_ad_user_pos_check.GetString(6);
AD_UserPassword = _get_ad_user_pos_check.GetString(7);
AD_SessionID = _get_ad_user_pos_check.GetDouble(8);
var Check_POS_Number_rs = RetailViewModel.Check_POS_Number(AD_UserName, AD_UserPassword, AD_Client_ID, AD_ORG_ID, AD_USER_ID, AD_bpartner_Id, AD_ROLE_ID, AD_Warehouse_Id, DeviceMacAdd);
string _responce_code = Check_POS_Number_rs.Item3;
bool _network_status_ = Check_POS_Number_rs.Item4;
if (_responce_code == "0" || _responce_code == "200")
{
_InvoiceNo_ = Check_POS_Number_rs.Item1;
_doc_no_or_error_code = Check_POS_Number_rs.Item2;
}
}
}
public async Task <IActionResult> EditRetail(string id, [FromForm] RetailViewModel model)
{
try
{
if (_groupRepository.GetGroup(model.GroupId) == null)
{
return(Error((int)HttpStatusCode.BadRequest));
}
await _retailRepository.UpdateRetail(model.RetailId, model.Name, model.GroupId);
_eventLog.EventPublish("Edited : ", $"{model.RetailId} : {model.Name} at {DateTime.Now}");
return(Ok());
}
catch (Exception ex)
{
return(Error((int)HttpStatusCode.BadRequest, ex));
}
}
public MainViewModel()
{
Consumption = new ConsumptionViewModel(new ConsumersService());
Production = new ProductionViewModel(new ProductionService());
Retail = new RetailViewModel();
}
