public async Task <IActionResult> Put(int id, [FromBody] GenderDTO generoDTO)
{
var currentGenero = await _genderService.GetGender(id);
if (currentGenero == null)
{
return(NotFound());
}
if (id != generoDTO.Id)
{
return(BadRequest());
}
var updateGenero = _mapper.Map <Gender>(generoDTO);
updateGenero.Id = id;
var result = await _genderService.UpdateGender(updateGenero);
if (!result)
{
return(BadRequest());
}
return(NoContent());
}
public int SaveGender(GenderDTO gender)
{
if (gender.GenderId == 0)
{
var c = new Gender()
{
Name = gender.Name,
CreatedOn = DateTime.Now
};
this.UnitOfWork.Get <Gender>().AddNew(c);
this.UnitOfWork.SaveChanges();
return(c.GenderId);
}
else
{
var c = this.UnitOfWork.Get <Gender>().AsQueryable()
.FirstOrDefault(d => d.GenderId == gender.GenderId);
if (c != null)
{
c.Name = gender.Name;
c.CreatedOn = gender.CreatedOn;
c.TimeStamp = gender.TimeStamp;
this.UnitOfWork.Get <Gender>().Update(c);
this.UnitOfWork.SaveChanges();
}
return(c.GenderId);
}
}
public async Task <IActionResult> Post([FromBody] GenderDTO generoDTO)
{
var newGenero = _mapper.Map <Gender>(generoDTO);
await _genderService.InsertGender(newGenero);
return(Created(nameof(Get), new { id = newGenero.Id, generoDTO }));
}
//hàm lấy thông tin giới tính
public List <GenderDTO> GetInfoGender()
{
List <GenderDTO> list = new List <GenderDTO>();
try
{
//cau lenh query lấy thông tin gender
string sql = "select * from GenderType";
SqlDataReader reader = ReadData(sql);
while (reader.Read())
{
//tao 1 bien genderdto truyen dữ liệu vào
GenderDTO g = new GenderDTO();
g.GenderID = reader.GetInt32(0);
g.Des1 = reader.GetString(1);
//them bien vua tao vao list gender
list.Add(g);
}
reader.Close();
}catch (Exception ex)
{
ex.ToString();
}
finally
{
closeConnection();
}
return(list);
}
public IActionResult Create([Bind("Name,Id")] GenderDTO genderDTO)
{
if (ModelState.IsValid)
{
_genderApp.Insert(genderDTO);
return(RedirectToAction(nameof(Index)));
}
return(View(genderDTO));
}
public GenderDTO updateGender(GenderDTO gender)
{
var selectedGender = uow.GetRepository <Gender>().Get(z => z.Id == gender.Id);
selectedGender = MapperFactory.CurrentMapper.Map(gender, selectedGender);
uow.GetRepository <Gender>().Update(selectedGender);
uow.SaveChanges();
return(MapperFactory.CurrentMapper.Map <GenderDTO>(selectedGender));
}
private void Button_Click(object sender, RoutedEventArgs e)
{
var c = new GenderDTO()
{
Name = genderTextbox.Text,
};
_dataService.SaveGender(c);
}
public HttpResponseMessage Get(int Id)
{
GenderDTO selectedTitle = service.getGender(Id);
if (selectedTitle == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Id + sysLanguage.CompanyTitlesControllerStrings.id_title));
}
return(Request.CreateResponse(HttpStatusCode.OK, selectedTitle));
}
public void UpdateGender(GenderDTO updatedgender)
{
using (var context = new MSSContext())
{
var gender = context.genders.Find(updatedgender.genderid);
gender.gendername = updatedgender.gendername;
var existingGender = context.Entry(gender);
existingGender.State = EntityState.Modified;
context.SaveChanges();
}
}
public static List <GenderDTO> FindAll()
{
GenderDTO genderDTO = new GenderDTO();
genderDTO.Id = "GD0";
genderDTO.Name = "Khác";
var result = genderDAL.FindAll();
result.Add(genderDTO);
return(result);
}
public void DeactivateGender(GenderDTO deactivatedGender)
{
using (var context = new MSSContext())
{
var gender = context.agegroups.Find(deactivatedGender.genderid);
gender.activeyn = false;
var existingGender = context.Entry(gender);
existingGender.State = EntityState.Modified;
context.SaveChanges();
}
}
public void AddGender(GenderDTO tempGender)
{
using (var context = new MSSContext())
{
gender newGender = new gender();
newGender.genderid = tempGender.genderid;
newGender.gendername = tempGender.gendername;
newGender.activeyn = true;
context.genders.Add(newGender);
context.SaveChanges();
}
}
public bool InsertMonster(GenderDTO gender)
{
var gen = msc.GetGenders().FirstOrDefault(g => g.Id == gender.AppId);
var mon = new MonsterDAO()
{
Name = gender.Name, Gender = gen, Type = new MonsterTypeDAO()
{
Id = 1
}
};
return(msc.InsertMonster(mon));
}
public HttpResponseMessage Put(GenderDTO accessTypeDTO)
{
GenderDTO dto = service.updateGender(accessTypeDTO);
if (dto != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, dto));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.SeeOther, sysLanguage.CompanyTitlesControllerStrings.update_title));
}
}
public GenderDTO newGender(GenderDTO gender)
{
if (!uow.GetRepository <Gender>().GetAll().Any(z => z.Id == gender.Id))
{
var adedGender = MapperFactory.CurrentMapper.Map <Gender>(gender);
adedGender = uow.GetRepository <Gender>().Add(adedGender);
uow.SaveChanges();
return(MapperFactory.CurrentMapper.Map <GenderDTO>(adedGender));
}
else
{
return(null);
}
}
public IActionResult Edit(int id, [Bind("Name,Id")] GenderDTO genderDTO)
{
if (id != genderDTO.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
_genderApp.Update(genderDTO);
return(RedirectToAction(nameof(Index)));
}
return(View(genderDTO));
}
public HttpResponseMessage Post(GenderDTO accessTypeDTO)
{
GenderDTO dto = service.newGender(accessTypeDTO);
if (dto != null)
{
HttpResponseMessage message = Request.CreateResponse(HttpStatusCode.Created, dto);
message.Headers.Location = new Uri(Request.RequestUri + "/" + dto.Id);
return(message);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.SeeOther, sysLanguage.CompanyTitlesControllerStrings.add_title));
}
}
public List <GenderDTO> GetActiveGenders()
{
using (var context = new MSSContext())
{
var genderList = from gender in context.genders where gender.activeyn == true select gender;
List <GenderDTO> genders = new List <GenderDTO>();
foreach (var gender in genderList)
{
GenderDTO temp = new GenderDTO();
temp.genderid = gender.genderid;
temp.gendername = gender.gendername;
genders.Add(temp);
}
return(genders);
}
}
public List <GenderDTO> GetAllGenders()
{
using (var context = new MSSContext())
{
var genderList = context.genders.ToList();
List <GenderDTO> genders = new List <GenderDTO>();
foreach (var gender in genderList)
{
GenderDTO temp = new GenderDTO();
temp.genderid = gender.genderid;
temp.gendername = gender.gendername;
genders.Add(temp);
}
return(genders);
}
}
public UserDTO(
int id,
string firstName,
string middleName,
string lastName,
GenderDTO gender,
DateTime?dateOfBirthday,
string email,
string login,
string password)
{
this.Id = id;
this.FirstName = firstName;
this.MiddleName = middleName;
this.LastName = lastName;
this.Gender = gender;
this.DateOfBirthday = dateOfBirthday;
this.Email = email;
this.Login = login;
this.Password = password;
}
public GenderDTO GetByPrimaryKey(int primaryKey)
{
GenderDTO record = GetQuery().FirstOrDefault(Gender => Gender.Gender_PK == primaryKey);
return(record);
}
private void btnCounselling_Click(object sender, EventArgs e)
{
dgvResult.DataSource = null;
var assumptions = new List <string>();
PurposeDTO purpose = (PurposeDTO)cbbPurpose.SelectedItem;
BrandDTO brand = (BrandDTO)cbbBrand.SelectedItem;
PriceDTO price = (PriceDTO)cbbPrice.SelectedItem;
ColorDTO color = (ColorDTO)cbbColor.SelectedItem;
ObjectUsingDTO objectUsing = (ObjectUsingDTO)cbbObjectUsing.SelectedItem;
GenderDTO gender = (GenderDTO)cbbGender.SelectedItem;
if (color.Id.Equals("CL0"))
{
assumptions.Add(gender.Id.Trim());
}
else
{
assumptions.Add(color.Id.Trim());
}
if (brand.Id.Equals("BR0"))
{
assumptions.Add(purpose.Id.Trim());
}
else
{
assumptions.Add(brand.Id.Trim());
}
if (price.Id.Equals("PR0"))
{
assumptions.Add(objectUsing.Id.Trim());
}
else
{
assumptions.Add(price.Id.Trim());
}
if (assumptions.Count < 3)
{
MessageBox.Show("Bạn cần trả lời thêm câu hỏi để chúng tôi tư vấn!", "Cảnh báo",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
/*if (assumptions.Contains("OS1") && assumptions.Contains("BR4"))
* {
* MessageBox.Show("Bạn cần nhập lại hãng điện thoại hoặc hệ điều hành vì Apple không phải là hệ điều hành Android!", "Lỗi",
* MessageBoxButtons.OK, MessageBoxIcon.Error);
* return;
* }*/
if (assumptions.Contains("OS2") && !assumptions.Contains("BR4"))
{
MessageBox.Show("Bạn cần nhập lại hãng điện thoại hặc hệ điều hành!", "Lỗi",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var mobiles = ForwardChainingUtil.Result(assumptions);
if (mobiles.Count == 0)
{
MessageBox.Show("Chúng tôi xin lỗi vì không có loại điện thoại theo mô tả của bạn!", "Thông tin",
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
this.dgvResult.Visible = true;
pnResult.Visible = true;
this.dgvResult.DataSource = mobiles;
this.dgvResult.Columns["Id"].Visible = false;
}
public HttpResponseMessage Export(GlobalSolusindoDb Db, string fileName, UserSearchFilter filter)
{
_fileName = fileName;
_workbook = new XSSFWorkbook(); //Creating New Excel object
var workbook = new XLWorkbook();
using (var userSearch = new UserSearch(Db))
{
var data = userSearch.GetDataByFilter(filter);
var dataExport = data.Records.Select(c => new UserExportDTO
{
Nomor = c.User_PK,
JoinDate = c.JoinDate,
UserName = c.Username,
KategoriJabatanTitle = c.KategoriJabatanTitle,
Name = c.Name,
TglLahir = c.TglLahir,
NoKTP = c.NoKTP,
ReligionName = c.Religion == null || c.Religion == 0 ? "" : religionQuery.GetByPrimaryKey((int)c.Religion).Name, //?
CategoryContract = c.CategoryContract == null || c.CategoryContract == 0 ? "" : categoryContractQuery.GetByPrimaryKey((int)c.CategoryContract).Name,
Project = c.Project == null || c.Project == 0 ? "" : projectQuery.GetByPrimaryKey((int)c.Project).Project_PK + "-" + projectQuery.GetByPrimaryKey((int)c.Project).OperatorTitle + "-" + projectQuery.GetByPrimaryKey((int)c.Project).VendorTitle + "-" + projectQuery.GetByPrimaryKey((int)c.Project).DeliveryAreaTitle, //?
Gender = c.Gender == null || c.Gender == 0 ? "" : genderQuery.GetByPrimaryKey((int)c.Gender).Name,
MartialStatus = c.MaritalStatus == null || c.MaritalStatus == 0 ? "" : maritalStatusQuery.GetByPrimaryKey((int)c.MaritalStatus).Name,
NPWP = c.NPWP, //?
BPJS = c.BPJS, //?
ContactNumber = c.NoHP,
G1EmailID = c.Email,
PersonalEmail = c.PersonalEmail,
Address = c.Address,
NamaBank = c.BankName, //?
NoRekening = c.AccountNumber, //?
Salary = c.Salary, //?
Remark = c.Description, //?
Status = null //?
}).ToList();
projectQuery.Dispose();
DataTable user = new DataTable("UserUpload");
UserExportDTO obj = new UserExportDTO();
foreach (var item in obj.GetType().GetProperties())
{
user.Columns.Add(item.Name);
}
DataRow dr;
foreach (var item in dataExport)
{
dr = user.NewRow();
dr["Nomor"] = item.Nomor;
dr["UserName"] = item.UserName;
dr["KategoriJabatanTitle"] = item.KategoriJabatanTitle;
dr["Name"] = item.Name;
dr["TglLahir"] = item.TglLahir;
dr["NoKTP"] = item.NoKTP;
dr["ReligionName"] = item.ReligionName;
dr["CategoryContract"] = item.CategoryContract;
dr["Project"] = item.Project;
dr["Gender"] = item.Gender;
dr["MartialStatus"] = item.MartialStatus;
dr["NPWP"] = item.NPWP;
dr["BPJS"] = item.BPJS;
dr["JoinDate"] = item.JoinDate;
dr["ContactNumber"] = item.ContactNumber;
dr["G1EmailID"] = item.G1EmailID;
dr["PersonalEmail"] = item.PersonalEmail;
dr["Address"] = item.Address;
dr["NamaBank"] = item.NamaBank;
dr["NoRekening"] = item.NoRekening;
dr["Salary"] = item.Salary;
dr["Remark"] = item.Remark;
dr["Status"] = item.Status;
user.Rows.Add(dr);
}
workbook.AddWorksheet(user);
var worksheet = workbook.Worksheet(1);
worksheet.Columns().Width = 15;
using (var jabatanQry = new KategoriJabatanQuery())
{
//SETUP TABLE
DataTable validationTable = new DataTable();
validationTable.TableName = "Kategori Jabatan";
//SETUP COLUMN
LOVDTO objkatja = new LOVDTO();
foreach (var item in objkatja.GetType().GetProperties())
{
validationTable.Columns.Add(item.Name);
}
//DATA ROW
var dataval = jabatanQry.GetQuery().Select(c => new LOVDTO {
Id = c.KategoriJabatan_PK, Name = c.Title
}).ToList();
DataRow dr2;
int startcell = 2, endcell = 2;
foreach (var item in dataval)
{
dr2 = validationTable.NewRow();
dr2["Id"] = item.Id;
dr2["Name"] = item.Name;
validationTable.Rows.Add(dr2);
endcell++;
}
var worksheet2 = workbook.AddWorksheet(validationTable);
worksheet.Column(3).SetDataValidation().List(worksheet2.Range("B" + startcell.ToString() + ":B" + endcell.ToString()), true);
//GENDER
using (var genderQuery = new GenderQuery())
{
//SETUP TABLE
DataTable validationTablegender = new DataTable();
validationTablegender.TableName = "Gender";
//SETUP COLUMN
GenderDTO objgender = new GenderDTO();
foreach (var item in objkatja.GetType().GetProperties())
{
validationTablegender.Columns.Add(item.Name);
}
var datagender = genderQuery.GetQuery().Select(c => new GenderDTO {
Gender_PK = c.Gender_PK, Name = c.Name
}).ToList();
DataRow drgender;
startcell = 2; endcell = 2;
foreach (var item in datagender)
{
drgender = validationTablegender.NewRow();
drgender["Id"] = item.Gender_PK;
drgender["Name"] = item.Name;
validationTablegender.Rows.Add(drgender);
endcell++;
}
var worksheetgender = workbook.AddWorksheet(validationTablegender);
worksheet.Column(10).SetDataValidation().List(worksheetgender.Range("B" + startcell.ToString() + ":B" + endcell.ToString()), true);
//RELIGION
using (var ReligionQuery = new ReligionQuery())
{
//SETUP TABLE
DataTable validationTableReligion = new DataTable();
validationTableReligion.TableName = "Religion";
//SETUP COLUMN
ReligionDTO objReligion = new ReligionDTO();
foreach (var item in objkatja.GetType().GetProperties())
{
validationTableReligion.Columns.Add(item.Name);
}
var dataReligion = ReligionQuery.GetQuery().Select(c => new ReligionDTO {
Religion_PK = c.Religion_PK, Name = c.Name
}).ToList();
DataRow drReligion;
startcell = 2; endcell = 2;
foreach (var item in dataReligion)
{
drReligion = validationTableReligion.NewRow();
drReligion["Id"] = item.Religion_PK;
drReligion["Name"] = item.Name;
validationTableReligion.Rows.Add(drReligion);
endcell++;
}
var worksheetReligion = workbook.AddWorksheet(validationTableReligion);
worksheet.Column(7).SetDataValidation().List(worksheetReligion.Range("B" + startcell.ToString() + ":B" + endcell.ToString()), true);
//MaritalStatus
using (var MaritalStatusQuery = new MaritalStatusQuery())
{
//SETUP TABLE
DataTable validationTableMaritalStatus = new DataTable();
validationTableMaritalStatus.TableName = "MaritalStatus";
//SETUP COLUMN
MaritalStatusDTO objMaritalStatus = new MaritalStatusDTO();
foreach (var item in objkatja.GetType().GetProperties())
{
validationTableMaritalStatus.Columns.Add(item.Name);
}
var dataMaritalStatus = MaritalStatusQuery.GetQuery().Select(c => new MaritalStatusDTO {
MaritalStatus_PK = c.MaritalStatus_PK, Name = c.Name
}).ToList();
DataRow drMaritalStatus;
startcell = 2; endcell = 2;
foreach (var item in dataMaritalStatus)
{
drMaritalStatus = validationTableMaritalStatus.NewRow();
drMaritalStatus["Id"] = item.MaritalStatus_PK;
drMaritalStatus["Name"] = item.Name;
validationTableMaritalStatus.Rows.Add(drMaritalStatus);
endcell++;
}
var worksheetMaritalStatus = workbook.AddWorksheet(validationTableMaritalStatus);
worksheet.Column(11).SetDataValidation().List(worksheetMaritalStatus.Range("B" + startcell.ToString() + ":B" + endcell.ToString()), true);
//CategoryContract
using (var CategoryContractQuery = new CategoryContractQuery())
{
//SETUP TABLE
DataTable validationTableCategoryContract = new DataTable();
validationTableCategoryContract.TableName = "CategoryContract";
//SETUP COLUMN
CategoryContractDTO objCategoryContract = new CategoryContractDTO();
foreach (var item in objkatja.GetType().GetProperties())
{
validationTableCategoryContract.Columns.Add(item.Name);
}
var dataCategoryContract = CategoryContractQuery.GetQuery().Select(c => new CategoryContractDTO {
CategoryContract_PK = c.CategoryContract_PK, Name = c.Name
}).ToList();
DataRow drCategoryContract;
startcell = 2; endcell = 2;
foreach (var item in dataCategoryContract)
{
drCategoryContract = validationTableCategoryContract.NewRow();
drCategoryContract["Id"] = item.CategoryContract_PK;
drCategoryContract["Name"] = item.Name;
validationTableCategoryContract.Rows.Add(drCategoryContract);
endcell++;
}
var worksheetCategoryContract = workbook.AddWorksheet(validationTableCategoryContract);
worksheet.Column(8).SetDataValidation().List(worksheetCategoryContract.Range("B" + startcell.ToString() + ":B" + endcell.ToString()), true);
//Project
using (var ProjectQuery2 = new ProjectQuery())
{
//SETUP TABLE
DataTable validationTableProject = new DataTable();
validationTableProject.TableName = "Project";
//SETUP COLUMN
ProjectDTO objProject = new ProjectDTO();
foreach (var item in objkatja.GetType().GetProperties())
{
validationTableProject.Columns.Add(item.Name);
}
var dataProject = ProjectQuery2.GetQuery();
DataRow drProject;
startcell = 2; endcell = 2;
foreach (var item in dataProject)
{
drProject = validationTableProject.NewRow();
drProject["Id"] = item.Project_PK;
drProject["Name"] = item.Project_PK + "-" + item.OperatorTitle + "-" + item.VendorTitle + "-" + item.DeliveryAreaTitle;
validationTableProject.Rows.Add(drProject);
endcell++;
}
var worksheetProject = workbook.AddWorksheet(validationTableProject);
worksheet.Column(9).SetDataValidation().List(worksheetProject.Range("B" + startcell.ToString() + ":B" + endcell.ToString()), true);
}
}
}
}
}
}
worksheet.Protect("kairosg1")
.SetFormatCells() // Cell Formatting
.SetInsertColumns() // Inserting Columns
.SetDeleteColumns() // Deleting Columns
.SetDeleteRows(); // Deleting Rows;
worksheet.Columns(1, 2).Style.Fill.BackgroundColor = XLColor.DarkGray;
worksheet.Columns(1, 2).Style.Font.FontColor = XLColor.Black;
worksheet.Columns(3, 20).Style.Protection.SetLocked(false);
}
MemoryStream memoryStream = GetStream(workbook);
var response = new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new ByteArrayContent(memoryStream.ToArray())
};
response.Content.Headers.ContentType = new MediaTypeHeaderValue
("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
response.Content.Headers.ContentDisposition =
new ContentDispositionHeaderValue("attachment")
{
FileName = $"{_fileName}_{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx"
};
return(response);
}
public GenderDTO GetGenderDTOByProductId(long p_genderId)
{
GenderDTO dataProduct = genderCollection.AsQueryable <GenderDTO>().Where(x => x.id == p_genderId).FirstOrDefault();
return(dataProduct);
}
