public HttpResponseMessage View()
{
var deserializer = new JavaScriptSerializer();
bal = new T_Planing_WeatherCollectionBAL();
ResposeType response = new ResposeType();
HttpResponseMessage mapMessage = null;
T_Planing_WeatherCollectionDTO dto = null;
try
{
var context = HttpContext.Current;
dto = ConvertX.GetReqeustForm <T_Planing_WeatherCollectionDTO>();
logger.debug("View dto:" + dto.ToString());
dto = bal.FindByPK(dto);
response.statusCode = true;
response.data = dto;
}
catch (Exception ex)
{
logger.error("View error:" + ex.ToString());
response.statusText = ex.ToString();
}
mapMessage = Request.CreateResponse(HttpStatusCode.OK, response);
return(mapMessage);
}
public HttpResponseMessage Delete()
{
bal = new T_Planing_WeatherCollectionBAL();
ResposeType response = new ResposeType();
HttpResponseMessage mapMessage = null;
T_Planing_WeatherCollectionDTO dto = null;
try
{
var context = HttpContext.Current;
//context.Response.ContentType = "multipart/form-data";
dto = ConvertX.GetReqeustForm <T_Planing_WeatherCollectionDTO>();
logger.debug("Delete dto:" + dto.ToString());
response.statusCode = bal.Delete(dto);
}
catch (Exception ex)
{
logger.error("Delete error:" + ex.ToString());
response.statusText = ex.ToString();
}
mapMessage = Request.CreateResponse(HttpStatusCode.OK, response);
return(mapMessage);
}
public T_Planing_WeatherCollectionDTO FindByPK(object data)
{
List <SqlParameter> parameterList = new List <SqlParameter>();
var obj = new T_Planing_WeatherCollectionDTO();
dataTable = null;
string procName = "sp_T_Planing_Action_WeatherCollection_FindByPK";
try
{
dataTable = new DataTable();
adapter = new SqlDataAdapter();
SqlConnection conn = OpenConnection();
if (data != null)
{
parameterList.AddRange(GetParameters(procName, data).ToArray());
}
command = new SqlCommand(procName, conn);
command.CommandType = CommandType.StoredProcedure;
if (data != null)
{
command.Parameters.AddRange(parameterList.ToArray());
}
using (SqlDataReader reader = command.ExecuteReader())
{
obj = ConvertX.GetListFromDataReader <T_Planing_WeatherCollectionDTO>(reader).ToList().FirstOrDefault();
}
}
catch (Exception ex) { }
finally
{
CloseConnection();
}
return(obj);
}
public override bool Add(object data)
{
List <SqlParameter> parameterList = new List <SqlParameter>();
string procName = "sp_T_Planing_Action_WeatherCollection_Insert";
string PID = "";
SqlConnection conn = OpenConnection();
isCan = true;
try
{
obj = (T_Planing_WeatherCollectionDTO)data;
obj.CollectDate = ConvertX.MMddYY(obj.CollectDate);
command = new SqlCommand(procName, conn);
command.CommandType = CommandType.StoredProcedure;
if (obj != null)
{
parameterList.AddRange(GetParameters(procName, obj).ToArray());
command.Parameters.AddRange(parameterList.ToArray());
}
command.ExecuteNonQuery();
}
catch (Exception ex)
{
isCan = false;
throw new Exception(ex.Message);
}
finally
{
CloseConnection();
}
return(isCan);
}
