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); }