public void DeleteTag(PrintTagProcView model)
{
using (TransactionScope scope = new TransactionScope())
{
string strConn = ConfigurationManager.ConnectionStrings["OracleDbContext"].ConnectionString;
var dataConn = new OracleConnectionStringBuilder(strConn);
OracleConnection conn = new OracleConnection(dataConn.ToString());
conn.Open();
OracleCommand oraCommand = conn.CreateCommand();
OracleParameter[] param = new OracleParameter[]
{
new OracleParameter("p_entity", model.entity),
new OracleParameter("p_req_date", model.req_date),
new OracleParameter("p_mc_code", model.mc_code),
new OracleParameter("p_process_tag_no", model.process_tag_no)
};
oraCommand.BindByName = true;
oraCommand.Parameters.AddRange(param);
oraCommand.CommandText = "delete MPS_DET_IN_PROCESS_TAG where entity = :p_entity and req_date = to_date(:p_req_date,'dd/mm/yyyy') and mc_code =:p_mc_code and process_tag_no = :p_process_tag_no";
//oraCommand.ExecuteReader(CommandBehavior.SingleRow);
oraCommand.ExecuteNonQuery();
conn.Close();
scope.Complete();
}
}
public HttpResponseMessage postDeleteTag(PrintTagProcView model)
{
try
{
tagSvc.DeleteTag(model);
return(Request.CreateResponse(HttpStatusCode.OK, "ลบข้อมูลเรียบร้อยแล้ว"));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message.ToString()));
}
}
