} // end of CheckForNormality
// Create diagrams, if data is normal
public ActionResult NormTestResults()
{
string[,] data = UploadModels.Data; // data from uploaded file, table of N students and M questions
int M = data.GetLength(1); // Number of questions
int N = data.GetLength(0); // Number of students
int[] answers = new int[UploadModels.Answers.Length]; // Amount of correct answ for each student
UploadModels.Answers.CopyTo(answers, 0);
TableModels[] tableArray = new TableModels[N];
for (int i = 0; i < N; i++)
{
tableArray[i] = new TableModels();
tableArray[i].StudID = i + 1;
tableArray[i].RawScore = answers[i];
tableArray[i].Z = UploadModels.Y[i];
tableArray[i].T = 50 + 10 * double.Parse(string.Format("{0:f1}", UploadModels.Y[i]));
for (int j = 0; j < M; j++)
{
if (answers[i] == j + 1) // See what percentage assosiates with result of a student
{
tableArray[i].Perc = UploadModels.Perc[j];
}
}
}
// Sort Data
if (SettingsModels.Sort) Array.Sort(answers, tableArray);
ViewBag.Data = tableArray;
TableModels.tableArray = tableArray;
return View();
} // end of NormTestResults()
/// <summary>
/// Initializes a new instance of the <see cref="ContactContainer"/> class.
/// </summary>
/// <param name="dbcontainer">The dbcontainer.</param>
/// <param name="intelligence">The intelligence.</param>
public ContactContainer(TableModels.System_Social_ContactContainer dbcontainer, CoreIntelligence intelligence)
{
// TODO: Complete member initialization
this.dbcontainer = dbcontainer;
attributes = (Table<TableModels.System_Social_ContactAttribute>)intelligence.RepositoryIntelligence.LoadTable(typeof(TableModels.System_Social_ContactAttribute));
_intelligence = intelligence;
this.Attribute = new ContactAttributes(this);
ID = dbcontainer.ContainerID;
}
public ActionResult Edit(TableModels model)
{
try
{
if (model.Cover < 1)
{
ModelState.AddModelError("Cover", _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Please enter a value greater than or equal to 1"));
}
if (string.IsNullOrEmpty(model.StoreID))
{
ModelState.AddModelError("StoreID", _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Please choose store"));
}
if (string.IsNullOrEmpty(model.Name))
{
ModelState.AddModelError("Name", _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Table Name is required"));
}
if (!ModelState.IsValid)
{
if (!string.IsNullOrEmpty(model.StoreID))
{
model.ListZone = GetSelectListZone(model.StoreID);
}
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(PartialView("_Edit", model));
}
//====================
string msg = "";
var result = _factory.InsertOrUpdateTables(model, ref msg);
if (result)
{
return(RedirectToAction("Index"));
}
else
{
//return PartialView("_Edit", model);
ModelState.AddModelError("Name", msg);
Response.StatusCode = (int)HttpStatusCode.BadRequest;
if (!string.IsNullOrEmpty(model.StoreID))
{
model.ListZone = GetSelectListZone(model.StoreID);
}
return(PartialView("_Edit", model));
}
}
catch (Exception ex)
{
_logger.Error("Table_Edit: " + ex);
return(new HttpStatusCodeResult(400, ex.Message));
}
}
public bool InsertOrUpdateTables(TableModels model, ref string msg)
{
try
{
TableApiModels paraBody = new TableApiModels();
paraBody.AppKey = Commons.AppKey;
paraBody.AppSecret = Commons.AppSecret;
paraBody.CreatedUser = Commons.CreateUser;
paraBody.RegisterToken = new RegisterTokenModels();
paraBody.ID = model.ID;
paraBody.StoreID = model.StoreID;
paraBody.Name = model.Name;
paraBody.ZoneID = model.ZoneID;
paraBody.Cover = model.Cover;
paraBody.ViewMode = model.ViewMode;
paraBody.XPoint = -1;
paraBody.YPoint = -1;
paraBody.ZPoint = -1;
paraBody.IsActive = model.IsActive;
paraBody.IsShowInReservation = model.IsShowInReservation;
paraBody.IsTemp = model.IsTemp;
//====================
var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.CreateOrEditTable, null, paraBody);
if (result != null)
{
if (result.Success)
{
return(true);
}
else
{
_logger.Error(result.Message);
msg = result.Message;
msg = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(msg);
return(false);
}
}
else
{
_logger.Error(result);
return(false);
}
}
catch (Exception e)
{
_logger.Error("Table_InsertOrUpdate: " + e);
return(false);
}
}
public ActionResult Import(TableModels model)
{
try
{
if (model.ListStores == null)
{
ModelState.AddModelError("ListStores", _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Please choose store"));
return(View(model));
}
if (model.ExcelUpload == null || model.ExcelUpload.ContentLength <= 0)
{
ModelState.AddModelError("ExcelUpload", _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Excel filename cannot be null"));
return(View(model));
}
ImportModel importModel = new ImportModel();
string msg = "";
StatusResponse response = _factory.Import(model.ExcelUpload, model.ListStores, ref importModel, ref msg);
if (!response.Status)
{
ModelState.AddModelError("", response.MsgError);
return(View(model));
}
// Delete File Excel and File Zip Image
CommonHelper.DeleteFileFromServer(CommonHelper.GetFilePath(model.ExcelUpload));
//if (!ModelState.IsValid)
// return View(model);
if (msg.Equals(""))
{
return(View("ImportDetail", importModel));
}
else
{
_logger.Error("Table_Import: " + msg);
ModelState.AddModelError("ImageZipUpload", msg);
return(View(model));
}
}
catch (Exception e)
{
_logger.Error("Table_Import : " + e);
//return new HttpStatusCodeResult(400, e.Message);
ModelState.AddModelError("ExcelUpload", _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Import file have error"));
return(View(model));
}
}
public ActionResult Export(TableModels model)
{
try
{
if (model.ListStores == null)
{
ModelState.AddModelError("ListStores", _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Please choose store."));
return(View(model));
}
XLWorkbook wb = new XLWorkbook();
var ws = wb.Worksheets.Add("Sheet1");
StatusResponse response = _factory.Export(ref ws, model.ListStores);
if (!response.Status)
{
ModelState.AddModelError("", response.MsgError);
return(View(model));
}
ViewBag.wb = wb;
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
Response.Charset = System.Text.UTF8Encoding.UTF8.WebName;
Response.ContentEncoding = System.Text.UTF8Encoding.UTF8;
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", String.Format(@"attachment;filename={0}.xlsx", CommonHelper.GetExportFileName("Table List").Replace(" ", "_")));
using (var memoryStream = new System.IO.MemoryStream())
{
wb.SaveAs(memoryStream);
memoryStream.WriteTo(HttpContext.Response.OutputStream);
memoryStream.Close();
}
HttpContext.Response.End();
return(RedirectToAction("Export"));
}
catch (Exception e)
{
_logger.Error("Table_Export: " + e);
//return new HttpStatusCodeResult(400, e.Message);
ModelState.AddModelError("ListStores", _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Import file have error"));
return(View(model));
}
}
public ActionResult Create(TableModels model)
{
try
{
if (model.Cover < 1)
{
ModelState.AddModelError("Cover", _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Please enter a value greater than or equal to 1"));
}
if (string.IsNullOrEmpty(model.Name))
{
ModelState.AddModelError("Name", _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Name field is required"));
}
if (!ModelState.IsValid)
{
if (!string.IsNullOrEmpty(model.StoreID))
{
model.ListZone = GetSelectListZone(model.StoreID);
}
return(View(model));
}
string msg = "";
bool result = _factory.InsertOrUpdateTables(model, ref msg);
if (result)
{
return(RedirectToAction("Index"));
}
else
{
//return RedirectToAction("Create");
ModelState.AddModelError("Name", msg);
if (!string.IsNullOrEmpty(model.StoreID))
{
model.ListZone = GetSelectListZone(model.StoreID);
}
return(View(model));
}
}
catch (Exception ex)
{
_logger.Error("Table_Create: " + ex);
return(new HttpStatusCodeResult(400, ex.Message));
}
}
public ActionResult LoadZone(string StoreID)
{
List <ZoneModels> lstData = _Zonefactory.GetListZone(StoreID, null, CurrentUser.ListOrganizationId);
TableModels model = new TableModels();
if (lstData != null && lstData.Count > 0)
{
foreach (ZoneModels data in lstData)
{
model.ListZone.Add(new SelectListItem
{
Value = data.ID,
Text = data.Name + " [" + data.StoreName + "]"
});
}
}
return(PartialView("_DropDownListZone", model));
}
public TableModels GetDetail(string id)
{
try
{
TableModels model = new TableModels();
var listTable = _factory.GetListTable(null, id);
if (listTable != null && listTable.Any())
{
model = listTable.FirstOrDefault();
model.ListZone = GetSelectListZone(model.StoreID);
}
return(model);
}
catch (Exception ex)
{
_logger.Error("Tables_Detail: " + ex);
return(null);
}
}
private void Button_Finish_Click(object sender, RoutedEventArgs e)
{
if (CheckIfHaveAlreadyInformation())
{
ConnectionString = new ConnectionString()
{
Address = TextBox_IP.Text,
Database = string.Empty,
Username = TextBox_Username.Text,
Password = TextBox_Password.Text,
};
DAOFactory dao = new DAOFactory()
{
DataConnection = ConnectionString
};
Object connection = dao.GetConnection(CurrentConnectorType);
if (connection != null)
{
List <string> tables = dao.GetDAOTable().GetAllDataBase(CurrentConnectorType, connection);
if (tables.Count > 0)
{
foreach (string item in tables)
{
TableModels.Add(new TableModel()
{
Name = item
});
}
}
MessageBox.Show(langue.Authentification_BDD_OK);
}
else
{
MessageBox.Show(langue.Authentification_BDD_NOK);
Application.Current.Shutdown();
}
this.Close();
}
}
} // end of NormTestResults()
// Create diagrams, if data isn't normal
public ActionResult NeNormTestResults()
{
string[,] data = UploadModels.Data; // data from uploaded file, table of N students and M questions
int M = data.GetLength(1); // Number of questions
int N = data.GetLength(0); // Number of students
int[] answers = new int[UploadModels.Answers.Length]; // Amount of correct answ for each student
UploadModels.Answers.CopyTo(answers, 0);
TableModels[] tableArray = new TableModels[N];
for (int i = 0; i < N; i++)
{
tableArray[i] = new TableModels();
tableArray[i].StudID = i + 1;
tableArray[i].RawScore = answers[i];
}
// Sort Data
if(SettingsModels.Sort) Array.Sort(answers,tableArray);
ViewBag.Data = tableArray;
TableModels.tableArray = tableArray;
return View();
} // end of NeNormTestResults()
public ActionResult Delete(TableModels model)
{
try
{
string msg = "";
var result = _factory.DeleteTables(model.ID, ref msg);
if (!result)
{
//ModelState.AddModelError("Name", "Have a error when you delete an Category");
ModelState.AddModelError("Name", msg);
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(PartialView("_Delete", model));
}
return(new HttpStatusCodeResult(HttpStatusCode.OK));
}
catch (Exception ex)
{
_logger.Error("Tables_Delete: " + ex);
ModelState.AddModelError("Name", _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Have an error when you delete a Table"));
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(PartialView("_Delete", model));
}
}
/// <summary>
/// Adds the attribute.
/// </summary>
/// <param name="attribute">The attribute.</param>
internal void addAttribute(TableModels.System_Social_ContactAttribute attribute)
{
attribute.ContainerID = this.ID;
attribute.AttributeID = 0;
attributes.InsertOnSubmit(attribute);
_intelligence.RepositoryIntelligence.SubmitChanges();
}
// IMPORT
public StatusResponse Import(HttpPostedFileBase excelFile, List <string> lstStore, ref ImportModel importModel, ref string msg)
{
StatusResponse Response = new StatusResponse();
DataTable dt = new DataTable();
FileInfo[] lstFileImg = new FileInfo[] { };
Response = ProcessDataImport(ref dt, excelFile, "SBSettingTable.xlsx", out lstFileImg);
if (!Response.Status)
{
msg = Response.MsgError;
Response.MsgError = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(msg);
return(Response);
}
List <TableModels> listData = new List <TableModels>();
ImportItem itemErr = null;
bool flagInsert = true;
string msgError = "";
foreach (var item in lstStore)
{
foreach (DataRow row in dt.Rows)
{
try
{
flagInsert = true;
msgError = "";
string rowText = "";
for (int i = 0; i < dt.Columns.Count; i++)
{
rowText += row[i].ToString().Trim();
}
if (string.IsNullOrEmpty(rowText))
{
continue;
}
double doubleVal = 0;
TableModels model = new TableModels();
model.Index = row[0].ToString();
// 1 - Name
model.Name = row[1].ToString().Trim().Replace(" ", " ");
// 2 - Maximum Capacity
double.TryParse(row[2].ToString(), out doubleVal);
model.Cover = (int)doubleVal;
// 3 - Zone
model.ZoneName = row[3].ToString().Trim().Replace(" ", " ");
// 4 - IsActive
model.IsActive = GetBoolValue(dt.Columns[4].ColumnName.Replace("#", "."), row[0].ToString(), row[4].ToString());
// 5 - Online Reservation
string sIsAllowOpenValue = row[5].ToString().Equals("") ? _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("No") : row[5].ToString();
model.IsShowInReservation = GetBoolValue(dt.Columns[5].ColumnName.Replace("#", "."), row[0].ToString(), sIsAllowOpenValue);
// 6 - Store
model.StoreID = item;
// 7 - Style
string sStyle = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(row[7].ToString());
model.ViewMode = sStyle.Equals(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(Commons.ETableStyle.Circle.ToString())) ? (byte)Commons.ETableStyle.Circle :
sStyle.Equals(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(Commons.ETableStyle.Rectangle.ToString())) ? (byte)Commons.ETableStyle.Rectangle :
sStyle.Equals(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(Commons.ETableStyle.Square.ToString())) ? (byte)Commons.ETableStyle.Square : (byte)Commons.ETableStyle.Other;
// 8 - XPoint
double.TryParse(row[8].ToString(), out doubleVal);
model.XPoint = (byte)doubleVal;
// 9 - YPoint
double.TryParse(row[9].ToString(), out doubleVal);
model.YPoint = (byte)doubleVal;
//=========
string msgItem = "";
if (model.Name.Equals(""))
{
flagInsert = false;
msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Name is required");
msgError += "<br/>" + msgItem;
}
if (model.Cover < 1)
{
flagInsert = false;
msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Please enter a value [Maximum Capacity] greater than or equal to 1");
msgError += "<br/>" + msgItem;
}
if (model.ZoneName.Equals(""))
{
flagInsert = false;
msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Zone is required");
msgError += "<br/>" + msgItem;
}
if (row[7].ToString().Equals(""))
{
flagInsert = false;
msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Style is required");
msgError += "<br/>" + msgItem;
}
if (model.XPoint < 0)
{
flagInsert = false;
msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Please enter a value [Position X] greater than or equal to 0");
msgError += "<br/>" + msgItem;
}
if (model.YPoint < 0)
{
flagInsert = false;
msgItem = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Please enter a value [Position Y] greater than or equal to 0");
msgError += "<br/>" + msgItem;
}
if (flagInsert)
{
listData.Add(model);
}
else
{
itemErr = new ImportItem();
itemErr.Name = model.Name;
itemErr.ListFailStoreName.Add("");
itemErr.ListErrorMsg.Add(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Row") + ":" + model.Index + _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(msgError));
importModel.ListImport.Add(itemErr);
}
}
catch (Exception e)
{
importModel.ListImport.Add(new ImportItem {
Name = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Table List"), ListFailStoreName = lstStore, ListErrorMsg = new List <string> {
_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(e.Message)
}
});
}
}
}
Response.Status = true;
//=====================
//try
//{
TableApiModels paraBody = new TableApiModels();
paraBody.AppKey = Commons.AppKey;
paraBody.AppSecret = Commons.AppSecret;
paraBody.CreatedUser = Commons.CreateUser;
paraBody.RegisterToken = new RegisterTokenModels();
paraBody.ListTable = listData;
//====================
var result = (ResponseApiModels)ApiResponse.Post <ResponseApiModels>(Commons.ImportTable, null, paraBody);
if (result != null)
{
dynamic data = result.Data;
var lstC = data["ListProperty"];
var lstContent = JsonConvert.SerializeObject(lstC);
var listError = JsonConvert.DeserializeObject <List <ImportResult> >(lstContent);
foreach (ImportResult itemError in listError)
{
ImportItem item = new ImportItem();
item.Name = itemError.Property;
item.ListFailStoreName.Add(itemError.StoreName);
item.ListErrorMsg.Add(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Row") + ": " + itemError.Index + "<br/>" + _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey(itemError.Error));
importModel.ListImport.Add(item);
}
if (importModel.ListImport.Count == 0)
{
ImportItem item = new ImportItem();
item.Name = _AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Table List");
item.ListSuccessStoreName.Add(_AttributeForLanguage.CurrentUser.GetLanguageTextFromKey("Import Table List Successful"));
importModel.ListImport.Add(item);
}
}
return(Response);
}
public ActionResult Create()
{
TableModels model = new TableModels();
return(View(model));
}
public new PartialViewResult View(string id)
{
TableModels model = GetDetail(id);
return(PartialView("_View", model));
}
public ActionResult Export()
{
TableModels model = new TableModels();
return(View(model));
}
public PartialViewResult Delete(string id)
{
TableModels model = GetDetail(id);
return(PartialView("_Delete", model));
}
/// <summary>
/// 导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnBuild_Click(object sender, EventArgs e)
{
_savePath = this.tbSavePath.Text;
if (_savePath.IsNullOrWhiteSpace())
{
this.ShowWarningDialog("没有设置导出目录");
return;
}
var templatePath = this.cbbTemplate.SelectedValue?.ToString();
if (templatePath.IsNullOrWhiteSpace())
{
this.ShowWarningDialog("没有选择模板");
return;
}
var configIndex = this.cbbConfig.SelectedIndex;
if (configIndex < 0)
{
this.ShowWarningDialog("没有选择配置");
return;
}
var configModel = jsonUtil.Items[configIndex];
var nameSpace = this.tbNameSapce.Text;
if (nameSpace.IsNullOrWhiteSpace())
{
this.ShowWarningDialog("没有添加命名空间");
return;
}
IDbDal dal = null;
if (configModel.ConnType == ((int)DbBuildEntity.Util.Enums.DbType.SqlServer).ToString())
{
dal = new SqlServerDal();
}
else if (configModel.ConnType == ((int)DbBuildEntity.Util.Enums.DbType.Oracle).ToString())
{
dal = new OracleDal();
}
else if (configModel.ConnType == ((int)DbBuildEntity.Util.Enums.DbType.MySQL).ToString())
{
}
else if (configModel.ConnType == ((int)DbBuildEntity.Util.Enums.DbType.SQlite).ToString())
{
dal = new SqliteDal();
}
var tables = dal.GetTables(configModel.ConnString);
int index = 0;
if (Path.GetFileNameWithoutExtension(templatePath) != "实体枚举模板")
{
ShowStatus("提示", "导出实体中......", tables.Count, 0);
foreach (var table in tables)
{
//StatusDescription = "导出实体中(" + index + "%)......";
StatusStepIt();
var columnsList = dal.GetColumnList(table.TableName, configModel.ConnString);
foreach (var column in columnsList)
{
if (column.TypeName.Contains("varchar") || column.TypeName.Contains("VARCHAR"))
{
column.TypeName = "string";
}
string value = string.Empty;
var dResult = dbTypeDic.TryGetValue(column.TypeName.ToUpper(), out value);
if (dResult)
{
column.TypeName = value;
}
else
{
column.TypeName = "object";
}
}
//var buildContent = RazorBuildUtil.GetBuildContent(templatePath, columnsList, table);
var buildContent =
RazorBuildUtil.GetBuildContentNew(templatePath, table.TableName, columnsList, table, nameSpace);
FileUtil.Save(buildContent, Path.Combine(_savePath, $"{table.TableName}.cs"));
index++;
}
}
else
{
ShowStatus("提示", "加载数据中......", tables.Count, 0);
List <TableModels> list = new List <TableModels>();
TableModels model = null;
foreach (var table in tables)
{
//StatusDescription = "加载数据中(" + index + "%)......";
StatusStepIt();
var columnsList = dal.GetColumnList(table.TableName, configModel.ConnString);
model = new TableModels();
model.Columns = columnsList;
model.TableName = table.TableName;
model.Description = table.Description;
list.Add(model);
index++;
}
var buildContent =
RazorBuildUtil.GetBuildContent_Enum(templatePath, "TableNames", list, nameSpace, "TableNames");
FileUtil.Save(buildContent, Path.Combine(_savePath, "TableNames.cs"));
}
ConfigUtil.SetAppSettingValue("DefaultPath", _savePath, Global.nameSpaceConfigFullPath);
UIMessageTip.ShowOk("导出成功", 2000, true);
}
public PartialViewResult Edit(string id)
{
TableModels model = GetDetail(id);
return(PartialView("_Edit", model));
}
