public async Task <ActionResult> Logout()
{
await HttpContext.SignOutAsync();
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]Logout Done:[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
return(Ok());
}
public IActionResult GenPURItem([FromBody] JArray values)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenPURItem:[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
GenHelper.WriteLog("[Json]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenPURItem:[" + Environment.NewLine + values.ToString() + Environment.NewLine + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
PurchaseReturnDetail dtl;
string temp = "";
JToken token;
foreach (JObject Jdtl in values.Children())
{
dtl = objectSpace.CreateObject <PurchaseReturnDetail>();
temp = Jdtl["Baseline"].ToString();
dtl.Baseline = int.Parse(temp);
if (Jdtl.ContainsKey("BaseDocNo"))
{
temp = Jdtl["BaseDocNo"].ToString();
dtl.BaseDocNo = temp;
}
temp = DocTypeCodes.PurchaseDelivery;
dtl.BaseType = objectSpace.FindObject <DocType>(CriteriaOperator.Parse("BoCode=?", temp));
temp = Jdtl["Quantity"].ToString();
dtl.Quantity = double.Parse(temp);
if (Jdtl.ContainsKey("BatchNumber"))
{
if (Jdtl["BatchNumber"] != null)
{
temp = Jdtl["BatchNumber"].ToString();
}
if (!string.IsNullOrEmpty(temp))
{
dtl.BatchNumber = temp;
}
}
token = Jdtl["BinCode"];
temp = token["BoKey"].ToString();
dtl.BinCode = objectSpace.FindObject <vwWarehouseBins>(CriteriaOperator.Parse("BoKey=?", temp));
token = Jdtl["LineVendor"];
temp = token["BoKey"].ToString();
dtl.LineVendor = objectSpace.FindObject <vwBusinessPartners>(CriteriaOperator.Parse("BoKey=?", temp));
}
objectSpace.CommitChanges();
return(Ok());
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenPURItem:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public ActionResult GetWhsList(string companycode)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetWhsList(" + companycode + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
List <vwWarehouseBins> existing = objectSpace.GetObjects <vwWarehouseBins>(CriteriaOperator.Parse("CompanyCode=? and BinAbsEntry=0", companycode)).ToList();
return(Ok(existing));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetWhsList(" + companycode + "):[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public IActionResult Get()
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Get:[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
IQueryable <PurchaseReturnDetail> employees = objectSpace.GetObjectsQuery <PurchaseReturnDetail>();
return(Ok(employees));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Get:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public ActionResult Add([FromBody] JObject values)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Post:[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
PurchaseReturnDetail employee = objectSpace.CreateObject <PurchaseReturnDetail>();
JsonParser.ParseJObjectXPO <PurchaseReturnDetail>(values, employee, objectSpace);
objectSpace.CommitChanges();
return(Ok(employee));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Post:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public ActionResult Get(string bokey)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Get(" + bokey + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
vwWarehouseBins existing = objectSpace.FindObject <vwWarehouseBins>(CriteriaOperator.Parse("BoKey=?", bokey));
if (existing == null)
{
NotFound();
}
return(Ok(existing));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Get(" + bokey + "):[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public ActionResult Get(int id)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Get(" + id.ToString() + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
PurchaseReturnDetail existing = objectSpace.GetObjectByKey <PurchaseReturnDetail>(id);
if (existing == null)
{
NotFound();
}
return(Ok(existing));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Get(" + id.ToString() + "):[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public ActionResult SupplierList(string companycode)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-SupplierList(" + companycode + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
List <vwBusinessPartners> existing = objectSpace.GetObjects <vwBusinessPartners>(CriteriaOperator.Parse("CompanyCode=? and CardType=?", companycode, "S")).ToList();
if (existing == null)
{
NotFound();
}
return(Ok(existing));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-SupplierList(" + companycode + "):[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public IActionResult GetPURItem(string username)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetPURItem(" + username + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
List <PurchaseReturnDetail> obj = objectSpace.GetObjects <PurchaseReturnDetail>(CriteriaOperator.Parse("[CreateUser.UserName]=? and isnull([PurchaseReturn])", username)).ToList();
if (obj == null)
{
return(NotFound());
}
return(Ok(obj));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetPURItem:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public IActionResult GetGRNItemCount(string username)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetGRNItemCount(" + username + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
int cnt = 0;
List <PurchaseDeliveryDetail> obj = objectSpace.GetObjects <PurchaseDeliveryDetail>(CriteriaOperator.Parse("[CreateUser.UserName]=? and isnull([PurchaseDelivery])", username)).ToList();
if (obj != null)
{
cnt = obj.Count;
}
return(Ok(cnt));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetGRNItemCount:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public ActionResult Update(int id, [FromBody] JObject values)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Put(" + id.ToString() + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
PurchaseReturnDetail employee = objectSpace.GetObjectByKey <PurchaseReturnDetail>(id);
if (employee != null)
{
JsonParser.ParseJObjectXPO <PurchaseReturnDetail>(values, employee, objectSpace);
objectSpace.CommitChanges();
return(Ok(employee));
}
return(NotFound());
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Put(" + id.ToString() + "):[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public ActionResult Delete(int id)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Delete(" + id.ToString() + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
PurchaseDeliveryDetail existing = objectSpace.GetObjectByKey <PurchaseDeliveryDetail>(id);
if (existing != null)
{
objectSpace.Delete(existing);
objectSpace.CommitChanges();
return(NoContent());
}
return(NotFound());
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-Delete(" + id.ToString() + "):[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public ActionResult Login([FromBody] UserLogin data)
{
try
{
ActionResult result;
string userName = data.UserName;
string password = data.Password;
if (securityProvider.InitConnection(userName, password))
{
result = Ok();
GenHelper.WriteLog("[Log]", "[" + userName + "]Login Done:[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
}
else
{
result = Unauthorized();
}
return(result);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public IActionResult GetOpenPOItem(string cardcodekey)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetOpenPOItem(" + cardcodekey + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
List <PurchaseOrderDetail> obj;
if (GenHelper.LiveWithPost)
{
obj = objectSpace.GetObjects <PurchaseOrderDetail>(CriteriaOperator.Parse("!isnull([PurchaseOrder]) and [PurchaseOrder.CardCode.BoKey]=? and [PurchaseOrder.DocStatus.CurrDocStatus] in (?) and [Quantity] > [CopyQty] and [VerNo] = [PostVerNo]", cardcodekey, DocStatus.Accepted)).OrderBy(pp => pp.PurchaseOrder.DocNo).ToList();
}
else
{
obj = objectSpace.GetObjects <PurchaseOrderDetail>(CriteriaOperator.Parse("!isnull([PurchaseOrder]) and [PurchaseOrder.CardCode.BoKey]=? and [PurchaseOrder.DocStatus.CurrDocStatus] in (?) and [Quantity] > [CopyQty]", cardcodekey, DocStatus.Accepted)).OrderBy(pp => pp.PurchaseOrder.DocNo).ToList();
}
return(Ok(obj));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetOpenPOItem:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public IActionResult GetOpenGRNItemByDoc(string docno)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetOpenGRNItemByDoc(" + docno + "):[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
List <PurchaseDeliveryDetail> obj;
if (GenHelper.LiveWithPost)
{
obj = objectSpace.GetObjects <PurchaseDeliveryDetail>(CriteriaOperator.Parse("!isnull([PurchaseDelivery]) and [PurchaseDelivery.DocNo]=? and [PurchaseDelivery.DocStatus.CurrDocStatus]=? and [PurchaseDelivery.DocStatus.IsSAPPosted]=1 and [Quantity] > [CopyQty] and [VerNo] = [PostVerNo]", docno, DocStatus.Posted)).OrderBy(pp => pp.PurchaseDelivery.DocNo).ToList();
}
else
{
obj = objectSpace.GetObjects <PurchaseDeliveryDetail>(CriteriaOperator.Parse("!isnull([PurchaseDelivery]) and [PurchaseDelivery.DocNo]=? and [PurchaseDelivery.DocStatus.CurrDocStatus] in (?,?) and [Quantity] > [CopyQty]", docno, DocStatus.Accepted, DocStatus.Posted)).OrderBy(pp => pp.PurchaseDelivery.DocNo).ToList();
}
return(Ok(obj));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GetOpenGRNItemByDoc:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
public IActionResult GenGRN([FromBody] JObject values)
{
try
{
GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
GenHelper.WriteLog("[Json]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[" + Environment.NewLine + values.ToString() + Environment.NewLine + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
//
//JsonParser.ParseJObjectXPO<PurchaseDelivery>(values, employee, objectSpace);
string temp = "";
JToken token;
PurchaseDelivery employee = objectSpace.CreateObject <PurchaseDelivery>();
token = values["CardCode"];
temp = token["BoKey"].ToString();
employee.CardCode = objectSpace.FindObject <vwBusinessPartners>(CriteriaOperator.Parse("BoKey=?", temp));
employee.NumAtCard = values["NumAtCard"].ToString();
//JsonPopulateObjectHelper.PopulateObjectWODetail(values.ToString(), employee.Session, employee);
string detalclassname = "PurchaseDeliveryDetail";
int intkeyvalue = -1;
JArray jarray = (JArray)values[detalclassname];
int cnt = 0;
foreach (JObject Jdtl in jarray.Children())
{
if (Jdtl.ContainsKey("Oid"))
{
if (int.TryParse(Jdtl["Oid"].ToString(), out intkeyvalue))
{
PurchaseDeliveryDetail dtl = objectSpace.GetObjectByKey <PurchaseDeliveryDetail>(intkeyvalue);
cnt++;
dtl.VisOrder = cnt;
dtl.VerNo = 1;
employee.PurchaseDeliveryDetail.Add(dtl);
}
else
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[Details Key value is invalid][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception("Details Key value is invalid");
}
}
else
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[Details Key Column Not found][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception("Details Key Column Not found");
}
}
if (employee.DocTypeSeries == null)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[Document series is not found][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception("Document series is not found");
}
employee.DocStatus.AddDocStatus(DocStatus.Accepted, "WebApi Generated");
employee.DocStatus.CurrDocStatus = DocStatus.Accepted;
employee.VerNo = 1;
employee.AssignDocNumber();
objectSpace.CommitChanges();
return(Ok(employee.DocNum));
}
catch (Exception ex)
{
GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]");
throw new Exception(ex.Message);
}
}
