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