public async Task <ActionResult <LoginResponse> > Login(Login data)
{
string cfg_key = _config.GetValue <string>("api_key:key");
string json = string.Empty;
json = Newtonsoft.Json.JsonConvert.SerializeObject(data);
_log.LogInformation("Request login <==" + json);
fData _res = new fData();
ActionResult response = Unauthorized();
CryptLib scry = new CryptLib();
try
{
if (key == cfg_key)
{
string desc = scry.decrypt(data.password);
var result = await _db.getlogin(data.username, data.password);
if (result != null)
{
result.token = GenerateToken(data);
_res = new fData();
_res.data = result;
_res.rc = "00";
_res.desc = "Login berhasil dilakukan";
response = Ok(_res);
}
else
{
_res = new fData();
_res.data = result;
_res.rc = "05";
_res.desc = "Login gagal dilakukan";
response = StatusCode(400, _res);
}
}
else
{
_res = new fData();
_res.rc = "05";
_res.desc = "Apikey tidak sesuai";
response = StatusCode(401, _res);
}
}
catch (MyException ex)
{
_log.LogError(ex.Message.ToString());
_res = new fData();
_res.rc = "05";
_res.desc = "Internal system Error";
response = StatusCode(501, _res);
}
string json2 = Newtonsoft.Json.JsonConvert.SerializeObject(response);
_log.LogInformation("Response Login <== " + json2.ToString());
return(response);
}
public async Task <ActionResult <Pelanggan> > GetPelanggan()
{
string cfg_key = _config.GetValue <string>("api_key:key");
fData _res = new fData();
ActionResult response = Unauthorized();
try
{
if (key == cfg_key)
{
var result = await _db.getdata();
if (result != null)
{
_res = new fData();
_res.data = result;
_res.rc = "00";
_res.desc = "Data berhasil ditemukan";
response = Ok(_res);
}
else
{
_res = new fData();
_res.data = result;
_res.rc = "05";
_res.desc = "Data tidak ditemukan";
response = StatusCode(400, _res);
}
}
else
{
_res = new fData();
_res.rc = "05";
_res.desc = "Apikey tidak sesuai";
response = StatusCode(401, _res);
}
}
catch (MyException ex)
{
_log.LogError(ex.Message.ToString());
_res = new fData();
_res.rc = "05";
_res.desc = "Internal system Error";
response = StatusCode(501, _res);
}
string json2 = Newtonsoft.Json.JsonConvert.SerializeObject(response);
_log.LogInformation("Response Sign On to Client <== " + json2.ToString());
return(response);
}
private void uiCommandManager1_CommandClick(object sender, Janus.Windows.UI.CommandBars.CommandEventArgs e)
{
try
{
switch (e.Command.Key)
{
case "cmdToggleTooltip":
showTooltip = !showTooltip;
break;
case "cmdCompleteBF":
CurrentRow().Completed = !CurrentRow().Completed;
CurrentRow().ManuallyCompleted = CurrentRow().Completed;
break;
case "cmdSave":
Save();
break;
case "cmdHideCompletedBFs":
//JLL: 2017-01-19 - commented out line below, it got missed when commenting out the previous reference above to the binding source filter
//string basefilter = "not (isMail=1 and BFOfficerid<>" + FM.AtMng.WorkingAsOfficer.OfficerId.ToString() + ")";
if (cmdHideCompletedBFs.IsChecked)
{
activityBFBindingSource.Filter = "completed=0";
}
else
{
activityBFBindingSource.Filter = "";
}
break;
case "tsAudit":
fData fAudit = new fData(CurrentRow());
fAudit.Show();
break;
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
public static bool Get(long docProformaInvoice_ShopC_Item_ID,
ref fData ret_data)
{
string Err = null;
DataTable dt = new DataTable();
string sql = @"select dpisci.dQuantity as QuantityTakenFromStock,
s.ExpiryDate,
i.UniqueName,
st.Name as StockTakeName,
st.StockTake_Date
from DocProformaInvoice_ShopC_Item dpisci
inner join Stock s on dpisci.Stock_ID = s.ID
inner join PurchasePrice_Item ppi on s.PurchasePrice_Item_ID = ppi.ID
inner join StockTake st on ppi.StockTake_ID = st.ID
inner join Item i on ppi.Item_ID = i.ID
where dpisci.ID = " + docProformaInvoice_ShopC_Item_ID.ToString();
if (DBSync.DBSync.ReadDataTable(ref dt, sql, ref Err))
{
if (dt.Rows.Count > 0)
{
ret_data.QuantityTakenFromStock = DBTypes.tf._set_decimal(dt.Rows[0]["QuantityTakenFromStock"]);
ret_data.ExpiryDate = DBTypes.tf._set_DateTime(dt.Rows[0]["ExpiryDate"]);
ret_data.Item_UniqueName = DBTypes.tf._set_string(dt.Rows[0]["UniqueName"]);
ret_data.StockTakeName = DBTypes.tf._set_string(dt.Rows[0]["StockTakeName"]);
ret_data.StockTakeDate = DBTypes.tf._set_DateTime(dt.Rows[0]["StockTake_Date"]);
return true;
}
else
{
LogFile.Error.Show("ERROR:TangentaDB:f_DocProformaInvoice_ShopC_Item:Get:sql=" + sql + "\r\nNo docProformaInvoice_ShopC_Item data for ID = " + docProformaInvoice_ShopC_Item_ID.ToString());
return false;
}
}
else
{
LogFile.Error.Show("ERROR:TangentaDB:f_DocProformaInvoice_ShopC_Item:Get:sql=" + sql + "\r\nErr" + Err);
return false;
}
}
partial void test_core_fDataToolStripMenuItem_Click(object sender, EventArgs e)
{
string log = ""; const int m = 8, n = 4;
byte[] data = new byte[m];
Math.Daemon.Random.NextBytes(data);
log += "\nRaw Data: ";
for (int i = 0; i < data.Length; i++)
{
log += data[i].ToString() + " ";
}
byte[] labl = new byte[n];
Math.Daemon.Random.NextBytes(labl);
fData fdata = new fData(data, -2.0, 2.0, labl, -1.0, 1.0);
log += "\n\nfData...\n";
log += fdata.ToString();
richTextBox.Text = log;
}
public static bool Get(long docInvoice_ID,long docInvoice_ShopC_Item_ID, ref fData ret_data)
{
string Err = null;
DataTable dt = new DataTable();
if (ret_data == null)
{
ret_data = new fData();
}
string sql = @"select di.Draft,
di.DraftNumber,
di.FinancialYear,
di.NumberInFinancialYear,
ap.Gender,
acfn.FirstName,
acfl.LastName,
ao.Name as Organisation_Name,
ao.Tax_ID as Organisation_Tax_ID,
acp.Atom_Person_ID,
aco.Atom_Organisation_ID
from DocInvoice di
left join Atom_Customer_Person acp on di.Atom_Customer_Person_ID = acp.ID
left join Atom_Person ap on acp.Atom_Person_ID = ap.ID
left join Atom_cFirstName acfn on ap.Atom_cFirstName_ID = acfn.ID
left join Atom_cLastName acfl on ap.Atom_cLastName_ID = acfl.ID
left join Atom_Customer_Org aco on di.Atom_Customer_Org_ID = aco.ID
left join Atom_Organisation ao on aco.Atom_Organisation_ID = ao.ID
where di.ID = " + docInvoice_ID.ToString();
if (DBSync.DBSync.ReadDataTable(ref dt,sql, ref Err ))
{
if (dt.Rows.Count > 0)
{
ret_data.bDraft = DBTypes.tf._set_bool(dt.Rows[0]["Draft"]);
ret_data.DraftNumber = DBTypes.tf._set_long(dt.Rows[0]["DraftNumber"]);
ret_data.FinancialYear = DBTypes.tf._set_long(dt.Rows[0]["FinancialYear"]);
ret_data.NumberInFinancialYear = DBTypes.tf._set_long(dt.Rows[0]["NumberInFinancialYear"]);
ret_data.Addressee = "";
if (!(dt.Rows[0]["Atom_Person_ID"] is System.DBNull))
{
ret_data.Addressee = lngRPM.s_PhisycalPerson.s + ":";
bool Gender = DBTypes.tf._set_bool(dt.Rows[0]["Gender"]);
string sFirstName = DBTypes.tf._set_string(dt.Rows[0]["FirstName"]);
string sLastName = DBTypes.tf._set_string(dt.Rows[0]["LastName"]);
if (Gender)
{
ret_data.Addressee += lngRPM.s_Man.s;
}
else
{
ret_data.Addressee += lngRPM.s_Woman.s;
}
ret_data.Addressee += ":" + sFirstName + " " + sLastName;
}
else if (!(dt.Rows[0]["Atom_Organisation_ID"] is System.DBNull))
{
string s_organisation_name =
ret_data.Addressee = lngRPM.s_Organisation.s + ":" + DBTypes.tf._set_string(dt.Rows[0]["Organisation_Name"]) + " " +
lngRPM.s_Tax_ID.s + ":" + DBTypes.tf._set_string(dt.Rows[0]["Organisation_Tax_ID"]);
}
if (f_DocInvoice_ShopC_Item.Get(docInvoice_ShopC_Item_ID,
ref ret_data.ShopC_Item_Data
))
{
return true;
}
else
{
return false;
}
}
else
{
LogFile.Error.Show("ERROR:TangentaDB:f_DocInvoice:Get:sql=" + sql + "\r\nNo DocInvoice data for ID = " + docInvoice_ID.ToString());
return false;
}
}
else
{
LogFile.Error.Show("ERROR:TangentaDB:f_DocInvoice:Get:sql=" + sql + "\r\nErr" + Err);
return false;
}
}
private void uiCommandManager1_CommandClick(object sender, Janus.Windows.UI.CommandBars.CommandEventArgs e)
{
try
{
switch (e.Command.Key)
{
case "cmdUnbreak":
FM.EFile.UnBreakInherit();
if (FM.EFile.GetParentFileXref(FM.CurrentFile).secBreakInherit)
{
cmdUnbreak.Enabled = Janus.Windows.UI.InheritableBoolean.True;
tsBreakInherit.Enabled = Janus.Windows.UI.InheritableBoolean.False;
}
else
{
cmdUnbreak.Enabled = Janus.Windows.UI.InheritableBoolean.False;
tsBreakInherit.Enabled = Janus.Windows.UI.InheritableBoolean.True;
}
break;
case "tsBreakInherit":
FM.EFile.BreakInherit();
if (FM.EFile.GetParentFileXref(FM.CurrentFile).secBreakInherit)
{
cmdUnbreak.Enabled = Janus.Windows.UI.InheritableBoolean.True;
tsBreakInherit.Enabled = Janus.Windows.UI.InheritableBoolean.False;
}
else
{
cmdUnbreak.Enabled = Janus.Windows.UI.InheritableBoolean.False;
tsBreakInherit.Enabled = Janus.Windows.UI.InheritableBoolean.True;
}
break;
case "tsAdd":
lmDatasets.atriumDB.secFileRuleRow dr = (lmDatasets.atriumDB.secFileRuleRow)FM.GetsecFileRule().Add(FM.CurrentFile);
dr.FileId = FM.CurrentFile.FileId;
secFileRuleBindingSource.MoveLast();
break;
case "tsSave":
Save();
break;
case "tsCancel":
Cancel();
break;
case "tsDelete":
Delete();
break;
case "tsAudit":
fData fAudit = new fData(CurrentRow());
fAudit.Show();
break;
}
}
catch (Exception x)
{
UIHelper.HandleUIException(x);
}
}
