public object Put([FromBody] TaskMasterModel model) { var output = new ResponseDetail(); try { if (ModelState.IsValid) { var taskMasters = Mapper.Map <TaskMaster>(model); _taskMastersService.UpdateTaskMaster(taskMasters); output.Message = "Task Master updated successfully!"; output.Success = true; return(output); } output.Message = "Something went wrong!"; output.Success = false; return(output); } catch (Exception ex) { output.Message = ex.Message; output.Success = false; return(output); } }
public int GetWorkCnt() { //string reVal = string.Empty; int reVal = 0; try { tasklist = new List <TaskMasterModel>(); using (SqlConnection connection = new SqlConnection(_builder.ConnectionString)) { //Console.WriteLine("\nQuery data example:"); //Console.WriteLine("=========================================\n"); connection.Open(); StringBuilder sb = new StringBuilder(); string _kind = "KOREA_ECONOMIC_IDX"; //string _date = System.DateTime.Today.ToShortDateString().Replace("-", ""); string _date = System.DateTime.Now.Year.ToString() + string.Format("{0:D2}", System.DateTime.Now.Month) + string.Format("{0:D2}", System.DateTime.Now.Day); sb.Append("SELECT * "); sb.Append("FROM TASKMASTER "); sb.Append("WHERE 1=1 "); sb.Append("AND KIND = '" + _kind + "' "); sb.Append("AND WORK_DATE = '" + _date + "' "); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { if (reader.HasRows == true) { while (reader.Read()) { TaskMasterModel item = new TaskMasterModel(); item.KIND = reader.GetString(reader.GetOrdinal("KIND")); item.NAME = reader.GetString(reader.GetOrdinal("NAME")); item.WORK_DATE = reader.GetString(reader.GetOrdinal("WORK_DATE")); tasklist.Add(item); } //dataGrid1.ItemsSource = datalist; //reVal = "조회되었습니다."; reVal = tasklist.Count; } } } } } catch (SqlException ex) { //Console.WriteLine(ex.ToString()); //reVal = ex.ToString(); } //Console.ReadLine(); return(reVal); }