public string Update(GroupAddDto model) { string query = $"EXECUTE SP_UpdateGroup '{model.Id}' , '{model.Name}'"; var user = _db.Database.SqlQuery <string>(query).FirstOrDefault(); return(user); }
public ReturnMessage AddGroup(GroupAddDto model) { string query = $"EXECUTE SP_AddGroup '{model.Name}' , '{model.CreatedBy}'"; var user = _db.Database.SqlQuery <ReturnMessage>(query).FirstOrDefault(); return(user); }
public IHttpActionResult AddGroup([FromBody] GroupAddDto model) { if (!ModelState.IsValid) { return(BadRequest("Invalid Model")); } var result = new GroupService().AddGroup(model); return(Ok(result)); }
public IHttpActionResult UpdateGroup([FromBody] GroupAddDto model) { if (!ModelState.IsValid) { return(BadRequest("Fill Empty Records")); } var result = new GroupService().Update(model); return(Ok(result)); }
public async Task <BaseResultCRUDDto <OutPut_GroupDto> > CreateGroup(GroupAddDto addedmodel) { if (await groupRepository.GetByGroupName(addedmodel.GroupName) != null) { return new BaseResultCRUDDto <OutPut_GroupDto>() { ErrorMessage = "عنوان گروه از قبل به ثبت رسیده است " } } ; return(await groupRepository.AddGroup(addedmodel)); }
public async Task <IActionResult> Add(GroupAddDto newGroup) { if (!ModelState.IsValid) { return(BadRequest()); } var group = await _groupService.Add(_mapper.Map <Group>(newGroup)); if (group == null) { return(BadRequest()); } return(Ok(_mapper.Map <GroupResultDto>(group))); }
public async Task <BaseResultCRUDDto <OutPut_GroupDto> > AddGroup(GroupAddDto addedmodel) { var AddedItem = new Group() { GroupName = addedmodel.GroupName }; dbContext.Groups.Add(AddedItem); await dbContext.SaveChangesAsync(); return(new BaseResultCRUDDto <OutPut_GroupDto>() { IsSuccess = true, CRUDObject = new OutPut_GroupDto() { Id = AddedItem.Id, GroupName = AddedItem.GroupName } }); }
public async Task <IActionResult> CreateGroup(GroupAddDto model) { var resultAdd = await groupService.CreateGroup(model); return(Ok(resultAdd)); }
public IHttpActionResult AddBulkGroup() { var httpRequest = HttpContext.Current.Request; var form = httpRequest.Form; var ds = new DataSet(); ReturnMessage result = new ReturnMessage(); #region Guid string path = Path.GetRandomFileName(); path = path.Replace(".", ""); string Guid = path.Substring(0, 8); #endregion string CreatedBy = ""; try { if (httpRequest.Files.Count > 0) { foreach (string file in httpRequest.Files) { var postedFileBase = httpRequest.Files[file]; if (postedFileBase != null) { foreach (string key in form.AllKeys) { CreatedBy = form[key]; } string fileExtension = Path.GetExtension(postedFileBase.FileName); if (fileExtension == ".xls" || fileExtension == ".xlsx") { string fileLocation = HttpContext.Current.Server.MapPath("~/Uploads/") + postedFileBase.FileName + Guid; if (File.Exists(fileLocation)) { File.Delete(fileLocation); } postedFileBase.SaveAs(fileLocation); var excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\""; if (fileExtension == ".xls") { excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\""; } else if (fileExtension == ".xlsx") { excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\""; } OleDbConnection excelConnection = new OleDbConnection(excelConnectionString); excelConnection.Open(); var dt = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); if (dt == null) { return(null); } var excelSheets = new string[dt.Rows.Count]; int t = 0; foreach (DataRow row in dt.Rows) { excelSheets[t] = row["TABLE_NAME"].ToString(); t++; } var excelConnection1 = new OleDbConnection(excelConnectionString); string query = $"Select * from [{excelSheets[0]}]"; using (var dataAdapter = new OleDbDataAdapter(query, excelConnection1)) { dataAdapter.Fill(ds); } int count = Convert.ToInt32(ds.Tables[0].Rows.Count); for (int i = 0; i < count; i++) { var name = ds.Tables[0].Rows[i][0].ToString(); GroupAddDto model = new GroupAddDto { CreatedBy = CreatedBy, Name = name }; result = new GroupService().AddGroup(model); } return(Ok(result)); } else { return(BadRequest("You must upload excel sheets only")); } } } } return(BadRequest("No File Uploaded")); } catch (Exception e) { return(BadRequest(e.InnerException.ToString())); } }