async void CreateQuotaField()
{
var query = DataAccess.DataQuery.Create("Docs", "ws_DOC_QuotaControlValues_Get", new
{
AnswerID
});
DataSet ds = Services.Execute(query);
if (DependencyService.Get <IDataSetExtension>().IsNull(ds) == true)
{
await DisplayAlert("Lỗi load dữ liệu", this.Services.LastError, "Ok");
return;
}
foreach (DataRow r in tblQuotaControl.Rows)
{
string oldValue = FindValue(ds.Tables[0], "FieldName", r["FieldName"].ToString(), "FieldValue");
var control = new QuotaControl(r, oldValue);
control.HorizontalOptions = LayoutOptions.FillAndExpand;
control.Orientation = StackOrientation.Vertical;
//layoutQuota.Children.Add(new QuotaControl(r, oldValue));
layoutQuota.Children.Add(control);
}
}
public async Task <ActionResult <Order> > ListItem(String order_id)
{
string sessionID
= Request.Headers["Session-ID"];
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_ordermasters_get", new
{
order_id
});
query += DataAccess.DataQuery.Create("dms", "ws_orderdetails_list", new
{
order_id
});
var ds = Services.Execute(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
if (ds.Tables[0].Rows.Count == 0)
{
return(NotFound());
}
var result = ds.Tables[0].ToModel <Order>()[0];
result.products = ds.Tables[1].ToModel <Product>();
return(result);
}
public async Task <ActionResult <List <Order> > > getAll(string searchText = "", string filter = "[]")
{
string sessionID
= Request.Headers["Session-ID"];
ClientServices Services = new ClientServices(sessionID);
var query = DataAccess.DataQuery.Create("dms", "ws_ordermasters_list",
new
{
filter_expression = filter == null ? "" : filter,
search_text = searchText == null ? "" : searchText,
});
var ds = Services.Execute(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
return(ds.Tables[0].ToModel <Order>());
}
public async Task <ActionResult <string> > PostItem(string order_id, int status, string export_stock_id = "")
{
string sessionID
= Request.Headers["Session-ID"];
ClientServices Services = new ClientServices(sessionID);
DataAccess.RequestCollection query;
if (status == 1)
{
query = DataAccess.DataQuery.Create("dms", "ws_ordermasters_export4order_approve", new
{
order_id = order_id,
export_stock_id
});
}
else
{
if (status == 2)
{
query = DataAccess.DataQuery.Create("dms", "ws_ordermasters_export4order_cancel", new
{
order_id = order_id
});
}
else
{
return(BadRequest("Không tìm thấy status"));
}
}
var ds = Services.Execute(query);
if (ds == null)
{
return(BadRequest(Services.LastError));
}
return("Ok");
}
async Task LoadRespondentList()
{
var query = DataAccess.DataQuery.Create("Docs", "ws_DOC_Answers_GetForWaitingMobile", new
{
ProjectID,
UserID = Services.GetInformation("UserID").ToString()
});
query += DataAccess.DataQuery.Create("Docs", "ws_DOC_QuotaControl_Get", new
{
ProjectID
});
query += DataAccess.DataQuery.Create("KadenceDB", "ws_L_WardDistrictCity_ListFromMobile", new
{
ProjectID,
UserID = Services.GetInformation("UserID").ToString()
});
query += DataAccess.DataQuery.Create("KadenceDB", "ws_HR_PTEProject_ListFromMobile", new
{
ProjectID,
UserID = Services.GetInformation("UserID").ToString()
});
var ds = Services.Execute(query);
if (DependencyService.Get <IDataSetExtension>().IsNull(ds) == true)
{
await DisplayAlert("Lỗi load dữ liệu", Services.LastError, "Ok");
return;
}
gData.ItemsSource = ds.Tables[0];
tblQuota = ds.Tables[1];
tblHanhChanh = ds.Tables[2];
tblNhanSu = ds.Tables[3];
}
public async void btnLogin_Clicked(object sender, EventArgs args)
{
UserDialogs.Instance.ShowLoading("Đang đăng nhập...");
var query = DataAccess.DataQuery.Create("Security", "ws_Session_AuthenticateFromMobile", new
{
Username = txtUsername.Text.Trim(),
PasswordHash = DependencyService.Get <IMd5HashExtensions>().GetMd5Hash(txtPassword.Text.Trim()),
FacID = "1"
});
var ds = Services.Execute(query);
if (DependencyService.Get <IDataSetExtension>().IsNull(ds) == true)
{
UserDialogs.Instance.HideLoading();
await DisplayAlert("Lỗi đăng nhập", Services.LastError, "Thử lại");
return;
}
if (ds.Tables[0].Rows.Count == 0)
{
UserDialogs.Instance.HideLoading();
await DisplayAlert("Lỗi phân quyền", "Bạn chưa được phân quyền dự án", "Thử lại");
return;
}
if (ds.Tables[0].Rows[0][0].ToString().ToUpper() != "OK")
{
UserDialogs.Instance.HideLoading();
await DisplayAlert("Lỗi đăng nhập", ds.Tables[0].Rows[0][0].ToString().ToUpper(), "Thử lại");
return;
}
Services.SetInformation("UserID", ds.Tables[0].Rows[0]["UserID"].ToString());
if (chkRememberPassword.Checked == true)
{
await Save(txtUsername.Text.Trim(), txtPassword.Text.Trim());
}
else
{
await Save("", "");
}
//if(Authenticated!=null)
// {
// Authenticated(this, null);
// }
if (ds.Tables[0].Rows.Count == 1)
{
//await DisplayAlert("Dự án", string.Format("Bạn đang thực hiện dự án {0}",ds.Tables[0].Rows[0]["ProjectName"].ToString()), "Ok");
Services.SetInformation("MinYOB", ds.Tables[0].Rows[0]["MinYOB"]);
Services.SetInformation("ProjectNo", ds.Tables[0].Rows[0]["ProjectNo"]);
Services.SetInformation("ProjectName", ds.Tables[0].Rows[0]["ProjectNo"]);
Services.SetInformation("MaxYOB", ds.Tables[0].Rows[0]["MaxYOB"]);
Services.SetInformation("AcceptGender", ds.Tables[0].Rows[0]["AcceptGender"]);
Services.SetInformation("MonthICMA", ds.Tables[0].Rows[0]["MonthICMA"]);
Services.SetInformation("CityHandle", ds.Tables[0].Rows[0]["CityHandle"]);
var row = ds.Tables[0].Rows[0];
var homePage = new TabbedPage();
var _RespondentProfileListPage = new RespondentProfileListPage(Services, row["ProjectID"].ToString());
homePage.Children.Add(_RespondentProfileListPage);
homePage.Children.Add(new QuotaControlPage(Services, row["ProjectID"].ToString()));
homePage.CurrentPageChanged += (object obj, EventArgs evt) =>
{
var i = homePage.Children.IndexOf(homePage.CurrentPage);
if (i == 0)
{
(homePage.CurrentPage as RespondentProfileListPage).Process();
}
if (i == 1)
{
(homePage.CurrentPage as QuotaControlPage).Process();
}
};
Application.Current.MainPage = new NavigationPage(homePage);
}
else
{
var page = new ProjectListPage(Services, ds.Tables[0]);
Application.Current.MainPage = new NavigationPage(page);
}
UserDialogs.Instance.HideLoading();
}
private static void Run(string[] args)
{
SplashScreenManager.ShowForm(typeof(SplashScreen));
var services = new ClientServices();
services.SetInformation("FacID", QA.QAFunction.ReadFromConfigXMlFile("FacID"));
services.Initialize();
using (var frm = new frmLogin())
{
frm.Initialize(services);
frm.Process();
SplashScreenManager.CloseForm();
if (frm.ShowDialog() != DialogResult.OK)
{
return;
}
//UserID = frm.UserID;
//UserName = frm.UserName;
}
services.LoadPermissions(services.GetInformation("FacID").ToString());
string ProjectID = "", ProjectNo = "";
var query = DataAccess.DataQuery.Create("KadenceDB", "ws_HR_UserProjectPermissions_Get", new
{
UserID = services.GetInformation("UserID"),
IsFWSupInterview = 0,
IsFWSupRecuit = 1,
IsQC = 0,
Type = 1
});
var ds = services.Execute(query);
if (ds == null)
{
UI.ShowError(services.LastError);
return;
}
if (ds.FirstTable().Rows.Count == 1)
{
ProjectID = ds.FirstRow().Item("ProjectID");
ProjectNo = ds.FirstRow().Item("ProjectNo");
}
else
{
if (ds.FirstTable().Rows.Count < 1)
{
UI.ShowError("Bạn không có dự án nào");
return;
}
else
{
using (var frm = new frmProjectList())
{
frm.Initialize(services);
frm.InitializeDataSource = ds.FirstTable();
frm.Process();
if (frm.ShowDialog() == DialogResult.OK)
{
ProjectID = frm.SelectedProjectID;
ProjectNo = frm.SelectedProjectNo;
}
}
}
}
//SplashScreenManager.ShowForm(typeof(SplashScreen));
// services.LoadSettings();
// Debug.WriteLine("Shell #4 : ClearReport");
// ReportUtility.ClearReports();
// Debug.WriteLine("Shell #5 : Opening Main form");
using (var frm = new frmQCRecall())
{
frm.Text = String.Format("FW Assignment Bạn đang làm việc với dự án : {0}", ProjectNo);
frm.ProjectID = ProjectID;
frm.ProjectNo = ProjectNo;
frm.Initialize(services);
frm.Process();
//SplashScreenManager.CloseForm();
Application.Run(frm);
}
}
async Task LoadData()
{
//danh sach phieu Ok
using (UserDialogs.Instance.Loading("Đang lấy dữ liệu quota"))
{
try
{
var CityHandle = Services.GetInformation("CityHandle");
var query = new DataAccess.RequestCollection();
int checkChecked = 0;
int TypeView = 0;
if (rRercuit.Checked == true)
{
TypeView = 1;
checkChecked += 1;
}
if (rCLTRercuit.Checked == true)
{
TypeView = 2;
checkChecked += 1;
}
if (rQC.Checked == true)
{
TypeView = 3;
checkChecked += 1;
}
if (rInterview.Checked == true)
{
TypeView = 4;
checkChecked += 1;
}
if (checkChecked != 1)
{
await DisplayAlert("Lỗi check option", Services.LastError, "Ok");
return;
}
//data quota value
//query += DataAccess.DataQuery.Create("Docs", "ws_DOC_QuotaControl_List", new
//{
// ProjectID
//});
////data quota field name
//query += DataAccess.DataQuery.Create("Docs", "ws_DOC_QuotaControlValues_List", new
//{
// ProjectID
//});
//query += DataAccess.DataQuery.Create("Docs", "ws_DOC_QuotaConditionExpression_ListWithCityHandle", new
//{
// ProjectID,
// CityHandle=Services.GetInformation("CityHandle")
//});
query = DataAccess.DataQuery.Create("Docs", "ws_DOC_Answers_ListCalculateQuotaWithCity", new
{
ProjectID,
TypeView,
CityHandle = CityHandle,
IsAll = IsAll
});
var ds = Services.Execute(query);
if (DependencyService.Get <IDataSetExtension>().IsNull(ds) == true)
{
await DisplayAlert("Lỗi load dữ liệu", Services.LastError, "Ok");
return;
}
gData.ItemsSource = ds.Tables[0];
//var tblProfile = ds.Tables[0];
//var tblQuotaValue = ds.Tables[2];
//var tblQuotaField = ds.Tables[1];
//var tblExpression = ds.Tables[3];
//foreach (DataRow row in tblQuotaField.Rows)
//{
// tblProfile.Columns.Add(row["FieldName"].ToString().ToUpper(), typeof(String));
//}
//foreach (DataRow row in tblProfile.Rows)
//{
// for (int i = 0; i < row.ItemArray.Length; i++)
// {
// string AnswerID = row["AnswerID"].ToString();
// string columnName = row.Table.Columns[i].ColumnName.ToString().ToUpper();
// if (IsFieldQuota(columnName, tblQuotaField) == true)
// {
// row[i] = FindValue(tblQuotaValue, AnswerID, "FieldName", columnName, "FieldValue");
// }
// }
//}
//foreach (DataRow row in tblExpression.Rows)
//{
// string queryCondition = row["ConditionExpression"].ToString();
// var items = DependencyService.Get<IDataTableExtension>().SelectQuery(tblProfile, queryCondition);
// int currentCount = items.Length;
// row["CurrentCount"] = currentCount;
// int minValue = (int)row["MinValue"];
// int maxValue = (int)row["MaxValue"];
// if (currentCount <= minValue && minValue != maxValue)
// row["NeedQty"] = String.Format("Còn {0}-{1}", minValue - currentCount, maxValue - currentCount);
// if (currentCount <= minValue && minValue == maxValue)
// row["NeedQty"] = String.Format("Còn {0}", minValue - currentCount);
// if (currentCount > minValue && minValue == maxValue)
// row["NeedQty"] = String.Format("Dư {0}", currentCount - minValue);
// if (currentCount > minValue && minValue != maxValue && currentCount <= maxValue)
// row["NeedQty"] = String.Format("Dư +{0}", maxValue - currentCount);
// if (currentCount > minValue && minValue != maxValue && currentCount > maxValue)
// row["NeedQty"] = String.Format("Dư +{0}", currentCount - maxValue);
//}
//gData.ItemsSource = tblExpression;
}
catch (Exception ex)
{
await DisplayAlert(ex.StackTrace.ToString(), ex.Message, "Ok");
return;
}
}
}
