public HttpResponseMessage Add()
{
bal = new M_PipelineLengthBAL();
ResposeType response = new ResposeType();
HttpResponseMessage mapMessage = null;
M_PipelineLengthDTO dto = null;
response.statusCode = false;
try
{
var context = HttpContext.Current;
dto = ConvertX.GetReqeustForm<M_PipelineLengthDTO>();
string UserID = context.Request.Form["UserID"];
if (ObjUtil.isEmpty(UserID))
{
throw new Exception("UserID is require");
}
dto.CreateBy = UserID;
dto.UpdateBy = UserID;
logger.debug("Add dto:" + dto.ToString());
response.statusCode = bal.Add(dto);
}
catch (Exception ex)
{
logger.error("Add error:" + ex.ToString());
response.statusText = ex.ToString();
}
mapMessage = Request.CreateResponse(HttpStatusCode.OK, response);
return mapMessage;
}
public HttpResponseMessage Delete()
{
bal = new M_PipelineLengthBAL();
ResposeType response = new ResposeType();
HttpResponseMessage mapMessage = null;
M_PipelineLengthDTO dto = null;
response.statusCode = false;
try
{
var context = HttpContext.Current;
dto = ConvertX.GetReqeustForm<M_PipelineLengthDTO>();
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 HttpResponseMessage Search()
{
bal = new M_PipelineLengthBAL();
ResposeType response = new ResposeType();
HttpResponseMessage mapMessage = null;
List<M_PipelineLengthDTO> dataList = new List<M_PipelineLengthDTO>();
M_PipelineLengthDTO dto = null;
response.statusCode = false;
try
{
var context = HttpContext.Current;
dto = ConvertX.GetReqeustForm<M_PipelineLengthDTO>();
logger.debug("Search dto:" + dto.ToString());
dataList = bal.FindByObjList(dto);
response.statusCode = true;
response.data = dataList;
}
catch (Exception ex)
{
logger.error("Search error:" + ex.ToString());
response.statusText = ex.ToString();
}
mapMessage = Request.CreateResponse(HttpStatusCode.OK, response);
return mapMessage;
}
public List <M_PipelineLengthDTO> FindByObjList(object data)
{
List <SqlParameter> parameterList = new List <SqlParameter>();
objList = new List <M_PipelineLengthDTO>();
dataTable = null;
string procName = "sp_M_PipelineLength_FindByColumn";
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())
{
while (reader.Read())
{
obj = new M_PipelineLengthDTO();
obj.PipelineLengthID = reader["PipelineLengthID"].ToString();
obj.PipelineLengthCode = reader["PipelineLengthCode"].ToString();
obj.Name = reader["Name"].ToString();
obj.Status = reader["Status"].ToString();
obj.CreateDate = reader["CreateDate"].ToString();
obj.CreateBy = reader["CreateBy"].ToString();
obj.UpdateDate = reader["UpdateDate"].ToString();
obj.UpdateBy = reader["UpdateBy"].ToString();
objList.Add(obj);
}
}
}
catch (Exception ex) { }
finally
{
CloseConnection();
}
return(objList);
}
