private void btnCancel_Click(object sender, EventArgs e)
{
var query = new DataAccess.RequestCollection();
query += DataAccess.DataQuery.Create("Docs", "ws_DOC_Answers_UpdateRespondentStatus", new
{
AnswerID,
RespondentStatus = "Cancel"
});
var ds = Services.Execute(query);
if (ds == null)
{
UI.ShowError(Services.LastError);
return;
}
DialogResult = DialogResult.OK;
}
private async Task SaveData()
{
try
{
var query = new DataAccess.RequestCollection();
if (CheckValidateInput() == false)
{
return;
}
string selectedfacelistID = FindFaceListID();
if (dtFaceList._FindIndex("faceListId", selectedfacelistID) < 0)
{
WriteLog("Vui lòng liên hệ tạo face list trước khi đồng bộ hình");
UI.ShowError("Vui lòng liên hệ tạo face list trước khi đồng bộ hình");
return;
}
AddPersistedFaceResult ressultaddFacetoList;
query += DataAccess.DataQuery.Create("Docs", "ws_DOC_Answers_SupQuanlReUpdate", new
{
AnswerID,
GreenID = txtRespondentNo.Text,
ProjectID,
RespondentFullName = txtName.Text.Trim().ToUpper(),
RespondentAddressLandmark = txtAddress.Text.Trim().ToUpper(),
RespondentStreet = txtStreet.Text.Trim().ToUpper(),
RespondentWard = (txtWard.EditValue == null || txtWard.EditValue.ToString().IsEmpty()) ? "" : txtWard.Text.ToString().Trim(),
RespondentDistrict = (txtDistrict.EditValue == null || txtDistrict.EditValue.ToString().IsEmpty()) ? "" : txtDistrict.Text.ToString(),
RespondentCity = rCity.EditValue.ToString(),
RespondentTelephone = txtTelephone.Text.Trim(),
RespondentGender = rGender.EditValue == null ? "" : rGender.EditValue.ToString(),
RespondentStatus = rStatus.EditValue.ToString(),
RespondentYoB = dateDOB.Text.Trim(),
RecruitCode = txtRecruit.EditValue.ToString(),
EmailAddress = txtEmail.Text.Trim(),
UserID = Services.GetInformation("UserID")
});
foreach (Control ctr in flowQuota.Controls)
{
if (ctr.GetType() == typeof(QuotaGroup))
{
if ((ctr as QuotaGroup).QuotaFieldValue == null || (ctr as QuotaGroup).QuotaFieldValue.IsEmpty())
{
UI.ShowError("Vui lòng chọn đầy đủ thông tin quota của đáp viên");
return;
}
query += DataAccess.DataQuery.Create("Docs", "ws_DOC_QuotaControlValues_Save", new
{
AnswerID,
ProjectID,
FieldName = (ctr as QuotaGroup).QuotaFieldName,
FieldValue = (ctr as QuotaGroup).QuotaFieldValue,
UserID = Services.GetInformation("UserID")
});
}
}
Image img = FacePhoto.Image;
string name = txtName.Text.Trim();
string temp_Path = _pathImage;
string ID = AnswerID;
//ClearOldData();
if (temp_Path.IsNotEmpty())
{
try
{
WriteLog(String.Format("Đã gửi yêu cầu lưu thông tin của đáp viên {0}", name));
FileStream streamfile = File.OpenRead(temp_Path);
MessageBox.Show(String.Format("Đã gửi yêu cầu lưu thông tin của đáp viên {0}", name));
WriteLog(String.Format("Resquest AddtoFaceList "));
ressultaddFacetoList = await faceServiceClient.AddFaceToFaceListAsync(selectedfacelistID, streamfile, ProjectNo + "_" + name);
WriteLog(String.Format("Complted Resquest AddtoFaceList "));
var Data = img.ImageToStringBase64();
query = DataAccess.DataQuery.Create("KadenceDB", "ws_FaceList_Save", new
{
ID = ID,
FaceID = ressultaddFacetoList.PersistedFaceId,
FaceListId = selectedfacelistID,
Image = Data,
FullName = name,
ProjectNo = ProjectNo,
UserID = Services.GetInformation("UserID")
}) + query;
}
catch (FaceAPIException ex)
{
WriteLog(String.Format("Lỗi {0}", ex.ErrorMessage));
UI.ShowError(String.Format("Lỗi {0}", ex.ErrorMessage));
return;
}
}
var ds = Services.Execute(query);
if (ds == null)
{
WriteLog(Services.LastError);
MessageBox.Show(Services.LastError);
return;
}
WriteLog(String.Format("Đã lưu thành công thông tin của đáp viên {0} {1}", name, ID));
MessageBox.Show(String.Format("Đã lưu thành công thông tin của đáp viên {0}", name));
}
catch (Exception ex)
{
WriteLog(string.Format(ex.Message));
UI.ShowError(ex.Message);
return;
}
}
private async Task NhanDien()
{
gFaceDetection.Text = "Face Detection ( FD ) đang nhận diện";
flowLayoutPanel2.Controls.Clear();
Confidence = Properties.Settings.Default.Confidence;
if (FacePhoto.Image == null)
{
OpenFileDialogToPickImage();
}
if (FacePhoto.Image == null)
{
gFaceDetection.Text = "Face Detection ( FD )";
return;
}
try
{
var ms = new MemoryStream();
FacePhoto.Image.Save(ms, ImageFormat.Png);
var m = Serializer.Compress(ms);
// If you're going to read from the stream, you may need to reset the position to the start
ms.Position = 0;
var watch = System.Diagnostics.Stopwatch.StartNew();
// the code that you want to measure comes here
WriteLog(string.Format("Resquest DetectAsync"));
var faces = await faceServiceClient.DetectAsync(m);
watch.Stop();
WriteLog(string.Format("Response: Success. Detected {0} face(s) in {1} seconds", faces.Length, watch.Elapsed.TotalSeconds));
var personSimilarResultFace = new PersonSimilarResults();
flowLayoutPanel2.Controls.Clear();
foreach (var f in faces)
{
var faceId = f.FaceId;
WriteLog(String.Format("Request: Finding similar faces in Face Match Mode for face {0}", faceId));
foreach (DataRow row in dtFaceList.Rows)
{
try
{
var personSimilarResults = await faceServiceClient.FindSimilarAsync(faceId, row.Item("faceListId"), FindSimilarMatchMode.matchFace, 4);
foreach (var personSimilarResult in personSimilarResults)
{
if (personSimilarResult.Confidence >= Confidence)
{
personSimilarResultFace.Add(personSimilarResult.PersistedFaceId, personSimilarResult.Confidence);
}
}
WriteLog(String.Format("Response: Success FindSimilarAsync {0}- {1}", faceId, row.Item("faceListId")));
}
catch (FaceAPIException ex)
{
WriteLog(String.Format("Error FindSimilarAsync {0}- {1}:{2}", faceId, row.Item("faceListId"), ex.ErrorMessage));
}
}
}
if (personSimilarResultFace.Data.Count == 0)
{
WriteLog(String.Format("Không tìm thấy khuôn mặt giống khuôn mặt đáp viên {0}", txtName.Text));
MessageBox.Show(String.Format("Không tìm thấy khuôn mặt giống khuôn mặt đáp viên {0}", txtName.Text));
gFaceDetection.Text = "Face Detection ( FD )";
return;
}
else
{
//MessageBox.Show(
}
var items = from pair in personSimilarResultFace.Data
orderby pair.Value ascending
select pair;
var query = new DataAccess.RequestCollection();
string ids = "";
foreach (KeyValuePair <string, double> item in items)
{
ids += item.Key + ",";
}
query = DataAccess.DataQuery.Create("KadenceDB", "ws_FaceList_List", new
{
FaceIDs = ids
});
var ds = this.Services.Execute(query);
if (ds == null)
{
MessageBox.Show(Services.LastError);
return;
}
foreach (DataRow row in ds.FirstTable().Rows)
{
var faceRespondent = new FaceFaceSimilarUnit();
faceRespondent.Conf = personSimilarResultFace.Data[row.Item("FaceID")];
faceRespondent.ProjectNameFullName = row.Item("ProjectNo") + "_" + row.Item("FullName");
byte[] byteImage = Convert.FromBase64String(row.Item("Image"));
Image imageProfile;
using (MemoryStream memorysteam = new MemoryStream(byteImage))
{
imageProfile = Image.FromStream(memorysteam);
}
faceRespondent.ImageRespondent = imageProfile;
faceRespondent.Height = flowLayoutPanel2.Height - 10;
faceRespondent.Width = faceRespondent.Height;
flowLayoutPanel2.Controls.Add(faceRespondent);
}
UI.ShowError(String.Format("Đã tìm thấy {1} khuôn mặt giống khuôn mặt đáp viên {0}", txtName.Text, ds.FirstTable().Rows.Count));
}
catch (FaceAPIException ex)
{
MessageBox.Show(ex.Message);
gFaceDetection.Text = "Face Detection ( FD )";
return;
}
gFaceDetection.Text = "Face Detection ( FD )";
}
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;
}
}
}
public async void btnSave_Clicked(object sender, EventArgs args)
{
using (UserDialogs.Instance.Loading("Đang lưu thông tin"))
{
if (ValidateForm().Result == false)
{
return;
}
string RecruitCode = FindRecruitCode();
var query = new DataAccess.RequestCollection();
query += DataAccess.DataQuery.Create("Docs", "ws_DOC_Answers_SupUpdate", new
{
AnswerID,
GreenID = txtGreenID.Text.Trim().ToUpper(),
ProjectID,
RespondentFullName = txtFullName.Text.Trim().ToUpper(),
RespondentAddressLandmark = txtAddress.Text.Trim().ToUpper(),
RespondentStreet = txtStreet.Text.Trim().ToUpper(),
RespondentWard = txtWard.SelectedItem == null ? "" : txtWard.SelectedItem.ToString(),
RespondentDistrict = txtDistrict.SelectedItem == null ? "" : txtDistrict.SelectedItem.ToString(),
RespondentCity = tblHanhChanh.Rows[0]["City"].ToString(),
RespondentTelephone = txtTelephone.Text.Trim(),
RespondentGender = txtGender.SelectedItem == null ? "" : txtGender.SelectedItem.ToString(),
RespondentYoB = txtYoB.SelectedItem.ToString(),
RespondentStatus = txtStatus.SelectedItem == null ? "" : txtStatus.SelectedItem.ToString(),
RecruitCode = FindRecruitCode(),
RecruitName = "",
EmailAddress = txtEmail.Text,
UserID = Services.GetInformation("UserID")
});
foreach (var ctr in this.layoutQuota.Children)
{
if (ctr.GetType() == typeof(QuotaControl))
{
if ((ctr as QuotaControl).QuotaFieldValue == null || (ctr as QuotaControl).QuotaFieldValue.ToString().Trim().Length == 0)
{
await DisplayAlert("Lỗi nhập dữ liệu quota", "Nhập đầy đủ thông tin quota", "Ok");
return;
}
query += DataAccess.DataQuery.Create("Docs", "ws_DOC_QuotaControlValues_Save", new
{
AnswerID,
ProjectID,
FieldName = (ctr as QuotaControl).QuotaFieldName,
FieldValue = (ctr as QuotaControl).QuotaFieldValue,
UserID = Services.GetInformation("UserID")
});
}
}
query += DataAccess.DataQuery.Create("Docs", "ws_DOC_Answers_GetForWaitingMobile", 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;
}
tblResult = ds.Tables[ds.Tables.Count - 1];
if (Saved != null)
{
Saved(this, null);
}
await Application.Current.MainPage.Navigation.PopAsync();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//save
try
{
var query = new DataAccess.RequestCollection();
if (CheckValidateInput() == false)
{
return;
}
query += DataAccess.DataQuery.Create("Docs", "ws_DOC_Answers_SupReUpdate", new
{
AnswerID,
GreenID = txtGreenID.Text.Trim(),
ProjectID,
RespondentFullName = txtName.Text.Trim().ToUpper(),
RespondentAddressLandmark = txtAddress.Text.Trim().ToUpper(),
RespondentStreet = txtStreet.Text.Trim().ToUpper(),
RespondentWard = (txtWard.EditValue == null || txtWard.EditValue.ToString().IsEmpty()) ? "" : txtWard.Text.ToString().Trim(),
RespondentDistrict = (txtDistrict.EditValue == null || txtDistrict.EditValue.ToString().IsEmpty()) ? "" : txtDistrict.Text.ToString(),
RespondentCity = rCity.EditValue.ToString(),
RespondentTelephone = txtTelephone.Text.Trim(),
RespondentGender = rGender.EditValue == null ? "" : rGender.EditValue.ToString(),
RespondentStatus = rStatus.EditValue.ToString(),
RespondentYoB = dateDOB.Text.Trim(),
RecruitCode = txtRecruit.EditValue.ToString(),
EmailAddress = txtEmail.Text.Trim(),
UserID = Services.GetInformation("UserID")
});
foreach (Control ctr in flowQuota.Controls)
{
if (ctr.GetType() == typeof(QuotaGroup))
{
query += DataAccess.DataQuery.Create("Docs", "ws_DOC_QuotaControlValues_Save", new
{
AnswerID,
ProjectID,
FieldName = (ctr as QuotaGroup).QuotaFieldName,
FieldValue = (ctr as QuotaGroup).QuotaFieldValue,
UserID = Services.GetInformation("UserID")
});
}
}
var ds = Services.Execute(query);
if (ds == null)
{
WriteLog(Services.LastError);
MessageBox.Show(Services.LastError);
return;
}
WriteLog(String.Format("Đã lưu thành công thông tin của đáp viên {0} {1}", txtRespondentNo.Text, AnswerID));
UI.InformationSaved();
ClearOldData();
}
catch (Exception ex)
{
WriteLog(string.Format(ex.Message));
UI.ShowError(ex.Message);
return;
}
}
