public void CrearEstudiante(EstudianteVM estudianteVM)
{
estudiante.Nombres = estudianteVM.Estudiante.Nombres;
estudiante.ApellidoP = estudianteVM.Estudiante.ApellidoP;
estudiante.ApellidoM = estudianteVM.Estudiante.ApellidoM;
estudiante.FechaNacimiento = estudianteVM.Estudiante.FechaNacimiento;
estudiante.Genero = estudianteVM.Estudiante.Genero;
estudiante.RH = estudianteVM.Estudiante.RH;
estudiante.TipoSangre = estudianteVM.Estudiante.TipoSangre;
estudiante.Estado = estudianteVM.Estudiante.Estado;
historicoDocumento.PersonaId = estudiante.PersonaId;
historicoDocumento.FechaExpedicion = estudianteVM.HistoricoDocumentoPersona.FechaExpedicion;
historicoDocumento.TipoDocumento = estudianteVM.HistoricoDocumentoPersona.TipoDocumento;
historicoDocumento.Numero = estudianteVM.HistoricoDocumentoPersona.Numero;
historicoTelefono.Estado = estudianteVM.HistoricoDocumentoPersona.Estado;
historicoTelefono.PersonaId = estudiante.PersonaId;
historicoTelefono.TiposTelefono = estudianteVM.HistoricoTelefonoPersona.TiposTelefono;
historicoTelefono.Numero = estudianteVM.HistoricoTelefonoPersona.Numero;
historicoTelefono.Estado = estudianteVM.HistoricoTelefonoPersona.Estado;
personaDireccion.PersonaId = estudiante.PersonaId;
personaDireccion.Direccion = estudianteVM.HistoricoPersonaDireccion.Direccion;
personaDireccion.Estado = estudianteVM.HistoricoPersonaDireccion.Estado;
dBRepository.Add(estudiante);
dBRepository.Add(historicoDocumento);
dBRepository.Add(historicoTelefono);
dBRepository.Add(personaDireccion);
dBRepository.Commit();
}
private void UpdateData()
{
if (_responseList.Count() > 0)
{
string tablename = NumericHelper.RandomNumber().ToString() + _token;
string tmp1 = $"insert into {tablename} (key_code,update_status) values ('", tmp2 = $"insert into {tablename} (key_code,update_status) values ('";
string[] flg1 = _responseList.Where(x => x.status == "200").Select(x => x.key_code).ToArray();
if (flg1.Count() > 0)
{
tmp1 += string.Join("',1),('", flg1) + "',1);";
}
else
{
tmp1 = "";
}
string[] flg2 = _responseList.Where(x => x.status == "300").Select(x => x.key_code).ToArray();
if (flg2.Count() > 0)
{
tmp2 += string.Join("',2),('", flg2) + "',2);";
}
else
{
tmp2 = "";
}
Repo.Add(new QueryParam
{
DirectQuery = $"create table {tablename}(id int not null AUTO_INCREMENT PRIMARY KEY,key_code varchar(20) null,update_status int null); {tmp1}{tmp2} update {_Config.table} inner join {tablename} on key_code={_Config.field} set send_status=update_status;drop table {tablename}"
});
}
}
public IActionResult CSV()
{
DBRepository repo = new DBRepository();
string tablename = NumericHelper.RandomNumber().ToString() + "tmp";
repo.Add(new QueryParam {
DirectQuery = $"create table {tablename}(id int not null AUTO_INCREMENT PRIMARY KEY,fat decimal(18,2),snf decimal(18,2),milk_type varchar(5),rtpl decimal(18,2),milk_type_code int null); LOAD DATA LOCAL INFILE 'O:/Roshani/Projects/DataExchangeAPI/FileServer/Import/Upload/rate_chart_comma_sqparated.csv' INTO TABLE {tablename} FIELDS TERMINATED BY ';' IGNORE 1 ROWS (fat, snf,milk_type,rtpl); "
});
return(null);
}
public void CrearDocente(DocenteVM docenteVM)
{
docente.Nombres = docenteVM.Docente.Nombres;
docente.ApellidoP = docenteVM.Docente.ApellidoP;
docente.ApellidoM = docenteVM.Docente.ApellidoM;
docente.FechaNacimiento = docenteVM.Docente.FechaNacimiento;
docente.Genero = docenteVM.Docente.Genero;
docente.RH = docenteVM.Docente.RH;
docente.TipoSangre = docenteVM.Docente.TipoSangre;
docente.Estado = docenteVM.Docente.Estado;
docente.EspecialidadId = docenteVM.Docente.EspecialidadId;
historicoDocumento.PersonaId = docente.PersonaId;
historicoDocumento.FechaExpedicion = docenteVM.HistoricoDocumentoPersona.FechaExpedicion;
historicoDocumento.TipoDocumento = docenteVM.HistoricoDocumentoPersona.TipoDocumento;
historicoDocumento.Numero = docenteVM.HistoricoDocumentoPersona.Numero;
historicoTelefono.Estado = docenteVM.HistoricoDocumentoPersona.Estado;
historicoTelefono.PersonaId = docente.PersonaId;
historicoTelefono.TiposTelefono = docenteVM.HistoricoTelefonoPersona.TiposTelefono;
historicoTelefono.Numero = docenteVM.HistoricoTelefonoPersona.Numero;
historicoTelefono.Estado = docenteVM.HistoricoTelefonoPersona.Estado;
personaDireccion.PersonaId = docente.PersonaId;
personaDireccion.Direccion = docenteVM.HistoricoPersonaDireccion.Direccion;
personaDireccion.Estado = docenteVM.HistoricoPersonaDireccion.Estado;
dBRepository.Add(docente);
dBRepository.Add(historicoDocumento);
dBRepository.Add(historicoTelefono);
dBRepository.Add(personaDireccion);
dBRepository.Commit();
}
protected void btnWrite_Click(object sender, EventArgs e)
{
if (IsImageTextCorrect())
{
//TODO: 파일업로드
Note note = new Note();
note.Id = Convert.ToInt32(_Id); //없으면 0
note.Name = txtName.Text;
note.Email = txtEmail.Text;
note.Title = txtTitle.Text;
note.Homepage = txtHomepage.Text;
note.Content = txtContent.Text;
note.FileName = "";
note.FileSize = 0;
note.Password = txtPassword.Text;
note.PostIp = Request.UserHostAddress;
note.Encoding = rdoEncoding.SelectedValue; // Text, Html, Mixed
DBRepository repo = new DBRepository();
switch (FormType)
{
case BoardWriteFormType.Write:
repo.Add(note);
Response.Redirect("BoardList.aspx");
break;
case BoardWriteFormType.Modify:
break;
case BoardWriteFormType.Reply:
break;
default:
break;
}
}
else
{
lblError.Text = "보안코드가 틀립니다. 다시 입력하세요.";
}
}
public IActionResult Generate(string host)
{
AndroidInstallationDetails DetailModel = NewRepo.FindByColumn <AndroidInstallationDetails>(new List <ConditionParameter> {
Condition("hash_key", _request.token)
});
if (DetailModel != null)
{
string NewFileName = FileHelper.NewFileName(FileHelper.FileServerPath("Identity/Data/"), $"{_request.organizationType}_{_request.organizationCode}_", "db");
FileHelper.Copy(FileHelper.FileServerPath("Identity/Struct/everest_amcs.db"), NewFileName);
DetailModel.db_path = host + "/" + NewFileName.Replace(FileHelper.ProjectPath(), "");
DetailModel.model_operation = "update";
_data = new List <ModelParameter> {
new ModelParameter {
ValidateModel = null, SaveModel = DetailModel
}
};
AUDOperation(_data);
DBRepository Sqlite = new DBRepository(NewFileName);
_query = new QueryParam
{
DirectQuery = $"SELECT tbl_name FROM sqlite_master WHERE type='table'"
};
List <string> SqliteTable = Sqlite.FindAll <string>(_query).ToList();
List <TableList> AllTableList = NewRepo.FindAll <TableList>(new QueryParam {
Where = new List <ConditionParameter> {
Condition("is_offline", 0)
}
}).ToList();
OrgDetail();
foreach (TableList tables in AllTableList)
{
if (SqliteTable.Contains(tables.table_name.Trim()))
{
_query = new QueryParam
{
DirectQuery = $"PRAGMA table_info({tables.table_name.Trim()})"
};
List <TableInfo> TableInfoDetail = Sqlite.FindAll <TableInfo>(_query).ToList();
string fields = string.Join(",", TableInfoDetail.Select(x => x.name).ToArray());
_query = new QueryParam
{
Fields = fields,
Distinct = "distinct",
Table = tables.table_name.Trim(),
};
if (tables.key_field != null && tables.key_field.Trim() != "")
{
string comapre_field = tables.key_field == "to_dest"?"bmc_code": tables.key_field;
_query.Where = new List <ConditionParameter>
{
Condition(tables.key_field, Hierarchy[comapre_field], "in")
};
}
IEnumerable <object> ObjectResult = NewRepo.FindAll(_query);
int i = 0;
string DirectQuery = "";
foreach (var ObjTmp in ObjectResult)
{
IDictionary <string, object> Tmp = ObjTmp as IDictionary <string, object>;
if (i == 0)
{
DirectQuery = $"insert into {tables.table_name} ({fields}) values (";
}
if (i == 200)
{
DirectQuery = DirectQuery.TrimEnd('(');
DirectQuery = DirectQuery.TrimEnd(',');
Sqlite.Add(new QueryParam {
DirectQuery = DirectQuery
});
i = 0;
}
else
{
DirectQuery += string.Join(",", Tmp.Select(x => x.Value == null ? "NULL" : $"'{x.Value.ToString()}'")) + "),(";
i++;
}
}
if (DirectQuery != "")
{
DirectQuery = DirectQuery.TrimEnd('(');
DirectQuery = DirectQuery.TrimEnd(',');
Sqlite.Add(new QueryParam {
DirectQuery = DirectQuery
});
}
}
}
dynamic data = new ExpandoObject();
data.dbPath = DetailModel.db_path;
return(new CustomResult2(data));
}
return(new CustomResult2(null, "Authentication Failed."));
}
protected void btnWrite_Click(object sender, EventArgs e)
{
if (ViewState["Mode"].ToString() == "Edit")
{
Formtype = BoardWriteFormType.Modify;
}
else if (ViewState["Mode"].ToString() == "Reply")
{
Formtype = BoardWriteFormType.Reply;
}
else
{
Formtype = BoardWriteFormType.Write;
}
UPloadFile();
//TODO:파일업로드
if (IsImageTextCorrect())
{
Note note = new Note();
note.Id = Convert.ToInt32(_Id); //없으면 0
note.Name = txtName.Text; //필수
note.Email = txtEmail.Text;
note.Homepage = txtHomepage.Text; //필수, 추가할 것.
note.Content = txtContent.Text;
note.FileName = _FileName;
note.FileSize = _FileSize;
note.Password = txtPassword.Text;
note.PostIp = Request.UserHostAddress;
note.Encoding = rdoEncoding.SelectedValue;//Text, Html, Mixed
DBRepository repo = new DBRepository();
switch (Formtype)
{
case BoardWriteFormType.Write:
repo.Add(note);
Response.Redirect("BoardList.aspx");
break;
case BoardWriteFormType.Modify:
note.ModifyIp = Request.UserHostAddress;
//TODO : file 처리
note.FileName = ViewState["FileName"].ToString();
note.FileSize = Convert.ToInt32(ViewState["FileSize"]);
if (repo.UpdateNote(note) > 0)
{
Response.Redirect($"BoardView.aspx?Id={_Id}");
}
else
{
lblError.Text = "업데이트 실패, 암호를 확인하세요";
}
break;
case BoardWriteFormType.Reply:
note.ParentNum = Convert.ToInt32(_Id);
repo.ReplyNote(note);
Response.Redirect("BoardList.aspx");
break;
default:
repo.Add(note);
Response.Redirect("BoardList.aspx");
break;
}
}
else
{
lblError.Text = "보안코드가 틀립니다. 다시 입력하세요";
}
}
public void Add(Child child)
{
childValidator.Validate(child);
childRepository.Add(child);
}
